9 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.

• Oracle Peoplesoft—Load Actuals from General Ledger.

• Custom on-premises data source—Use an on-premises database adapter and EPM Integration Agent.

• Oracle Autonomous Database—extract source data from staging or other applications running on the Oracle Autonomous Database. You can also export data from the EPM Cloud to selected reporting data warehouses on the Oracle Autonomous Database.

• 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 synchronizes between application in separate business processes.

Note:

For business process to business process integrations, both business processes must be at the same release level.

See also:

• For information on loading data using Data Integration in the EPM Cloud, see Using Data Integration in Planning and Budgeting Cloud.

• For information on loading ERP Cloud Data in the EPM Cloud, see Loading ERP Cloud Data IN EPM Cloud With Data Management.

• To learn more on how to define and run data integrations that load data from Oracle General Ledger to an Enterprise Planning application, see Integrating Oracle Fusion Financials Cloud and Enterprise Planning Cloud using Data Management.

• To learn more on how to define and run data integrations that load data from Oracle General Ledger to an EPM application, see Integrating Oracle Fusion Financials Cloud and Enterprise Planning Cloud using Data Management.