Importing and Exporting Components

You can import and export both integrations and lookups to share them between 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 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 Integration Cloud Service mapper. After mapper editing in Oracle JDeveloper is complete, the mapper file can then be imported back into Integration Cloud Service. You can export an integration from either the Integration Designer or from the Integrations list.

To export an integration:

  1. On the toolbar, click Designer.
  2. On the Designer Portal, click Integrations.
  3. Do one of the following:
  4. In the dialog that appears, select Save File, and then click OK.
  5. 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.
For information about importing an exported integration into the XSL Map Editor in Oracle Service Bus, see Importing a Map File into Oracle JDeveloper.

Importing an Integration

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

To import an integration:
  1. On the toolbar, click Designer.
  2. On the Designer Portal, click Integrations.
  3. Above the Integrations list, click Import Integration.
  4. In the Import Integration File dialog, click Browse to navigate to and select the file to import.
  5. 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 button 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. For information about editing connections, 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 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 toolbar, click Designer.
  2. On the Designer Portal, click Lookups.
  3. Do one of the following:
    • Locate the lookup to export in the Lookups list on the left side of the page. Click the vertical lines icon to the right in the lookup’s row, and select Edit. In the upper right corner, click Actions, and select Export.
    • Locate the lookup to export in the Lookups list on the left side of the page. Click the vertical lines icon to the right in the lookup’s row, and select Export to CVS.
  4. In the dialog that appears, select Save File, and then click OK.
  5. 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 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 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 toolbar, click Designer.
  3. On the Designer Portal, click Lookups.
  4. Above the Integrations list, click Import Lookup.
  5. In the Import Lookup File 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.