14 Exporting Data

Data Integration provides the tools for exporting data from an Oracle Enterprise Performance Management Cloud business process to a file, on-premises database, or Oracle Autonomous Database

To export data, you define an integration with the source as a EPM Cloud business process and the target as one of the data export applications.

When exporting data, use one of the following modes:

• Standard Workflow Mode—Extracts data from EPM Cloud, performs necessary transformations using member mapping and exports the data to the appropriate target application.

• Quick Mode—Extract data from the EPM Cloud, performs simple transformations using Import Expressions and exports the data to the appropriate target application. In this mode data is not imported to the staging tables and data is directly processed so the performance is significantly better. This mode is also ideal for exporting very large data volumes.

For both Standard and Quick Mode methods, you can extract data from a source based on the Essbase storage option using one of the following methods:

1. All Data – ASO or Hybrid enabled BSO
2. Stored Data - BSO
3. Stored Data with Dynamic Calc - BSO
4. Level 0 Data – ASO and BSO (only available for Quick Mode)