Introduction

The CXO-Cockpit integration adapters allow you to replicate data from source systems and load that into an OLAP cube. The OLAP cube is then used as main source for reporting in the CXO-Cockpit. All integration adapters have a similar process:

1. Load data from the source system into the Staging Database
2. Processing of the data and loading the data from the staging database into the Fact Database
3. Processing the CXO OLAP Cube with the data from the fact database

The following picture represents this architecture:

Integration Adapter vs. Direct Source Integration

CXO-Cockpit has two different ways to connect to a source system:

• Integration adapter
• Direct source integration

The main difference is that data loaded through an integration adapter is not live. With direct source integration there is no replication and the data is always live. For the following source systems there is direct source integration support:

• Hyperion Essbase - OLAP Connector
• Microsoft SQL Server Analysis Services (SSAS)
• SAP BPC 

Integration Adapters

The CXO-Cockpit has the following source system adapters:

• Oracle Hyperion Financial Management
• Oracle Hyperion Enterprise