Introduction

The Oracle EPM Cloud Integration Adapter integrates with Oracle EPM Cloud source by exporting the data and meta-data and loading it through a SQL Server database into a SQL Server Analysis Services (SSAS) database. After a data-export the resulting OLAP Cube can be used standalone without a live connection to Oracle EPM Cloud.

Architectural overview

...

Oracle EPM Cloud Adapter is retrieving metadata and data from the Oracle EPM Cloud source by starting jobs at the source’s side and later downloading metadata and data files. The extracted data is then transformed and loaded into a fact database that is connected to a SSAS cube. This cube providing the information to show reports in the CXO Dashboard.

...