No more typing reviews! Try our Samantha, our new voice AI agent.

Denodo vs IBM InfoSphere DataStage vs Oracle Data Integrator (ODI) comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.5
Denodo boosts ROI by enabling rapid reporting, improving decision-making, and streamlining data integration for enhanced efficiency and customer satisfaction.
Sentiment score
5.9
IBM InfoSphere DataStage increases ROI with improved performance, reduced maintenance, efficient management, and ongoing developer support despite some manual needs.
Sentiment score
6.9
Oracle Data Integrator offers strong ROI through automation and efficiency, with positive feedback on stability and cloud enhancements.
It provides a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
Information Technology Manager at Lockheed Martin
If you don't need to write a whole ETL to make the data virtualization, you need way fewer people to write a query instead of writing an ETL pipeline.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
I have seen a return on investment, which showed up in improved customer satisfaction scores.
Vice President at a financial services firm with 10,001+ employees
 

Customer Service

Sentiment score
6.9
Denodo support is responsive and helpful, but some users face delays in bug resolution and unfriendliness in the portal.
Sentiment score
6.2
IBM InfoSphere DataStage support is generally well-rated for availability and responsiveness, but some report regional and efficiency issues.
Sentiment score
5.8
ODI customer support solves issues effectively, yet users face response delays, communication challenges, especially in multi-technology integrations.
They have a good methodology for learning how to use the tool.
Data Architecture and Engineering Specialist at coprocenva
Denodo's customer support team is very competent and responsive.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
Principal Architect at a manufacturing company with 10,001+ employees
We also have the flexibility to submit a feature request to be included as part of the wishlist, potentially becoming a product feature in subsequent releases.
Sr Product Manager at a computer software company with 501-1,000 employees
I rate their support as nine on a scale from one to ten.
Senior Data Warehouse Developer at itcinfotech
IBM tech support has allocated dedicated resources, making it satisfactory.
Senior Officer at State Bank of India
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
Head of Data Services – Services Partner at 3 As Technologies
 

Scalability Issues

Sentiment score
7.1
Denodo effectively scales across organizations, managing many users and data sources, but performance may vary with automation and configuration.
Sentiment score
7.5
IBM InfoSphere DataStage scales well but may require hardware adjustments under heavy loads, with ratings between 7-9.
Sentiment score
7.6
Oracle Data Integrator is scalable and adaptable, handling large projects effectively, though resource demands may pose challenges.
For huge data requests, it cannot scale automatically; admin action is required.
Principal Architect at a manufacturing company with 10,001+ employees
Denodo's scalability comes into play specifically when there is data transfer.
Vice President at a financial services firm with 10,001+ employees
My client has almost 100 million records, and the performance was impacted in a way that required optimization.
Data Consultant at IT-Bots
If the job provided suggestions about running this kind of parallel processing and how many virtual nodes are required, it would help.
Senior Data Warehouse Developer at itcinfotech
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
Head of Data Services – Services Partner at 3 As Technologies
 

Stability Issues

Sentiment score
7.0
Denodo is stable and reliable in production, with minor issues, praised for robustness but needs technical expertise for optimization.
Sentiment score
7.6
IBM InfoSphere DataStage is stable, especially on Linux, but experiences some instability on Windows due to memory issues.
Sentiment score
7.4
Oracle Data Integrator shows strong stability improvements, with rare issues, efficient management of large volumes, and occasional integration challenges.
I would rate it nine out of ten because it is very reliable, always performing as expected.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Technology Leader at eTCaaS
Denodo is stable and good.
Data Engineer at a consultancy with 11-50 employees
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
Head of Data Services – Services Partner at 3 As Technologies
 

Room For Improvement

Denodo should expand markets, improve UI and integration, address performance issues, and enhance support and documentation.
IBM InfoSphere DataStage requires enhanced interfaces, modern integration, better support, user-friendliness, and adaptability with improved performance and cloud capabilities.
ODI needs better UI performance, tool compatibility, GitHub integration, error handling, real-time AI features, pricing, and external version control.
Ensuring data caching is up to date is critical.
Director Software Engineer at a computer software company with 10,001+ employees
Denodo needs better communication on how the product can be deployed for specific solutions.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
The system has dependencies on other environments, like JVM, which can affect its performance.
Technology Leader at eTCaaS
If the job itself gave some guidance, such as running this parallel processing with this many nodes, it would help; I think that is missing.
Senior Data Warehouse Developer at itcinfotech
I wonder if it supports other areas, such as cloud environments with open source support, or EdgeShift.
Sr Product Manager at a computer software company with 501-1,000 employees
The solution needs improvement in connectivity with big data technologies such as Spark.
Senior Officer at State Bank of India
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame.
Head of Data Services – Services Partner at 3 As Technologies
Adding AI capabilities would make Oracle Data Integrator (ODI) even better.
Software Engineer at a financial services firm with 10,001+ employees
 

Setup Cost

Denodo pricing is high, suitable for larger enterprises, with variable costs and value-enhancing features, seen as fair by many.
IBM InfoSphere DataStage pricing varies widely and can be costly, particularly for small businesses, despite being cheaper than competitors.
Oracle Data Integrator pricing varies; costs are influenced by licensing complexity, with potential savings through discounts and bundled solutions.
For small companies, it's not a solution that most small companies can afford.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Technology Leader at eTCaaS
Pricing for IBM InfoSphere DataStage is moderate and not much expensive.
Senior Officer at State Bank of India
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The pricing aspect of Oracle Data Integrator (ODI) is reasonable; it brings significant value to the table.
Head of Data Services – Services Partner at 3 As Technologies
 

Valuable Features

Denodo excels in data integration, virtualization, governance, and scalability, enhancing user experience with API and query optimizations.
IBM InfoSphere DataStage offers robust ETL capabilities, scalability, excellent integration, user-friendly design, and strong performance for large data volumes.
Oracle Data Integrator optimizes EL-T processing with flexible integration, supporting diverse technologies and enhancing data management efficiency.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Director Software Engineer at a computer software company with 10,001+ employees
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Denodo supports SQL base, so if you want to join two tables or two views, you can use SQL, which is an advantage as most developers or business people know SQL.
Principal Architect at a manufacturing company with 10,001+ employees
It is straightforward from a design and development perspective, and also for deployment.
Sr Product Manager at a computer software company with 501-1,000 employees
As we are a financial organization, security is our main concern, so we prefer enterprise tools.
Senior Officer at State Bank of India
I have leveraged IBM InfoSphere DataStage's integration with IBM's Information Server suite, and it is indeed beneficial.
Senior Data Warehouse Developer at itcinfotech
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.
Head of Data Services – Services Partner at 3 As Technologies
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
Oracle Data Integrator (ODI)'s ELT architecture has helped optimize my data movement and transformation significantly.
Software Engineer at a financial services firm with 10,001+ employees
 

Mindshare comparison

As of April 2026, in the Data Integration category, the mindshare of Denodo is 1.3%, down from 1.8% compared to the previous year. The mindshare of IBM InfoSphere DataStage is 1.6%, down from 5.3% compared to the previous year. The mindshare of Oracle Data Integrator (ODI) is 2.2%, down from 4.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Denodo1.3%
Oracle Data Integrator (ODI)2.2%
IBM InfoSphere DataStage1.6%
Other94.9%
Data Integration
 

Featured Reviews

Patel-Dhulva - PeerSpot reviewer
Information Technology Manager at Lockheed Martin
Data virtualization has unified siloed sources and now supports real-time decisions
The best features Denodo offers stand out to me as the ability to develop REST web services fast and easily, create and combine new views, integrate different sources of data, and connect with other tools seamlessly. When I mention fast and easy creation of views and integration, I love the agile data provisioning and integration, where Denodo provides a comprehensive set of capabilities for implementing logical data integration, management, and delivery, which in turn enables agile data analytics and an informed decision-making process to be smooth. I also appreciate the performance optimization with AI, which improves performance optimization through the integration of artificial intelligence capabilities. Furthermore, I appreciate the unified security and governance, where it addresses the need for an organization to effectively manage security, data privacy, and data protection easily, offering a centralized platform that allows the application of governance policies and fine-grained security controls. Another feature I would add about Denodo is that it also provides a single point of control where we can establish security controls over the entire infrastructure and gain visibility into all our data assets. Denodo has positively impacted my organization as since we started using this tool, it has been very helpful because it is a huge advantage that we can connect to many different databases to provide data rapidly and accurately and also gain insights, which helps us to make data-driven decisions easily. It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues more accurately. Through data insights from Denodo, we have been able to improve our decision making, which helps to better communication between the stakeholders thanks to the real-time experience. It also saves a lot of time.
Prasad Bodduluri - PeerSpot reviewer
Senior Data Warehouse Developer at itcinfotech
Has required complex workarounds for scripts and struggles with unstructured data processing
There is no issue with IBM InfoSphere DataStage's graphical interface for designing data flows, but I will provide feedback that we are gathering the source from the Oracle database mainly, as well as from some spreadsheets. With respect to the Oracle DB Connector, if you write any PL/SQL or SQL with the connectors, there aren't many options, such as executing procedures in the PL/SQL, executing functions, or executing packages. The Oracle connector doesn't have many features and needs improvement. Nowadays many people are writing programs in Python or in PL/SQL with respect to Oracle, so especially in IBM InfoSphere DataStage, there are no features to call programs directly instead of calling them as a script. What I am facing, especially with parallel processing, is that a developer and admin have to sit together. They have to run the job multiple times with different combinations of parallel processing to get the best performance. Instead of that, if the job itself gave some guidance, such as running this parallel processing with this many nodes, it would help; I think that is missing. An additional feature I would want to see in the next release is the ability to work on logs, especially machine logs or artificial logs, to pull semi-structured or unstructured data without having to write extensive code in Python and integrate it. If IBM InfoSphere DataStage provided some feature for this, it would help.
Hafiz Mannan - PeerSpot reviewer
Head of Data Services – Services Partner at 3 As Technologies
Facilitates complex data integration with ease and flexibility
It would be great if ODI could link the designer, mapping, and workflows in a more simplified manner, maybe in one combined interface. It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame instead of having the designer separately, mapping separately, and monitoring and session management separately. With respect to data quality challenges, it would be great to give an option to fix data quality issues based on AI. Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent. One of the main disadvantages of the Oracle Data Integrator (ODI) is that it sometimes takes a lot of resources when handling multiple jobs. The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement, and certain parallel threads should be added along with the ability to configure multiple jobs from the same data directory structure.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
892,383 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Database Administrator at a tech services company with 51-200 employees
Mar 31, 2014
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…
 

Top Industries

By visitors reading reviews
Financial Services Firm
22%
Manufacturing Company
12%
Government
7%
Energy/Utilities Company
6%
Financial Services Firm
24%
Manufacturing Company
8%
Government
8%
Computer Software Company
7%
Financial Services Firm
16%
Government
9%
Manufacturing Company
8%
Comms Service Provider
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise6
Large Enterprise21
By reviewers
Company SizeCount
Small Business23
Midsize Enterprise4
Large Enterprise26
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise44
 

Questions from the Community

Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit fro...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I ...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data...
Would you upgrade to more premium versions of IBM InfoSphere DataStage?
My company currently uses the free version of the product, and we are definitely switching to a paid one. We needed ...
Is IBM InfoSphere DataStage more difficult to use compared to other tools in the field?
I think the tool may cause some difficulties if you have not used other data integration solutions before. I have wo...
Do you rely on IBM Cloud Paks for your data? Have you utilized this product, or do you use IBM InfoSphere DataStage without it?
IBM Cloud Paks makes a big difference in your data integration. My company has been using it alongside IBM InfoSphere...
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for ...
What do you like most about Oracle Data Integrator (ODI)?
In comparison with other products of the same range, licensing mode is really attractive, no need to license accordin...
 

Also Known As

Denodo for AWS
No data available
ODI
 

Overview

 

Sample Customers

Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
Dubai Statistics Center, Etisalat Egypt
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Informatica, Microsoft, Qlik and others in Data Integration. Updated: March 2026.
892,383 professionals have used our research since 2012.