Rally Software

Expand all | Collapse all

How can I connect to real-time Rally data - SQL/SSMS?

  • 1.  How can I connect to real-time Rally data - SQL/SSMS?

    Posted 10-19-2017 07:37 PM

    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?



  • 2.  Re: How can I connect to real-time Rally data - SQL/SSMS?

    Posted 10-20-2017 03:19 AM

    clide,

     

    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.

     

    Michael