Versions Compared

Version Old Version 5 New Version 6
Changes made by

Matija Lukic (Deactivated)

Matija Lukic (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Image RemovedImage Added

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

  • To be added