Setting Up an Integration

To set up an integration:

  1. On the Data Integration home page, click Image shows the Add icon. (Add drop-down icon) and then click Integration.

  2. On the Create Integration window, specify the Name, Location, Description, Quick Mode, Source, Target, and Category. For details, see Creating Direct Integrations.
  3. Click Save and Continue.
  4. In Map Dimensions, map the columns in the data source to dimensions in the target application. For details, see Mapping Dimensions .
  5. Click Save and Continue.
  6. In Map members, map the dimensions to identify how source field values translate to target dimension members. For details, see Mapping Members.
  7. Click Save and Continue.
  8. In Options, define the options for importing and exporting data. Also, define any source filters. For details, see Setting Data Integration Options.
  9. Click Save.

To run the integration, see Running Integration to Load Data from Oracle Autonomous Database to Cloud EPM Without an Agent.