CM / CMRF / DWH Synchronization

Introduction

As a CM operator or administrator, you might have to solve problems with the Data Warehouse (DWH) in case the synchronization from the CM database to the DWH does not run smoothly. This is why we provide detailed information about the DWH synchronization process, so you can base your error analysis and troubleshooting on this information.

Please also read the ConSol CM Administrator Manual, section Using CM for Reporting - Data Warehouse (DWH) Management for a detailed introduction to the CMRF/DWH administration. In the current section, we assume that you know how to administer the DWH.

Intention when using a DWH

A DWH provides several advantages, the most prominent ones are:

• no need to use the production database for reporting, thus avoiding performance decrease
• a database schema and table structure which is optimized for reporting-typical database queries

A detailed introduction to this topic is provided in the ConSol CM DWH Manual.

ConSol CM system architecture with CMRF and DWH

This is explained in detail in section System Architecture with Reporting Infrastructure.