About Using Data Integration and Data Management
Data Integration can be used to perform all tasks that are performed using Data Management.
Data Import Tasks Performed Using Data Integration or Data Management
Use Data Integration or Data Management to perform the following tasks:
-
Load balances
-
Load balances from a fixed-width or delimited file.
-
Load balances from BAI Format Bank Files
-
Load balances from SWIFT MT940 Format Bank Files
-
Load balances from camt.053 Format Bank Statements
See Integrating BAI and SWIFT MT940 Format Bank File Transactions and Balances in Administering Data Integration for Oracle Enterprise Performance Management Cloud.
-
-
Load Reconciliation Compliance transactions
-
Load Transaction Matching transactions
-
Export transactions to a Transaction Matching Target Application
See Adding a Transaction Matching Target Application
Note:
You can also aggregate transaction matching data. See Aggregating Transaction Matching Data -
Load transactions from Bank (BAI) files to Transaction Matching
-
Load transactions from Bank SWIFT MT940 Bank Files to Transaction Matching
-
Load transactions from camt.053 Format Bank Statements
See Integrating BAI and SWIFT MT940 Format Bank File Transactions and Balances in Administering Data Management for Oracle Enterprise Performance Management Cloud.
-
-
Load Exported Journal Entries from Transaction Matching to ERP
Data Import Tasks Performed Using Data Integration Only
Use Data Integration to perform the following Account Reconciliation related tasks:
-
Set up a data integration that allows an incremental data load (not a full refresh of all data points) and replaces a portion of a previous data load by adding a Merge ID in Map Dimensions.
See Adding an Account Reconciliation Merge Balance Dimension in Administering Data Integration for Oracle Enterprise Performance Management Cloud.
Note:
You must add a new Merge ID for each new balance to load in Data Integrationin order to ensure correct drill back results from Account Reconciliation to Data Integration. -
Use the EPM Integration Agent available under Data Exchange to extract data from your on-premises data sources and then load the data directly to the Oracle Enterprise Performance Management Cloud.
Use Data Integration (simplified user interface) by accessing the Data Exchange card under Applications.