New Feature in ODI 126.96.36.199: Shortcuts
By Julien Testut on Feb 29, 2012
Oracle Data Integrator 188.8.131.52.0 introduces a major new feature called Shortcuts. This post will give you an overview of this feature.
Let’s take an example with an ETL developer who has to develop ODI interfaces sourcing data from Oracle E-Business Suite 11 and 12. Both versions of E-Business Suite (EBS) share many common objects such as tables like HZ_PARTY or HZ_PARTY_SITES. Typically, you would need to reverse engineer both versions of the application and then design mappings to source data from each of them. Even if the source objects are the same you would still need to develop two different versions of your mappings: one for each version of the source application.
Thanks to Shortcuts users avoid having to duplicate their
efforts when dealing with the same objects coming from two (or more) versions
of the same application.
For example, you can create a Model for one version of the Application and then duplicate this model using Shortcuts. Those Shortcuts, while stored in a different Model, will be linked to the base object located in a different Model. The following screenshots gives you an example with 2 Models (eBusinessSuite 11 and eBusinessSuite 12):
HZ_PARTY and HZ_PARTY_SITES in the Model eBusinessSuite 12 are Shortcuts that simply point to the base tables stored in the eBusinessSuite 11 model.
The same can be done for Interfaces, Packages and Procedures. It is possible to create Shortcuts from an individual object like a single Interface or to create Shortcuts from a Project or Model folder.
Shortcuts are materialized (converted into “real” ODI
objects) at deployment time, when the ODI processes are exported from the
design repository to the runtime repository.
If a Shortcut requires some modifications compared to the base object, it will need to be materialized and then updated.
You will find instructions about how to use Shortcuts in the Oracle Data Integrator documentation: Working with Shortcuts.
You can find an overview of all the new features introduced in ODI 184.108.40.206 in the following document: ODI 220.127.116.11 New Features Overview.