Try our new research platform with insights from 80,000+ expert users

Oracle Data Integrator (ODI) pros and cons

Vendor: Oracle

4.0 out of 5

72 reviews
83% willing to recommend

Pros & Cons summary

Oracle Data Integrator (ODI) boosts data integration through custom data type management and effective database utilization. Knowledge Modules and robust features like metadata management enhance integration with diverse technologies. ODI's ETL and ELT capabilities streamline workflows and data migrations, though security integration with deprecated platforms and initial setup can be challenging. Improvements in real-time integration, pricing for smaller projects, and technical support are needed for better user experience.

Buyer's Guide

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

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

Head of Data Services – Services Partner at 3 As Technologies

Sep 2, 2025

The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click.

Read full review

AS

Applications Support Manager at a marketing services firm with 1,001-5,000 employees

Nov 18, 2021

The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful.

Read full review

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.

Read full review

Oracle Data Integrator (ODI)

Free Report: Oracle Data Integrator (ODI) Reviews and More

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.

867,676 professionals have used our research since 2012.

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.

Read full review

MJ

Muhammad Arif Javed

Senior Manager Software Development at Techlogix

Jun 10, 2020

All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.

Read full review

Hari Krishna Boddala

Vice President at Fluentgrid

Mar 14, 2023

The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup.

Read full review

Technical lead at a transportation company with 10,001+ employees

Oct 31, 2022

What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company.

Read full review

Samir Bhattarai

Manager- Application and Cloud Services at a tech services company with 501-1,000 employees

Oct 18, 2022

It's scalable.

Read full review

Founder at DEN21DS

Apr 4, 2024

ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases.

Read full review

Assistant consultant at Tata Consultancy

Sep 6, 2022

The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module.

Read full review

Show 10 more reviews (out of 36)

Oracle Data Integrator (ODI) Cons review quotes

Head of Data Services – Services Partner at 3 As Technologies

Sep 2, 2025

One of the main disadvantages of the Oracle Data Integrator (ODI) is that it sometimes takes a lot of resources when handling multiple jobs.

Read full review

AS

Applications Support Manager at a marketing services firm with 1,001-5,000 employees

Nov 18, 2021

The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects.

Read full review

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).

Read full review

Oracle Data Integrator (ODI)

Free Report: Oracle Data Integrator (ODI) Reviews and More

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.

867,676 professionals have used our research since 2012.

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

Read full review

MJ

Muhammad Arif Javed

Senior Manager Software Development at Techlogix

Jun 10, 2020

There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue.

Read full review

Hari Krishna Boddala

Vice President at Fluentgrid

Mar 14, 2023

In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release.

Read full review

Technical lead at a transportation company with 10,001+ employees

Oct 31, 2022

An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations.

Read full review

Samir Bhattarai

Manager- Application and Cloud Services at a tech services company with 501-1,000 employees

Oct 18, 2022

The price needs to be lowered. It's too expensive.

Read full review

Founder at DEN21DS

Apr 4, 2024

ODI could improve by focusing on streamlining its features without unnecessary overhead.

Read full review

Assistant consultant at Tata Consultancy

Sep 6, 2022

ODI could improve the ease of use. There is a steep learning curve to use the solution.

Read full review

Show 10 more reviews (out of 36)

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Integrator (ODI)

Azure Data Factory vs Oracle Data Integrator (ODI)

Informatica PowerCenter vs Oracle Data Integrator (ODI)

SSIS vs Oracle Data Integrator (ODI)

Teradata vs Oracle Data Integrator (ODI)

Palantir Foundry vs Oracle Data Integrator (ODI)

IBM InfoSphere DataStage vs Oracle Data Integrator (ODI)

Talend Open Studio vs Oracle Data Integrator (ODI)

Oracle GoldenGate vs Oracle Data Integrator (ODI)

SAP Data Services vs Oracle Data Integrator (ODI)

Qlik Replicate vs Oracle Data Integrator (ODI)

Denodo vs Oracle Data Integrator (ODI)

Fivetran vs Oracle Data Integrator (ODI)

SnapLogic vs Oracle Data Integrator (ODI)

Alteryx Designer vs Oracle Data Integrator (ODI)

See all alternatives

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Integrator (ODI)

Azure Data Factory vs Oracle Data Integrator (ODI)

Informatica PowerCenter vs Oracle Data Integrator (ODI)

SSIS vs Oracle Data Integrator (ODI)

Teradata vs Oracle Data Integrator (ODI)

Palantir Foundry vs Oracle Data Integrator (ODI)

IBM InfoSphere DataStage vs Oracle Data Integrator (ODI)

Talend Open Studio vs Oracle Data Integrator (ODI)

Oracle GoldenGate vs Oracle Data Integrator (ODI)

SAP Data Services vs Oracle Data Integrator (ODI)

Qlik Replicate vs Oracle Data Integrator (ODI)

Denodo vs Oracle Data Integrator (ODI)

Fivetran vs Oracle Data Integrator (ODI)

SnapLogic vs Oracle Data Integrator (ODI)

Alteryx Designer vs Oracle Data Integrator (ODI)

See all alternatives

Related questions

68

Which ETL tool would you recommend to populate data from OLTP to OLAP?

24

Oracle ICS vs ODI

38

What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)

227

Experiences with Oracle GoldenGate vs. Oracle Data Integrator?

440

What Is The Biggest Difference Between ODI and OIC?

63

Looking for advice on how to invoke a select script through ODI?

68

What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?

35

What is the best suitable replacement for ODI on Azure?

23

When evaluating Data Integration, what aspect do you think is the most important to look for?

48

Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?