Skip to main content


Using ODI Multiple Export Utility


This post explains the process of using ODI Export Multiple Objects utility to export selected multiple ODI objects and importing them individually.

ODI introduced a new feature ‘Smart Export’ from version 11.1.16, This feature automates the process of exporting/importing all objects related to your change, As BIAPPS OOTB ODI repository contains thousands of objects smart export will export so many related objects and makes export/import list huge. If we are sure about the change done and list of related objects to be migrated, it’s better to use ODI Export Multiple Objects utility to keep export/import list small.


  • Export all objects (Project Folders, Packages, Varaibles and Tables etc) need to be migrated into a zip file.
  • Import objects (Model Objects, Variables, Procedures, Project Objects, Load Plans) separately



Click on export in Designer


Select Export Multiple Objects


Drag and Drop all objects (Project Folders, Packages, Varaibles and Tables etc) need to be migrated. There is no specific order needs to be followed while dragging ODI objects.

Enable the check box ‘Export as Zip file’ and ‘Export Child Objects’.

Click on save icon to save the list of objects exported. It generates a .lst file. This .lst file can be used to export same list of objects multiple times in multiple environments ex: we can use the .lst file generated in DEV to export same objects from Test ODI repository.


Click ‘OK’. All selected objects will be exported to a zip file and saved at location mentioned.


Different ODI objects like Project folders, Packages, Intefaces, Variables and Models can be exported together, however different ODI objects need to be imported separately.

Always follow below order to import ODI objects

  1. Model Objects
  2. Variables
  3. Procedures
  4. Project Objects
  5. Load Plans

To import an object in Oracle Data Integrator, go to Designer and select the object or object node under which you want to import the object.

Right-click the object, and select Import, then the type of the object you wish to import.

To import datastore, go to Model right click on folder and click import datastore


To import Variable, go to Projects, right click on Variables and click import Variable


To import Folder, right click on project and click import folder


To import Loadplan, go to Loadplans and Scenarios section, right click on loadplan and click import loadplan


Select the Import type and the export directory, Even though contains all objects, import screen will show objects based on the import object type, this makes selecting objects easier.

Import modes and Description from Oracle documentation are provided below

What industry are you in?

AnswerTotal NumberTotal %
Energy and Utilities140.06
Financial Services and Insurance470.21
Healthcare and Life Sciences600.27
Total Responses: 222 of 428 (52%)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Ashwin Pittampally

10 years of experience doing analysis, design, development and implementation of Oracle Business Intelligence applications and ETL solutions using Informatica, DAC, ODI. Worked extensively on Oracle BIAPPS Implementations, SQL querying and Stored Procedures using PL/SQL. Worked on Functional Areas - HR, Finance, Service and Marketing Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics, Enterprise Healthcare Analytics (EHA) and OHADI (Oracle Healthcare Analytics Data Integration)

More from this Author

Follow Us