Cloud

Using ODI Multiple Export Utility

shutterstock_230238832

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.

Process:

  • 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

Steps:

Export:

Click on export in Designer

1

Select Export Multiple Objects

2

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.

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

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.

3

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

Import:

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

4

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

5

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

6

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

7

Select the Import type and the export directory, Even though export.zip 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 %
Automotive70.03
Energy and Utilities140.06
Financial Services and Insurance470.21
Healthcare and Life Sciences600.27
Manufacturing140.06
Retail220.1
Other580.26
Total Responses: 222 of 428 (52%)
About the Author

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

Leave a Reply

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

Subscribe to the Weekly Blog Digest:

Sign Up
Categories