Monday, October 4, 2021

ODI - Import and Export techniques

Exporting and importing ODI objects means transferring objects between different repositories. When exporting an ODI object, an XML export file is created. ODI objects have dependencies that will also be exported in the XML export file. 

Exporting one ODI object:

Exporting one ODI object means export one single ODI object in order to transfer it from one repo to another.

Step1: select the object to be exported in the design tab and right click on the object and select export.

Step2: provide the export path, export name and "CHILD components export " this is very important checked it if you want to get the objects linked to the object to be exported. These objects are those visible under the exported object in the tree. And other options as required.

Export Multiple ODI objects:

We can export one or multiple objects at knce using the Export Multiple Objects action. This lets you export ODI objects to a zip file.

Step1: Select Export from the designer, Topology, Security or operator Navigator

Step2: In the export selection dialog, select Export Multiple Options

Step3: Provide directoy path, select Export as a zip file if needed or exported as .xml files directly in the directory. Drag and drop objects to be exported.

Smart Export and Import:

It is recommended to use the Smart Export and Import feature to avoid most of the common issues that are encountered during an export or import such as broken links or ID conflicts. The Smart Export and Import feature is a lightweight and consistent export and import mechanism providing several smart features.

The Smart Export automatically exports an object with all its object dependencies. It is particularly useful when you want to move a consistent lightweight set of objects from one repository to another and when you want to include only a set of modified objects, for example in a patching use case, because Oracle Data Integrator manages all object dependencies automatically while creating a consistent sub-set of the repository.

The Smart Import provides:

• Automatic and customizable object matching rules between the objects to import and the objects already present in the repository

• A set of actions that can be applied to the object to import when a matching object has been found in the repository

• Proactive issue detection and resolution that suggests a default working solution for every broken link or conflict detected during the Smart Import

Perform a smart export:

Step1: Select Export ... from Designer  Topology or Operator tab

Step2:  in the Export selection dialog, select Smart Export. Click ok

Note: This option is only available if you are connected with  a Work repo.

Step3: in the smart export dialog  specify the export parmeters:

Export directory and export file name
Export as Zip.

To Encrypt file
Encoding options: keep default.

Step4: In the Dependencies section, drag and drop the objects you want to add to the smart export from ODI into the selected Objects list on the left. 

The objects to export appears in a tree with all its related parent child objects that are required to support.

Step5: Modify the list of objects to export.

Step6: click export to start the export process

Importing an ODI object:

Step1: In the Navigator, select the object or object node under which you want to import the object. Right click the object and select import and select the type of object to import.

Step2: in the import dialog, select the import type and enter file import directory and select the files to import.

Perform a smart import:

Step1: select import... from the designer, topology or operator tab

Step2: In the import selection dialog, select Smart import. Click ok.

Step3: The smart import wizard opens. In 1st step, select the file and response file(optional).

Step4: In 2nd step, Import actions, verify the result of the matching process and fix eventual issues.

In the Object Match Details section, expand the nodes in the import object column to navigate to the objects available to import during the smart import.

In the Action column, select the action to peform on the object.


In the repository Object column, select the required repo objects.

Check the issue details table and to fix any issue, select Action to perform in the Action Column.

Possible actions to fix issues:
Do not change
Fix link

Step5: Review the import file name and eventual issues and click Finish.

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...