2016-05-13T12:07:00Z
Brian Dandeneau - PeerSpot reviewer
Business Process and Strategy Specialist Advisor at NTTData
  • 8
  • 687

What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)

If you have used ODI 10g or 11g or both you know that there is the big difference between those versions and ODI 12c. What is your favorite new feature of ODI 12c? Is it Reusable Mappings? Maybe its just the fact that its flow based? 

8
PeerSpot user
8 Answers
it_user272565 - PeerSpot reviewer
Technical Advisor at Gluent Inc
Consultant
2016-05-16T14:43:18Z
May 16, 2016

There are a lot of great new features in ODI 12c, but one of my favorites is the deployment specifications on the physical layout of the mapping. These deployment specifications allow you to use the same logical flow for your mapping with multiple different physical deployments. For example, you may need to perform an initial load of data from source to target once. Then, every subsequent run of the mapping would be an incremental update, only inserting/updating rows that are new or changed. In this case, there are different Knowledge Modules that must be used, one for the full load and a different one to perform the incremental update logic. With deployment specifications, we can use the exact same logic in the mapping and create 2 different physical implementations without duplicating the mapping. In past versions of ODI this would have been two mappings, both with the same logic that would need to be maintained twice, with lots of room for error!

Search for a product comparison
Ricardo Giampaoli - PeerSpot reviewer
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Consultant
Top 5Leaderboard
2016-05-16T11:23:52Z
May 16, 2016

Hi how are you?

I think the main difference between the older versions and the 12c is the GUI.
Maybe for a new user the 12c is more friendly, but for me that works with odi since 10g, everything in the 12c takes 2 to 3 times more then in the older version.

The 12c has a lot of features as default that the older version needs to customize to have it, but in the end you can do everything in all versions, the only thing that changes is the way you do it.
For example, in the older version if you want to load data in parallel using interfaces, you need to create a java variable to get the session number and concat it with the I$_ prefix in the topology. In 12c this is enable by default.

This is just a example, but everything will be like this.

Then I think the best thing you can do is install the 12c version and give it a try.

in the end everything will be resume to the GUI.

hope this can help you. If you want more info about odi, please take a look in my blog.

Thank you

it_user278157 - PeerSpot reviewer
Consultant - Oracle ACE with 51-200 employees
Vendor
2017-06-22T08:44:30Z
Jun 22, 2017

There are a lot of nice new features that I mentioned in two blog posts :
https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/
https://www.rittmanmead.com/blog/2013/11/oracle-data-integrator-12c-release-part-2/

But I think my favorite is the auto-completion when writing expressions/code. So much time spared with it!

it_user453978 - PeerSpot reviewer
Consultant at Capgemini
Real User
2016-06-07T17:43:35Z
Jun 7, 2016

Hi,
I am using ODI from long. I used 10g, 11g & 12c. When I started my work on ODI lower versions i.e. 10g & 11g, I feel helpless sometime. But after releasing of 12c. It proves me wrong. There are lots of features which you may get any other ETL tool but to implement the solution,could be difficult. I like Declarative flow based design, Multiple target, extensive Big data support, Multithreading target load, and most important OWB integration.

Regards,
Himanshu

Gurcan Orhan - PeerSpot reviewer
Data Quality Software Development Manager at Yapı Kredi Bank
Real User
2016-05-18T14:02:22Z
May 18, 2016

Oracle Data Integrator is a tool that can talk or learn how to talk with any database or operating system in it's own language... This is the power of ODI.!

While ODI 10G and 11G had a declarative based design, the main difference between ODI 12c and prior versions is being "declarative flow based design". It is both flow based design with a declarative approach, so that both traditional ELT developers and E-LT developers can build easily. With holding the status of "easy learning", I believe Oracle Data Integrator will still be on top.

it_user317247 - PeerSpot reviewer
ETL Developer at a comms service provider with 10,001+ employees
Real User
2016-05-16T15:11:07Z
May 16, 2016

Hi Brian,
comparing 11 and 12c version of ODI I can tell that Reusable Mappings are really something it help to me reduce some codding in well organized way.
I try also multiple targets as I need similar functionality but finally not use it as I need target to be file and DB table and seems it is not possible multiple targets to use different technology. Probably this will be beneficial if it is developed in next version.
Fact that mapping are flow based make the transformation more compact and easy for reading, which is important for big transformation flows.

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
657,849 professionals have used our research since 2012.
it_user435336 - PeerSpot reviewer
Solution Manager at a tech services company with 501-1,000 employees
Consultant
2016-05-16T21:42:34Z
May 16, 2016

I would say the new flow based approach is the main change. Easier to read the data flow to understand the logic of transformation instead of creating/opening many interfaces and try to follow all.
Reusable mapping is also very useful just like multiple target load. Despite i did not use yet, big data support can be very handy for the teams working on that.

Brian Dandeneau - PeerSpot reviewer
Business Process and Strategy Specialist Advisor at NTTData
Consultant
Top 5Leaderboard
2016-05-16T20:14:20Z
May 16, 2016

I'm a long time user of ODI and specifically ODI12c. If that makes me a addict; then sign me up for the meeting. I love the reusable mapping but the best part of this 12c is that its now Flow based. I would also have to agree with Michael Rainey on all the points that he brought to light in his response to my question. I mean it just makes other integration tools look like child's play.

Related Questions
DS
Sr. VP at Newt
Sep 26, 2022
Hi community,  I am a Senior VP at a large tech services company. I am considering replacing Oracle Data Integrator with Azure Data Factory. Which product do you prefer, and why? What are the pros and cons of each product? Thank you for your help.
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Oct 31, 2022
Hi Everyone, What do you like most about Oracle Data Integrator (ODI)? Thanks for sharing your thoughts with the community!
2 out of 10 answers
AS
Applications Support Manager at a marketing services firm with 1,001-5,000 employees
Nov 18, 2021
The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful.
NM
Principal Consultant at a tech services company with 501-1,000 employees
Jan 24, 2022
Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support.
Related Articles
Ricardo Giampaoli - PeerSpot reviewer
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Mar 22, 2021
Hey guys, how are you?  In this post, I’ll talk about my preferred tips and tricks that I use in ODI (any version). I’m always using these pieces of code for pretty much everything I do in ODI especially because it makes the code more elegant, dynamic, and easier to change later. First, let’s talk about my all-time preferred, Loops. Normally we learn to loop in ODI using a count variable and ...
Related Articles
Ricardo Giampaoli - PeerSpot reviewer
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Mar 22, 2021
How to use ODI to generate Dynamic code for you
Hey guys, how are you?  In this post, I’ll talk about my preferred tips and tricks that I use in...
Download Free Report
Download our free Oracle Data Integrator (ODI) Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
657,849 professionals have used our research since 2012.