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

Add Comment
7 Answer(s)

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.

Agile Angel Answered on April 6, 2015.
Add Comment

Can you tel me how to get the Total COs Submitted – by Month from table, I mean which Table?

Agile Talent Answered on April 8, 2015.
Add Comment

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.

Agile Angel Answered on April 8, 2015.
Add Comment

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.

Agile Talent Answered on April 9, 2015.
Add Comment

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.

Agile Angel Answered on April 15, 2015.
Add Comment

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 

Agile Angel Answered on April 15, 2015.
Add Comment

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..

Agile Angel Answered on April 16, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.