Oracle Data Integrator (ODI) Review

It provides good integration with other Oracle products.

What is most valuable?

The possibilities provided by using knowledge modules and the integration with other Oracle products.

How has it helped my organization?

The old fashion PL/SQL codes have been translated into ODI, improving the way of maintenance. Several developers can work on the same project easily.

What needs improvement?

The software is developed on Java so it is very hardware dependent. You will need enough hardware to run the software otherwise you will struggle with it.

For how long have I used the solution?

I've been using it for the last four years.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

When developing on huge internal repositories, the performance is often quite poor.

What do I think about the scalability of the solution?

It's been able to scale for our needs.

How are customer service and technical support?

I have managed to solve my questions/issues via OTN or forums.

Which solution did I use previously and why did I switch?

I haven't used any other products.

How was the initial setup?

The first time might look a bit complex but using the right documentation it should be easy to handle.

What about the implementation team?

It was already implemented on the projects where I have worked.

Which other solutions did I evaluate?

I didn't look at any other similar products.

Which version of this solution are you currently using?

11g & 12c
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Oracle Data Integrator (ODI) reviews from users
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
523,230 professionals have used our research since 2012.
Add a Comment
ITCS user
1 Comment

author avatarAlan Yves
Top 10Consultant

That is true!! the integration with other Oracle products is great and enable several business functionalities, some of the examples I have seen and worked on are the integration of OBIEE and BPEL(SOA) with ODI, for example, when you have OBIEE in your environment one of the advantages is that you can enable the end-user to load files, or load data from one DB to another and this is on his most convenient time through OBIEE this is also possible, the way he or she does this is by invoking some ODI methods that runs webservice's calls by passing some parameters through an OBIEE action that invokes scenarios, loadplans etc.. of course it is necessary some configuration such as the JAVAEE agent, you will need to configure 3 files in ODI acordingly: oraclediagent.ear, oraclediagent.war, OdiInvoke.wsil, you will need to update the deployment in weblogic server.
In OBIEE the first step is to register the ODI Web Services in the OBIEE Action Framework configuration file called ActionFrameworkConfig.xml, for ODI webservices you can check the link below as a reference: ,

Alan Yves