Portal User Guide › Using Administration Functions › How to Extract CA RCM Data

How to Extract CA RCM Data

You can extract CA RCM data to the CA RCM External Report Database. Third-party reporting and data-mining applications can draw on this database to generate reports or perform analysis. Each extracted data snapshot is a static copy of CA RCM objects. CA RCM does not update the data snapshots after they are created.

You perform these procedures when you work with data extraction:

• Enable the External Report Database–Create the database and enable the feature on the CA RCM server.
• Create an extraction profile that defines the types of data files that are copied to the external report database.
• Generate a data set, or snapshot, based on an extraction profile. You can schedule automatic generation of a data set at a fixed time or at recurrent intervals. Each data set is labeled with the name of the profile used to generate it and a timestamp.
• Track data extraction jobs–Data extraction jobs appear in the inbox of the administrator who runs/schedules them.
• Delete profiles and data snapshots when they are no longer needed. You can delete individual data sets, or schedule deletion at a future date.

Extraction profiles are similar to data connectors, and you use the job scheduling tools of the portal to initiate data snapshots like data connector jobs.

The data schema of the External Reporting Database is located in the CA-RCM-rel#-Language-Files.zip file of the CA RCM installation package.