Portal User Guide › Using Administration Functions › How to Extract CA RCM Data › How to Enable the External Report Database

How to Enable the External Report Database

Extracted data is stored in a dedicated SQL database on a Microsoft SQL Server database server. Follow these steps to enable the external report database:

1. Create the database on a Microsoft SQL Server.
   • When a Microsoft SQL Server hosts CA RCM databases, select the External Report Database option of the CA RCM installer to automatically create this database.
   • When an Oracle database server hosts CA RCM databases, create the External Report Database on a Microsoft SQL Server instance after you install CA RCM.

     Note: For more information about creating the External report database, see the Installation Guide.

2. To enable data extraction, set the following CA RCM system parameter to True.

   reportdb.enabled

   Specifies whether CA RCM saves data snapshots to the external report database.

   Valid values: True, False

   Note: CA RCM resets this property to False when it cannot export a scheduled data snapshot to the database. If the connection to the database server is interrupted, reset the property to True when the connection is restored.