14 Exporting Data

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

To export data, you define an integration with the source as a Cloud EPM 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 Cloud EPM, performs necessary transformations using member mapping and exports the data to the appropriate target application. For more information, see Exporting Data.

  • Quick Mode—Extracts data from the Cloud EPM, 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 more information, see Quick Mode to Export Data.

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)