Oracle Data Integrator (ODI) Review

The topology gives me total freedom in switching between technologies / ETL agents.


Valuable Features

The ODI topology and designer are the most valuable features. The topology gives me total freedom in switching between technologies / ETL agents. The mapping designer gives me a good graphical overview of ETL mappings.

Improvements to My Organization

The speed in which we create/generate our ETL mappings has increased by at least a factor of four as compared to Oracle Warehouse Builder.

Room for Improvement

Overall performance needs improvement. Especially when running ODI clients on Windows desktops. ODI seems to generate a lot of network traffic.

ODI Studio can be very slow. Objects (mappings, packages, tables, etc.) can take minutes to open for editing when you are running ODI Studio on a Windows client when you have your repository database running on a server. It gets even worse when you are working on the same repository with multiple developers, which is not uncommon. :) The solution to this problem is running the ODI Studio in a virtual desktop on the same database server.

Use of Solution

I have used it for over two years.

Stability Issues

Migrating from 12.1.2 to 12.1.3 did not go as smooth as it should.

Sometimes the ODI agent shows running in WebLogic (middleware), while it cannot be reached by the ODI clients.

Scalability Issues

More than six or seven developers working in the same repository is the maximum.

Customer Service and Technical Support

Oracle support does not always seem to deliver. At one time during the migration of 12.1.2 to 12.1.3, we had issues taking over six months to resolve.

Previous Solutions

We previously used Oracle Warehouse Builder, which was discontinued by Oracle. Oracle Data Integrator is Oracle's strategic choice for ETL tooling going forward. We could not risk running out of support. That is why we had to buy licenses for Oracle Data Integrator (whereas Oracle Warehouse Builder came free with the Oracle database - until version 11.2).

Initial Setup

The initial setup is really not straightforward. You really have to think about the architecture in which you want to use ODI (i.e., agent(s), repository setup, topology). But this makes the software as flexible as it can be.

Pricing, Setup Cost and Licensing

As with all Oracle products, you need a licensing specialist to look at your needs.

Other Solutions Considered

We considered moving forward with Oracle Warehouse Builder, but dismissed OWB because it was running out of support.

We also considered Informatica PowerCenter, but it seemed to be even more expensive an option than ODI. With ODI, we could still use some of the present Oracle skills (mapping design), so the learning curve seemed less steep compared to Informatica.

Other Advice

  • Think about the architecture in which you are going to use ODI very well.
  • Think about where to place an agent and, if possible, put your ODI repository as close to this agent as possible.
  • If possible, run your agent closer to the target than to the source.
  • Try splitting up your repository into multiple work repositories for groups of developers of no more than five developers.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
2 visitors found this review helpful
3 Comments
System Architect at GAVBUser

Michael, I really satisfied reading your post. I've been working ODI for along years and I agree with all points here. I had some issues migrating to 12.2 as well, in our team we have +30 developers using ODI. Thanks for shared your experience with us, I believe that your project is in a good way.

Cheers, Fabio.

07 October 16
Consultant at a tech services company with 10,001+ employeesConsultant

the real challenge in ODI is the migration which is a real pain and you dont know how to resolve this.

I expect Oracle to be little expressive on the ability of journalizaion and CDC.

08 October 16
Alan YvesConsultantTOP 5LEADERBOARD

I totally agree with the points you mentioned.

06 October 17
Guest
Sign Up with Email