I have an incredibly powerful reporting dashboard for analyzing the Task and Work Product and Portfolio Item data that my organization creates using Rally. I built this with the Tableau reporting tool. The only shortcoming is that the data source is an Excel spreadsheet. I have to use a Rally "Custom List (formerly Custom Grid)" page for each object - User Story, Defect, Task, Projects, etc... - to export the data to Excel, and then I connect to the Excel workbook with Tableau to build my dashboard. Hence, every time I want to refresh my reportable data, I have to go through the manual process of Exporting from Rally to multiple Excel files, then compile those excel files into one Excel workbook as the data source for Tableau. I takes a good hour or so.
What options are there for establishing a live or near-real-time connection to the data for my organization in Rally?
We recently released the CA Agile Central Database Connector | CA Agile Central Help . You may be able to set this up so it runs via a cron job or something to update the PostgreSQL database on a set interval. It does use .csv files, so you may also be able to just use those as well.
Hope that helps.