Try our new research platform with insights from 80,000+ expert users
Oracle Data Integrator (ODI) Logo

Oracle Data Integrator (ODI) pros and cons

Vendor: Oracle
4.0 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Oracle Data Integrator integrates efficiently with almost all technologies used in an organization, enhancing workflow through robust capabilities and compatibility with SQL Server databases, SAP systems, ERP systems, and more.
The Knowledge Modules feature is highly valued for creating integration strategies, reducing development effort, and offering templates for faster onboarding and successful data transfer.
Its scalability and distributed working capabilities allow multiple users to access and work on the same solution simultaneously, making it suitable for distributed teams.
ODI's ETL and ELT capabilities ensure efficient data extraction, transformation, and loading, improved by its ability to integrate with newer databases such as Cassandra and Hadoop.
Oracle provides excellent technical support, effective documentation, and quick resolution of tickets, enhancing the overall user experience for Oracle Data Integrator.

CONS

Oracle Data Integrator (ODI) could benefit from improved security measures.
Integration with deprecated platforms, often necessary for legacy systems, is limited.
Technical support for Oracle Data Integrator (ODI) requires enhancement.
Oracle Data Integrator (ODI) lacks real-time integration capabilities, requiring workarounds.
The pricing of Oracle Data Integrator (ODI) is considered too high for smaller projects.
 

Oracle Data Integrator (ODI) Pros review quotes

it_user278157 - PeerSpot reviewer
Consultant - Oracle ACE with 51-200 employees
Aug 25, 2017
The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance.
it_user290082 - PeerSpot reviewer
Big Data / Business Intelligence / Datawarehousing at DWgrain (Client Health BIS)
Mar 18, 2019
​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
PB
Oracle Business Intelligence Consultant at a tech consulting company with 51-200 employees
Aug 24, 2017
It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors.
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
880,490 professionals have used our research since 2012.
it_user521808 - PeerSpot reviewer
Development Manager
Sep 28, 2016
It is an ETL tool, which does the extract, transform, and load.
it_user636159 - PeerSpot reviewer
Owner at a tech vendor with 11-50 employees
Jul 11, 2017
ODI is a very accessible tool, especially since the mapping functionality has been added.
it_user804942 - PeerSpot reviewer
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
Jan 19, 2018
I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.
DW
Data engineer at realestate.pingan.com
Aug 1, 2018
​The installation of the client ODI Studio is easy.​
it_user911514 - PeerSpot reviewer
Works at Momentum Consulting
Aug 2, 2018
It has the ability to easily load slowly changing dimensions.
it_user1083117 - PeerSpot reviewer
Assistant Manager - MIS Analyst at TCS Private Limited
May 5, 2019
It's completely user-friendly.
RK
Team Leader Development at Deutsche Bahn AG
Jul 12, 2019
The most valuable feature that we use is the Knowledge Modules.
 

Oracle Data Integrator (ODI) Cons review quotes

it_user278157 - PeerSpot reviewer
Consultant - Oracle ACE with 51-200 employees
Aug 25, 2017
It needs easier security.
it_user290082 - PeerSpot reviewer
Big Data / Business Intelligence / Datawarehousing at DWgrain (Client Health BIS)
Mar 18, 2019
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons
PB
Oracle Business Intelligence Consultant at a tech consulting company with 51-200 employees
Aug 24, 2017
I would only point out some minor bugs or glitches in the development interface (ODI studio).
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
880,490 professionals have used our research since 2012.
it_user521808 - PeerSpot reviewer
Development Manager
Sep 28, 2016
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.
it_user636159 - PeerSpot reviewer
Owner at a tech vendor with 11-50 employees
Jul 11, 2017
Technical Support could be better.
it_user804942 - PeerSpot reviewer
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
Jan 19, 2018
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.
DW
Data engineer at realestate.pingan.com
Aug 1, 2018
​The stability of the software could be improved. Sometimes, the software just crashes. ​
it_user911514 - PeerSpot reviewer
Works at Momentum Consulting
Aug 2, 2018
It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.
it_user1083117 - PeerSpot reviewer
Assistant Manager - MIS Analyst at TCS Private Limited
May 5, 2019
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.
RK
Team Leader Development at Deutsche Bahn AG
Jul 12, 2019
The performance of the user interface is in need of improvement.