Oracle Data Integrator (ODI) Review

Able to develop transformations more rapidly than other solutions, such as Informatica.


What is most valuable?

The product separates business logic (data mapping) from how data moves from source to target. A Knowledge Module defines the steps to move data from an Oracle DB to SQL Server for example, leaving only the transformation logic for the developer to define. This results in an ability develop transformations more rapidly than say Informatica.

How has it helped my organization?

We spend much less time developing integrations because all we need to focus on is the business logic.

What needs improvement?

The user interface is a little slow. When compared to Informatica, the UI is more intuitive, but because it is Java based, it does hang at times. This can be tuned, but it is something that could be streamlined.

For how long have I used the solution?

I've been using it for over five 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?

We have had no issues with the stability.

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?

Customer Service:

It is adequate.

Technical Support:

It is adequate.

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

I have used a number of ETL tools. I like this one because it is part of Oracle Business Intelligence applications which is my primary focus. I would choose it over Informatica because you can develop more rapidly.

How was the initial setup?

It was straightforward as the installation is fairly easy and well documented.

What other advice do I have?

As with all software, read the installation guide cover to cover before you start.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are platinum partners with Oracle.
Add a Comment
Guest