Data Integrations

Data Integration is the mechanism by which integration processes are performed in Financial Consolidation and Close.

Data Integration is the mechanism by which integration processes are performed in Financial Consolidation and Close. You can define file-based and direct integration sources, create mapping rules to translate source data into the required target format, and execute and manage the periodic data loading process. Common integration tasks are done using an easy-to-navigate interface that supports and conforms to how you work.

You can access Data Integration directly from Financial Consolidation and Close. From the Data Integration page, you can create an integration. You can also run an existing integration to extract data from the source and load it to target based on any filter criteria.

See Administering Data Integration for Oracle Enterprise Performance Management Cloud, and the "Customers Using Oracle Financial Consolidation and Close Cloud" section in Administering Data Management for Oracle Enterprise Performance Management Cloud.

To access Data Integration, you must be a Service Administrator, Power User, or User.

To access Data Integration:

  1. On the Home page, select Applications, and then select Data Exchange.

    The Data Integration page is displayed.

  2. To search for an integration, click Search and search by Name, Location, Source, or Target.

  3. To sort the list of integrations, specify a condition. Sort results can be listed in Ascending order (A to Z) or Descending order (Z to A).

  4. To create an integration, click Create Integration Add button

    , and use the Create Integration wizard to specify the integration details.
  5. To edit an integration, double-click an integration from the list and edit integration details as needed.

  6. To run an integration, select an integration from the list and click Run Run icon.