Continuous Delivery Automation

Expand all | Collapse all

Where can we find Database Schema documentation for CDA tables?

  • 1.  Where can we find Database Schema documentation for CDA tables?

    Posted 04-15-2019 05:27 PM

    Is there documentation available for database schema with description for CDA database tables similar to what available for Automation Engine database?

     

    Something like this --> AE Database Scheme for Version 12.2 (Step 020) 

     

    Thanks.



  • 2.  Re: Where can we find Database Schema documentation for CDA tables?

    Posted 04-16-2019 08:04 AM

    Hi Vlad_N

     

    We do not provide for CDA these types of information (e.g. DB schema).



  • 3.  Re: Where can we find Database Schema documentation for CDA tables?

    Posted 05-06-2019 11:47 AM

    Hi Vlad_N,

     

    do have a look at CDA's Reporting capabilities?

    You can define reports that offer a stable layout.

     

    Docu: Integrating > Reporting

    https://docs.automic.com/documentation/webhelp/english/ARA/12.2/DOCU/12.2/CDA%20Guides/Default.htm#CDA/Admin/Admin_Repor… 



  • 4.  Re: Where can we find Database Schema documentation for CDA tables?

    Posted 05-06-2019 02:22 PM

    Thank you for information.

     

    We already utilize some of the ARA/CDA Reporting capabilities that you have linked above.

     

    "CDA System Properties Reference" section is usefull to figure out how some objects relate.

    https://docs.automic.com/documentation/webhelp/english/ARA/12.2/DOCU/12.2/CDA%20Guides/Default.htm#CDA/SystemProperties/SystemProperties.htm%3FTocPath%3DReference%7CCDA%2520System%2520Properties%2520Reference%7C_____0

     

    Often we have to generate reports that have data from ARA/CDA and AE DBs tables combined.

     

    For example, count of CDA/ARA Executions where there is some specific string within report (RPT) files for the JOBS that related to that CDA Execution.

     

    We don't have yet Analytics configured, so this is probably next logical step to get better integrated reports.

    https://docs.automic.com/documentation/webhelp/english/ARA/12.2/DOCU/12.2/CDA%20Guides/Default.htm#Analytics/ANOP_Admin/…