Upgrade Guide › Upgrading Databases › Enabling the Data Warehouse

Enabling the Data Warehouse

The Data Warehouse is a set of database tables containing CA DLP event data that has been transformed into a format suitable for generating reports and iConsole dashboards. When you upgrade your CMS to the current version of CA DLP, the installer creates but does not enable the Data Warehouse.

How To Enable the Data Warehouse After Upgrading CA DLP

Enabling the Data Warehouse requires the following steps. You must perform these steps in the order listed below. Details are provided in the following sections.

1. Create the Data Warehouse User database account.
2. (Optional) Create the Unrestricted Search User database account.
3. Enable the Data Warehouse.
4. (Optional) Enable the Event Participant Fact table in the Data Warehouse.

More information:

Specify the Data Warehouse User

Specify the Unrestricted Search User

Manually Enable the Data Warehouse

Enable the Event Participant Fact Table