1. Administrator's Guide
  2. Integrating Data
  3. Data Load, Synchronization and Write Back
  4. Overview

Overview

Oracle Hyperion Financial Data Quality Management, Enterprise Edition supports a variety of ways for importing data from a range of financial data sources, and then transforming and validating the data:

  • Data Loading—define the mappings from a source system to a target system; drill through and view data in the ERP source system from an EPM target application; load data from file-based source systems to an EPM target application; define data load rules, which describe how to extract and push data from source to target systems.

  • Synchronizing—move data between the EPM applications irrespective of the dimensionality of the application without having to create a data file from the EPM source application.

  • Write-back—write-back budget data to the source system from all EPM applications to ERP applications. This feature offers significant advantages, such as writing back budgets created in Oracle Hyperion Planning to Peoplesoft or the Oracle E-Business Suite ERP GL, or moving adjustment journals from Oracle Hyperion Financial Management to ERP systems like E-Business Suite or Peoplesoft. Write-back budget data is also available to a file-based source system from Planning, Oracle ASO Essbase, and Essbase ESO applications.