Upgrade Guide › Upgrading Databases › Retrospectively Enable a Data Warehouse After Upgrading

Retrospectively Enable a Data Warehouse After Upgrading

If you did not enable the data warehouse in a previous version of CA DataMinder, the data warehouse remains disabled when you upgrade to the current version of CA DataMinder. However, you can manually enable the data warehouse.

How To Manually Enable the Data Warehouse After Upgrading CA DataMinder

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. (Optional) Specify the Data Warehouse User database account.

   You only need this database account if you intend to run BusinessObjects reports.

2. (Optional) Specify the Unrestricted Search User database account.

   You only need this database account if you intend to run BusinessObjects reports.

3. Manually enable the data warehouse.
4. (Optional) Enable support for BusinessObjects reports:
   1. Enable the Event Participant Fact table.

      This table allows the data warehouse to collect event participant data.

   2. Resync the Event Participant Fact table or Truncate and Repopulate the Data Warehouse.

      You must perform one of the tasks. The task that you need depends on your CMS purging strategy.

Note: For full details about managing the data warehouse, including advanced configuration for data warehousing jobs, see the 'Data Warehouse' chapter in the Platform Deployment Guide.

More information:

Specify the Data Warehouse User

Specify the Unrestricted Search User

Manually Enable the Data Warehouse

Enable Support for BusinessObjects Reports