New Feature in ODI 11.1.1.6: Shortcuts

Oracle Data Integrator 11.1.1.6.0 introduces a major new feature called Shortcuts. This post will give you an overview of this feature.

ODI is often used to load large data warehouse implementations sourcing from various versions of the same source applications. Those applications often share common objects: same tables and columns, same constraints, same transformations, etc. Shortcuts allow ETL designers to express this commonality by creating links to common objects stored in separate Project folders or Models.

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):

ODI Shortcuts

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

Comments:

Nice article. Thanks for sharing.

Gurcan.

Posted by Gurcan Orhan on March 10, 2012 at 12:19 PM PST #

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