Introduction

The CXO 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. The integration adapters have the following process:

Load data from the source system into the Staging Database
Processing of the data and loading the data from the staging database into the Fact Database
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 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.

Browser not supported