5 Defining a Data Integration

You define a Data Integration by extracting metadata and data from an Enterprise Resource Planning (ERP) source system (a direct integration) or data from a file, and then pushing it to an Enterprise Performance Management (EPM) target application.

File-based imports are supported for those users who do not have a direct connection to their Enterprise Resource Planning (ERP) source data but have data available from their sources in a text file. Any file, such as a delimited file, can be easily imported into a target EPM application. You can select where the account, entity, data values reside in the file, as well as which rows to skip during the data import. This feature enables a business user to easily import data from any source, and requires limited technical help, if any, when loading into a target application.

For information on file-based integrations, see Creating File-Based Integrations.

For customers who have a direct connection to other Oracle Cloud Services (out of the box or packaged integrations), define the source data, create mapping rules to translate data into the required target format, and execute and manage the periodic data loading process.

For direct integration-based sources, the import and export of data can be from:

  • Oracle ERP Cloud—General Ledger. Load Actuals from General Ledger and write-back Budgets and Actual Adjustment Journals

  • Oracle ERP Cloud—Budgetary Control. Load commitments, obligations, and expenditures and write-back Budgets

  • Oracle ERP Cloud—Sub-Ledgers. Load sub-ledger transaction data

  • Oracle NetSuite—Load actuals and metadata from Oracle NetSuite

  • Oracle Human Capital Management Cloud—Load Employee attribute, salary and other related Job information

  • Oracle E-Business Suite— Load Actuals from General Ledger. Use EPM Integration Agent

  • Oracle Peoplesoft—Load Actuals from General Ledger. Use EPM Integration Agent

  • Custom on-premise data source—Use On Premise Database adapter and EPM Integration Agent

  • Local Oracle Enterprise Performance Management Cloud applications—Data synchronize between Input and Reporting Cubes moving data between different Input Cubes

  • EPM Cloud applications from another service instance—Data synchronize between Application is separate instances

See also: