ERD for CA Configuration Automation database

Products

• CA Configuration Automation

Issue/Introduction

We would need the ER diagram of the database. We want to create reports using JasperReport Server. We can generate the table descriptions in SQL Server (SSMS), but the descriptions have no relationships.

We need the ER diagram to build the SQL queries with the appropriate joins.

 

Environment

CA Configuration Automation all versions

Resolution

Currently there is no publicly available ERD for CCA. If you would like to know some fields on certain table(s), please contact Broadcom Support. 

Additional Information

These techdocs do have some mappings info: 

CCA to SDM Integration CI Mapping

CCA to CMDB Integration Attribute CI Mapping

CCA to CMDB Integration Relationship CI Mapping