Oracle Data Integrator (ODI) Pros and Cons

Oracle Data Integrator (ODI) Pros

Alan Yves
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
View full review »
it_user521808
Development Manager
It is an ETL tool, which does the extract, transform, and load.
View full review »
John Kruebbe
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.
It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases.
View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: August 2019.
365,423 professionals have used our research since 2012.
Muhammad Tahir
Assistant Manager - MIS Analyst at a logistics company with 5,001-10,000 employees
It's completely user-friendly.
View full review »
Dava Wang(汪燊)
Data engineer at realestate.pingan.com
​The installation of the client ODI Studio is easy.​
Besides loading data, we do most of our transformations in ODI.
In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way.
Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.
View full review »
RenéDe Vleeschauwer
Owner at a tech vendor with 11-50 employees
ODI is a very accessible tool, especially since the mapping functionality has been added.
View full review »
Jill Corcoran
User
It has the ability to easily load slowly changing dimensions.
View full review »
Rüdiger KOch
Team Leader Development with self employed
The most valuable feature that we use is the Knowledge Modules.
View full review »

Oracle Data Integrator (ODI) Cons

Alan Yves
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons
View full review »
it_user521808
Development Manager
I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product.
View full review »
John Kruebbe
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value.
View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: August 2019.
365,423 professionals have used our research since 2012.
Muhammad Tahir
Assistant Manager - MIS Analyst at a logistics company with 5,001-10,000 employees
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.
View full review »
Dava Wang(汪燊)
Data engineer at realestate.pingan.com
​The stability of the software could be improved. Sometimes, the software just crashes. ​
View full review »
RenéDe Vleeschauwer
Owner at a tech vendor with 11-50 employees
Technical Support could be better.
View full review »
Jill Corcoran
User
It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.
View full review »
Rüdiger KOch
Team Leader Development with self employed
The performance of the user interface is in need of improvement.
View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: August 2019.
365,423 professionals have used our research since 2012.
Sign Up with Email