Installing and setting up CMRF and DWH

The ConSol CM Reporting Framework (CMRF) and Data Warehouse (DWH) are the modules which are required to provide the basis for Business Intelligence (BI) and reporting in ConSol CM. Please see System architecture for an overview of the required components.

The CMRF is a distinct Java EE application. It can either be deployed in the same application server as used for the CM application or be executed as a standalone application.

Please carry out the following steps to set up the CMRF and DWH:

1. Prepare the DWH database, see section Setting up the database for CMRF / DWH.
2. Install the CMRF, see section Installing the CMRF.
3. Configure the data warehouse, see section Configuring the DWH.

When you have installed and filled the data warehouse, you can use any reporting or business intelligence tool of your choice to retrieve data from this database.