Oracle Data Integrator (ODI) Review

If it doesn't connect out-of-the-box to a specific technology, we can add a new technology into it.


What is our primary use case?

We mainly use ODI to integrate all of our EPM applications, which includes Essbase ASO/BSO cubes, Hyperion Planning, DRM and HFM applications. Also it is used to manage a custom data warehouse developed in Oracle DB which is used as source for OBIEE reporting.

How has it helped my organization?

We use ODI to integrate all Oracle EPM suite used in our financial area. ODI is the core engine used to move data across different applications every day. It’s by far the most important architectural element in our BI/EPM environment since all data passes through it.

What is most valuable?

ODI has the ability to connect to virtually any technology out there. If it does not connect out-of-the-box, we can very easily add a new technology into it. This flexibility gives a tremendous developmental advantage to its users, which can use ODI as the official ETL tool for any kind of integration project.

Its Knowledge Modules (KMs) may abstract the “how” portion of integrations, allowing the users to focus on the “what” that needs to be done. It can be easily used by either young ETL developers or expert professionals.

For resumes, the ease of use for young professionals and its great development flexibility for expert professionals make it a great product to be used for every ETL project out there.

What needs improvement?

In my opinion, ODI should connect to ALL Oracle products out-of-the-box, but currently that’s not the case for all of them. Hyperion Financial Management (HFM) is one of the Oracle products for which Oracle decided to remove its ODI support in its last product version. In other words, if you wish to use ODI and HFM together, both from Oracle, you will need to create custom code, which does not make any sense to me.

Another area to improve would be the development life-cycle, which did improve in the latest ODI version, but needs further improvements.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

ODI 11 version is very stable. It can manage several parallel executions/large volumes without much trouble. I do see some complains about ODI 12 version, but I cannot share any opinion since I’m not currently working with it.

What do I think about the scalability of the solution?

ODI scales very well.

How is customer service and technical support?

This is a delicate subject. My experience with Oracle support has both great and very bad situations. If the problem that you are facing is only related to ODI, then your chances of having a great Oracle support experience are good. But if your problem involves multiple technologies, like ODI integrating EPM apps, then it is probably going to be a nightmare (and, unfortunately, most of the problems that will require support assistance will involve “multiple technologies”).

This happens because Oracle supports different technologies with different teams and the communication between them seems complicated sometimes. Several times I was in a situation where teams would keep discussing who should fix the problem instead of actually fixing it.

Which solutions did we use previously?

I've always worked with ODI for ETL development.

How was the initial setup?

The initial setup is extremely easy and straightforward.

Which other solutions did I evaluate?

ODI was the only option we considered.

Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
1 visitor found this review helpful
1 Comment
Alan YvesConsultantTOP 5LEADERBOARD

Hi Rodrigo,
That is good to know those limitations on integrating ODI with EPM applications .
In terms of the main RDBMS in the market I think ODI is quite good in providing the native drivers, when they don't we can find it and place on the ODI drivers folder and works but I guess sometimes there are some commercial roadblocks imposed by oracle, for example I had a hard time to connect ODI with a CRM on the cloud (Sales Force), we had to customize a webservice to accomplish the goal of the project, thankfully it worked fine but I found it really annoying because you could see they had deprecated the connector just because they wanted to force clients to buy Siebel instead, but Oracle realized it and they changed it in the Cloud option making it available to clients .

03 November 16
Guest

Sign Up with Email