How to use Agile Database for External Reporting
Hi All,
Can you tell me how to get the data from Agile to generate the report like Total COs Submitted – by Month.
Thanks
Divakar
The BI tool can be used if it is integrated with Agile DB. PL/SQL can be used to pull out the required data and sent to external users.
In Agile 9.2.2.4 there are some standard reports that you can use :
1. Change Backlog Report that : Counts the changes that were at a specified status but have not moved to another specified status during a time period.
2. Cycle Time Report that : Determines the time it took changes to move from one specified status to another during a time period..
3. Change Metrics Report : Counts the changes that were moved to a specified status during a time period.
Hi, Yes these reports are available, But i mentioned to extract the Data and show it in some BI Tool. how to do that?
Some one should know about the Agile Db very well.
Can i know what and all Tables i can look into to get the data.
Going through the tables is possible but requires sometime to understand the underlying structure and relationship.
You can start looking into the tables like item, rev, change, PAGE_TWO, PAGE_THREE, listentry & nodetable.
You can also start looking into the pre-built views to understand how the tables are joined and so on.
Hope this helps.
Try CHANGE table in the Agile DB where CHANGE_NUMBER LIKE ‘%CO%’. You can also look for the tables from the Attribute Base IDs column from Java Client
You can also write SDK Programs to fetch the data and store them in staging tables and provide them as input to the BI Tool. Even though the performance will be slow this is the safest way (in my view) and supported by oracle support.
Extracting from DB will improve the performance however the DB changes are not published and you have to be careful when you apply any patch or upgrade the version.
To get the Change Number, you have to refer the Change Number Table and for getting the sign off information you need to refer the signoff table. Some of the values in the tables will be having numbers instead of values. Value to be retrieved from property tables..
