Sankar Sakthivel's Profile
Agile Angel
1170
Points

Questions
0

Answers
21

  • RE: How to use Agile Database for External Reporting
    Agile Angel Asked on April 16, 2015 in Agile PLM (v9).

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

    • 2885 views
    • 7 answers
    • 0 votes