New Feature in ODI 11.1.1.6: Smart Export and Import

By Jayant Mahto

Oracle Data Integrator 11.1.1.6.0 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 11.1.1.6 in the following document: ODI 11.1.1.6 New Features Overview.

Comments:

Jayant,

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.

Thanks,
Julien

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

Jayant,

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.
Thanks
Daniel

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 http://docs.oracle.com/cd/E23943_01/apirefs.1111/e17060/toc.htm

Thanks,
Julien

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.

Thanks
Vignesh

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.

Thanks,
Julien

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

Post a Comment:
  • HTML Syntax: NOT allowed
About

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

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today