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.
| Table of Contents |
|---|
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.
In order to define which data should be extracted when, the integration administrator sets up the adapter using a web-based Configuration UI. This UI also allows applying some filtering and transformations on the extracted data. Once the Adapter is set up, the CXO Software Agent will (per user-defined extraction schedule) invoke the adapter to start the extraction process.
Prerequisites
To be added
Installation
To be added
User guide
Setting up Oracle EPM source in CXO
To be added
Accessing Configuration UI (WIP)
Access to the Configuration UI is restricted only to CXO Admins. Other users are not authorized to see these pages.
FAQ
...
| Child pages (Children Display) |
|---|