Importing and Exporting Components

You can import and export both integrations and lookups to share them between Oracle Integration Cloud Service environments.

See the following topics:

Exporting an Integration

Once you create an integration, you can export that integration as a JAR file for use in other Oracle Integration Cloud Service environments or import the integration into Oracle JDeveloper to perform an advanced XSLT mapper task (for example, creating variables or using templates) that you cannot perform in the mapper. After mapper editing in Oracle JDeveloper is complete, the mapper file can then be imported back into Oracle Integration Cloud Service. You can export an integration from either the Integration Designer or from the Integrations list. You can also export a locked integration.

Note:

You cannot import Oracle Integration Classic and Oracle Integration integrations into Oracle Integration Cloud Service.

To export an integration:

  1. On the Oracle Integration Cloud Service home page, click Integrations.
  2. Find the integration to export in the Integrations list, click the Actions menu, and then select Export.
  3. In the dialog that appears, select Save File, and then click OK.
  4. Save the file to the location you want.
The file is saved with a name that consists of the identifier plus the version number, and an IAR extension.
You can import the exported integration into the XSL Map Editor in Oracle Service Bus. See Importing a Map File into Oracle JDeveloper.

Note:

Lookups referenced using the lookupValue function in the Expression Builder are included in the exported integration JAR file. When you import the integration, the referenced lookups are also imported and are visible in the Expression Builder.

Importing an Integration

You can import integrations that were previously exported as a JAR file from Oracle Integration Cloud Service.

Note:

  • You cannot import Oracle Integration Cloud (user-managed) and Oracle Autonomous Integration Cloud integrations into Oracle Integration Cloud Service.

  • You cannot manually edit an exported integration (IAR) file outside of Oracle Integration Cloud Service and then import it into another instance. For example, if you manually update a connection name in an exported integration, then import it, the connection created cannot be updated or deleted. If you need to modify the file, contact Oracle Support Services.

To import an integration:
  1. On the Oracle Integration Cloud Service home page, click Integrations.
  2. In the banner, click Import.
  3. In the Import Integration File dialog, click Browse to navigate to and select the file to import.
  4. Click Import.
    If an integration already exists with the same identifier and version, you must confirm whether to overwrite the existing integration.
The imported integration appears in the Integrations list and you can customize or activate it.

Note:

Even though the Activate icon is enabled after you import an integration, you must first configure your connection endpoints. If you do not, you receive an error when trying to activate the integration. See Editing a Connection and Adapter Configuration Reference.

Exporting a Lookup

Once you create a lookup, you can export that lookup for use in other Oracle Integration Cloud Service environments. You can export a lookup from either the Lookup Designer or from the Lookups list.

To export a lookup:
  1. On the Oracle Integration Cloud Service home page, click Lookups.
  2. Select the Actions menu to the right in the lookup’s row, then select Export to CVS.
  3. In the dialog that appears, select Save File, and then click OK.
  4. Save the file to the location you want.
The file is saved as a CSV file with the same name as the lookup.

Importing a Lookup

You can import lookups that were previously exported from Oracle Integration Cloud Service.

The file to import must have the following for the first row, where table_name is the name of the table as you want it to appear in Oracle Integration Cloud Service. This name cannot contain spaces.
DVM,table_name

The second row contains the names of the adapters that are being mapped. Use the following case-sensitive IDs for each adapter:

Adapter Name Identifier to Use in the Import File
Oracle Eloqua Cloud eloqua
Oracle Sales Cloud osc
Oracle Messaging Cloud Service oms
Oracle RightNow Cloud rightnow
Oracle HCM Cloud hcm
Oracle ERP Cloud erp
Salesforce Cloud salesforce
To import a lookup:
  1. Locate the CSV file containing the lookup table you want to import.
  2. On the Oracle Integration Cloud Service home page, click Lookups.
  3. In the navigation pane, click Integrations, then click Lookups.
  4. In the banner, click Import.
  5. In the Import Lookup dialog, click Browse to navigate to and select the CSV file to import.
  6. Click Import.
    If a lookup already exists with the same identifier and version, you must confirm whether to overwrite the existing lookup.
The imported lookup appears in the Lookups list on the left. You can customize or activate it, if it is ready.