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?