Automic Continuous Delivery Automation

  • Private Community

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

    Posted Apr 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?

    Broadcom Employee
    Posted Apr 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?

    Broadcom Employee
    Posted May 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 May 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/…  



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

    Broadcom Employee
    Posted Jul 19, 2019 05:24 AM
    Hi Vlad,

    • The CDA DB has a flat DB structure. This is not a DB intended to be leveraged by 3rd party applications. There is no guarantee that the entities in the DB are consistent as they change over time.
               CDA entities can be consolidated via CLI and posted in a table see : 

    https://docs.automic.com/documentation/webhelp/english/ARA/12.2/DOCU/12.2/CDA%20Guides/Default.htm#CDA/Admin/Admin_Reporting.htm%3FTocPath%3DIntegrating%7CReporting%7C_____0
    • Exporting this data to a reporting DB would be the way to go. You could set up a : PostgreSQL, MS SQL DB or an Oracle DB to collect the data.

    Kind Regards,
    Paul

    ------------------------------
    Product Line Manager  | Continuous Delivery Automation & Release Automation

    Enterprise Software Division
    Broadcom

    office: +43 (0) 570 810 1124  | mobile: +43 (0) 664 120 3179
    Am Europlatz 5  | Vienna, Austria, 1120

    Paul.Meresanu@broadcom.com   | broadcom.com
    ------------------------------

    Original Message