Populate the Data Warehouse

Platform Deployment Guide › Data Warehouse › Populate the Data Warehouse

Populate the Data Warehouse

BusinessObjects reports for CA DLP and iConsole dashboards are based on event data in the data warehouse. CA DLP populates the data warehouse with event data as soon as possible after the BusinessObjects Integration feature or the iConsole dashboard have been installed or upgraded.

When you install the data warehouse, CA DLP automatically creates scheduled jobs to populate the data warehouse with event data. The following sections describe the default configuration for data warehousing jobs and how to reschedule or customize these jobs.

Note: If your data warehouse is hosted in a SQL Server Express database, you must manually enable and schedule the data warehousing jobs.

When you install the data warehouse, CA DLP automatically creates scheduled jobs to populate the data warehouse with event data.

Default Settings for Data Warehousing JObs

When the data warehouse is enabled, CA DLP automatically schedules jobs to populate the data warehouse with event data. By default, these data warehousing jobs run during a daily off-peak processing window. Depending on the system configuration, typical processing speeds can be up to a 200,000 events in 5 minutes.

On CMSs with less than 100,000 events, CA DLP processes all events when the scheduled job first runs.
On CMSs with over 100,000 events, CA DLP prioritizes events captured in the last 3 days. CA DLP process these events when the scheduled job first runs. It then gradually processes the remaining older events whenever a scheduled job runs.

By default, the off-peak processing window starts at midnight and lasts for 300 minutes. See the 'Advanced Configuration' section for details.

Note: If your data warehouse is hosted in a SQL Server Express database, you must manually enable and schedule the data warehousing jobs.

More information:

Enable the Data Warehouse on SQL Server Express CMSs