ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Versioning

Versioning is a smart method of implementing a certain condition or multiple condition , objects for a particular interface , package or scenarios without required to have multiple such objects.

Creating Version

 

clip_image001

To create a version , right click on the object to be versioned and click ok Version-> Create and a popup will be appear as shown below and automatically version number appears , you can also change the version number if required and also provide the description as in the long term and in future understanding would help us to understand the purpose of the version .

clip_image002

Restoring Version

 

clip_image003

To restore any object version , just right click and select Version -> Restore .. , and select the version to be restored.

clip_image004

clip_image005

Don’t worry about the warning , click ok .

Interface Versioning

 

VERSION – 1.0.0.0

clip_image006

VERSION – 1.0.0.1

clip_image007

Package Versioning

 

VERSION – 1.0.0.0

clip_image008

VERSION – 1.0.0.1

clip_image009

Scenario Versioning

clip_image010

clip_image011

clip_image012

clip_image013

Regenerate scenario

clip_image014

Comparing Versions

 

To compare any two version of the objects , just right click and select version -> Compare with versions..

clip_image015

Here I am comparing 1.0.0.1 with 1.0.0.0

clip_image016

As you can see that in version 1.0.0.0 all the columns where mapped where’s in the COLUMN- C3 was not mapped .

clip_image017

Here in this Example I am comparing the Packages created above .

clip_image018

And as you can see that VAR_JOIN1 is added in the var_join1 and it even shows the different in descriptions , for example

Description in Version 1.0.0.0

clip_image019

Version 1.0.0.1 Description with addition of VAR_JOIN1 being added to it .

clip_image020

Comparing Scenarios

clip_image021

Report Generation

 

You can create a report by click on the print button found on the top of the compare version

clip_image022

And select the path and location of the PDF Folder.

clip_image023

The biggest drawback I see is that I can compare between two version only , not multiple. Hope Oracle implements multiple comparison in future versions.

All the versioning information is stored in SNP_VERSION table of Master Repository and are connected to Work Respository objects linked to External_version and Object_name.

 

2 Comments

  1. Hello,
    which version of ODI are you using ?
    Is there a way to compare different objects rather than different versions of the same object ?
    Thanks
    Paul-Marie

    • I have used 10.1.3.5 while writing this post. If you are looking for comparing any two objects as the ‘ compare with version’ does then no, but you can print out objects as pdf and compare them manually.

Leave a Reply

Required fields are marked *.