Open topic with navigation

Architecture of a CM System with DWH

In order to allow Business Intelligence (BI) tools or other applications to build specific reports, OLAP cubes, and other analyses, ConSol CM provides a data warehouse (DWH) as one of its standard components. The DWH is a separate database (or database scheme, see below). The DWH is filled by a Java EE application called ConSol CM Reporting Framework (CMRF).

The ConSol CM standard function set comprises two components which enable reporting:

• CMRF (ConSol CM Reporting Framework)

  This is a Java EE application which synchronizes the ConSol CM database with the ConSol CM data warehouse (DWH). The CMRF can be deployed into the same application server as the core CM or it can be run on a separate application server. We recommend using two application servers when working with JBoss systems and one application server when using Oracle WebLogic. The synchronization of CM data with the DWH can be based on JMS (Java Messaging Service) queues or on direct messaging. For a detailed explanation, please refer to the ConSol CM Operations Manual.

• DWH (data warehouse)

  The ConSol CM DWH is a relational database which can be operated as Oracle, Microsoft SQL Server, or MySQL system. It stores the integrated/pre-processed data from the ConSol CM database.

  A detailed list of supported operation systems, application servers, database systems, and other systems, as well as storage and CPU requirements is given in the current System Requirements.

Separate application servers for ConSol CM and CMRF (standalone mode):

Figure 494: ConSol CM - Infrastructure with CMRF and DWH (2 servers)

One application server for ConSol CM and CMRF (overlay mode):

Figure 495: ConSol CM - Infrastructure with CMRF and DWH (1 server)

When the DWH has been established, BI (Business Intelligence) applications can be used to create reports, data cubes, and other reporting output formats. Please see the following example with the Pentaho^TM BI Suite.

Separate application servers for ConSol CM and CMRF (standalone mode):

Figure 496: ConSol CM - Reporting infrastructure (2 servers)

One application server for ConSol CM and CMRF (overlay mode):

Figure 497: ConSol CM - Reporting infrastructure (1 server)

DWH Database

Oracle

One database scheme with one database user is used by the DWH.

Microsoft SQL

One database scheme with one database user is used by the DWH.

MySQL

One database with one database user is used by the DWH.