Oracle EPM Cloud Adapter - Architectural overview

Open

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.