New Feature in ODI Smart Export and Import

By Jayant Mahto

Oracle Data Integrator introduces a major new feature called Smart Export and Import. This post will give you an overview of this feature.

ODI export and import feature has been used in previous releases to move ODI objects in and out of ODI repository. Smart Export and Import builds on top of the existing ODI capabilities to avoid common pitfalls and guide end users through the process.

Let’s take an example of an ETL developer who wants to export two interfaces (Load_Dept and Load_Sales) to another repository. One of these interfaces (Load_Dept) uses a temporary interface (Load_Dept_temp_interface) and there are associated Data Stores and Model for source and target.

Let’s take an example of an ETL developer who wants to export two interfaces (Load_Dept and Load_Sales) to another repository. One of these interfaces (Load_Dept) uses a temporary interface (Load_Dept_temp_interface) and there are associated Data Stores and Model for source and target.

The following screenshots gives you an example with 2 interfaces that need to be exported.

By doing a Smart Export of these two interfaces we can create an export file which has all the dependent objects. In this case temporary interface Load_Dept_temp_interface and Data Stores from Model Sources will be exported in the same xml export file. The dependency is discovered by the smart export process and there is no need to export all the dependent objects one by one.

On the import side the same export file will be used to do a Smart Import. The Smart import process finds the objects in target repository that best matches with the objects in the export file and provide action choices to the end user. These choices are Merge, Overwrite, Create Copy, Reuse or Ignore. It is also possible that there may be some mismatches and Smart Export gives warning messages and action options to fix it. The resolution actions are Ignore, Change, Do not change and Fix Link.

User can also save the actions in the response file which can be used in the silent mode.

In earlier releases import of individual objects required a careful planning of exported objects and import order of the objects based on dependency. The new Smart Export and Import process makes this task very simple.

You will find instructions about how to use Shortcuts in the Oracle Data Integrator documentation at: Smart Export and Import.

You can find an overview of all the new features introduced in ODI in the following document: ODI New Features Overview.



Does this mean that if we choose a package under smart export, it will copy all the interfaces called by it, all the variables used by interfaces and the package, all models/datastores used by those interfaces? Then this must be a fantastic option.

Posted by Sid on March 21, 2012 at 02:08 PM PDT #

Hi Sid,

Yes, Smart Export will analyze all the dependencies for your package and add to the export file: interfaces, variables, KMs, User Functions, Models and Datastores used in the interfaces as well as any Topology objects required.


Posted by Julien on March 23, 2012 at 06:31 AM PDT #


I'm a little unclear as to the differences between Smart Export and Solutions. Could you briefly contrast these two features?

Posted by Gerry Jurrens on July 26, 2012 at 01:11 PM PDT #

Hi Jayant, Julien,
Are there Java APIs such as ODISmartExportObject, ODISmartImportObject available to do the smart export and import similar to ODIExportObject & ODIImportObject? If so, this will be very useful to do the export/import repositories through a script launched through oracle universal installer.

Posted by Daniel on October 01, 2012 at 07:54 AM PDT #

Hi Daniel,

Yes, there are SDK methods available to automate the process such as ISmartImportService or ISmartExportService. Those Java methods can be used in scripts.
You can find the ODI SDK documentation at


Posted by Julien on October 05, 2012 at 12:18 PM PDT #

Hi Julien,
Is there a command tool available for SmartImport (Similar to OdiImportObject)? We need to use the command to use in script to facilitate the installation.


Posted by vignesh on April 08, 2013 at 01:27 AM PDT #

Hi Vignesh,

See my previous reply there are no command line tools available for Smart Import but the ODI SDK has Java classes to automate such operations. You could create a Java program and start it from the command line.


Posted by Julien on April 08, 2013 at 02:37 PM PDT #

I am using ODI 11.1.1 version , so does this version have smart export and import option and if so where can i find this option, reply me asap.

Posted by Vignesh on July 04, 2014 at 03:35 AM PDT #

Hi Vignesh,

This was a new feature in ODI


Posted by guest on July 08, 2014 at 09:22 AM PDT #


I need urgent help.I tried Smart export and import feature.Import happened perfectly.But all my physical -logical architecture mapping of existing packages has gone into toss.
I am now not able to use the other packages as the logical-physical architecture has no mapping.

Please help to resolve this issue.TIA

Posted by SUHEL FIRDUS on October 15, 2014 at 10:08 AM PDT #

Hi Suhel,

Please work with Oracle Support on this, our Support team will be able to help you with this.


Posted by Julien on October 15, 2014 at 12:22 PM PDT #

The problem with Smart export is, it also includes topology in the xml. so when you have to move code to different environment (QA. PROD), where the topology is of course different, it causes conflicts. After move, you have to again rectify the topology details in higher envs. Thats a big bummer! good news for 12 C export in 12 C does not include topology!

Posted by guest on December 08, 2014 at 10:30 AM PST #


Is possible to import a work flow from Oracre Data Miner in ODI?


Posted by aisasid on May 18, 2016 at 01:23 AM PDT #

Hi aisasid,

No you can't import from Oracle Data Miner into ODI.


Posted by Julien on May 18, 2016 at 02:50 PM PDT #

Hello Julien,

Neither if I export ODM work flow as .xml ? And so, then import this .xml in ODI..


Posted by aisasid on May 19, 2016 at 12:21 AM PDT #

Hi aisasid,

The 2 tools are completely different so ODI won't be able to understand the XML export format from ODM.


Posted by Julien on May 19, 2016 at 10:26 AM PDT #

Hi Julien,

And there would be any option to integrate the work done in ODM into ODI?
For example, generating a sql script and then integrating it in ODI...

Any Suggestion?


Posted by aisasid on May 25, 2016 at 03:45 AM PDT #

Yes ODI can invoke stored procedures etc. it can also invoke any DB function you may have created so this could be a way of integrating the work done in ODM within ODI.


Posted by Julien on May 25, 2016 at 04:00 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality


« May 2016