Administration Guide › Tools › Configure the Data Warehouse

Configure the Data Warehouse

The Data Warehouse is a set of database tables containing CA Data Protection event data that has been transformed into a format suitable for generating reports and iConsole dashboards.

The Data Warehouse is installed automatically when you install a new CA Data Protection CMS, but you must explicitly enable the data warehouse if you want to use the iConsole dashboard or run BusinessObjects reports for CA Data Protection.

You can also reconfigure the Data Warehouse if it is already enabled. For example, you may want to change the settings for off-peak processing jobs or data purges.

To configure the Data Warehouse

1. Log on to the Administration console using an account that has the 'Admin: Manage security models' privilege.
2. Click Tools, Configure Data Warehouse.
3. Configure the following settings:

   General Options

   These settings enable or disable the Data Warehouse. They also specify which data gets copied into the Data Warehouse. In particular, they specify whether to include event participant data. Other settings enable regular purges of older data from the Data Warehouse.

   Important! You must collect event participant data if you intend to run BusinessObjects reports..

   Additional Population and Maintenance

   These settings configure off-peak processing jobs for the Data Warehouse.

   Advanced Options

   These settings configure batch sizes for data warehousing jobs. Other settings enable you to resynchronize the Data Warehouse with data in the CMS database or to purge and repopulate the entire Data Warehouse.

Note: For further details, see the Platform Deployment Guide; search for 'data warehouse'.

More information:

Set Credentials for the Reporting User