Oracle Data Integrator (ODI) Review

A reduction in manual work during data integration is a welcomed improvement

What is our primary use case?

Our primary use for this solution is a data integration and merging tool. It easily connects to many databases like MySql, SQL Server, etc. It's completely user-friendly. We can easily manage packages, ETL, and Procedures.

How has it helped my organization?

Before adopting this solution we used to work hard. We now feel better because our manual work is completely over. 

What is most valuable?

We can easily create ETL processes and schedules. We can check logs on a daily basis. It handles multiple routines very smartly.

What needs improvement?

Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.

For how long have I used the solution?

Three to five years.

What do I think about the stability of the solution?

My impressions are good in terms of the stability.

What do I think about the scalability of the solution?

I find that the scalability of this solution is good.

How are customer service and technical support?

Interaction with technical support is not my area.

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

Before this solution, we were using SQL Server.

How was the initial setup?

I think that the initial setup is amazing.

What about the implementation team?

We used a completely internal team to implement this solution. 

What's my experience with pricing, setup cost, and licensing?

We found that the cost compared to other integration tools is a little high, but the solution works great.

Which other solutions did I evaluate?

We evaluated SQL Server prior to choosing this solution.

Which version of this solution are you currently using?

ODI 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: September 2021.
534,226 professionals have used our research since 2012.
Add a Comment
ITCS user
1 Comment

author avatarNida Fatima (Astera)

I wanted to know how simple it is to perform simple transformations in ODI? Let's say, I have an Excel file and I want to convert it to a delimited format. Is the process simple and straightforward, like in Centerprise Data Integrator? Or like Talend and other solutions, do we have to follow a multi-step process?