Rally Software

  • 1.  How to automate reports from CA Agile?

    Posted Feb 16, 2018 05:48 PM

    We're currently pulling reports from CA Agile about all sorts of metrics(stories per sprint, points per team, etc) and putting it all into an excel file manually and doing our data manipulation there. Is there a way we can automate the process of building the report from Agile? If there is a way to connect reports being generated to either a DB/Table, or at the least email a csv on a schedule, it would remove the need to constantly manually build the report.



  • 2.  Re: How to automate reports from CA Agile?
    Best Answer

    Posted Feb 17, 2018 08:30 AM

    bharath.rajaram,

     

    There is currently not a way to automate pulling or emailing reports, but you could certainly use the new Database Connector and set up a script to pull the data.

     

    Michael



  • 3.  Re: How to automate reports from CA Agile?

    Posted Feb 19, 2018 12:05 AM

    Thanks! Would that db be able to pull in the actual report, or would it take the raw data the reports in Agile are built from, meaning I'd have to add in the manipulation to build the report again?



  • 4.  Re: How to automate reports from CA Agile?

    Posted Feb 19, 2018 06:35 AM

    These still use the API to pull the data the reports are built from, not the actual report.

     

    Michael