Creating Direct Integrations

Shows how to define a direct connection to the Oracle Fusion Cloud EPM (out of the box or packaged integrations), map the source data to a target application, Cloud EPM application and then load the data.

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.

To create a direct integration:

  1. From the Data Integration home page, click Image shows the Add icon. (Create), and then select Integration.

    The General page is displayed in Create Integration view.

  2. In Name and Description, enter a name and description for the new direct integration.
  3. In Location, enter a new location name, or pick an existing location to specify where to load data.

    A location is used to link a Source and Target along with the associated member mappings. You can define multiple integrations within a same location with different set of Options and Filter criteria. The location is primarily used to control access to an integration. You can use Location Security to control access to end users.

    If you enter a new location, you must provide the Source and Target. When you save the integration, Data Integration creates the location automatically.

    If you select an existing location, Data Integration populates the Source and Target values automatically and you cannot change them.

  4. Click Image shows the Source icon. (Select a Source).
  5. From the Select a Source page, select the direct integration source system.
  6. Click Image shows the Target icon. (Select a Target).
  7. From the Select a Target page, select a target application.
  8. From Location Attributes, specify type of data is loaded by location.
    For example, you can select a functional currency such as the US dollar.

    For more information, see Defining Location Attributes.

  9. From Category, select the category that categorize and maps source system data to a target Cloud EPM Scenario dimension member.

    For more information, see Using Category Mappings.

  10. Click Save.