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

IBM Cloud Pak for Integration 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:
 

Categories and Ranking

IBM Cloud Pak for Integration
Average Rating
8.6
Reviews Sentiment
7.0
Number of Reviews
5
Ranking in other categories
API Management (29th), Cloud Data Integration (20th)
Oracle Data Integrator (ODI)
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
73
Ranking in other categories
Data Integration (12th)
 

Featured Reviews

Igor Khalitov - PeerSpot reviewer
Owner/Full Stack Software Engineer at Maraphonic, Inc.
Manages APIs and integrates microservices with redirection feature
IBM Cloud Pak for Integration includes monitoring capabilities to track the performance and health of your integrations. You can quickly roll back to a previous version if an issue arises. Additionally, it supports incremental deployments, allowing you to shift traffic to a new version of an API gradually. For example, you can start by directing 10% of traffic to the new version while the rest continue using the legacy version. If everything works as expected, you can gradually increase the traffic to the new version over time. IBM Cloud Pak for Integration has a client base that includes numerous organizations using AI and machine learning technologies. We leverage an open-source machine learning framework and integrate it with Kafka to help create and manage various products and data retrieval processes. For companies with private data, the framework first retrieves relevant data from a GitHub database, which is then combined with the final request before being sent to a language model like GPT. This ensures that the language model uses your specific data to generate responses. Kafka plays a key role by streaming real-time data from file systems and databases like Oracle and Microsoft SQL. This data is published to Kafka topics, then vectorized and used with artificial intelligence to enhance the overall process. It's like an old-fashioned approach. The best way is to redesign it with products such as Kafka. Overall, I rate the solution an eight out of ten.
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.

Quotes from Members

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

Pros

"In general, the solution works very, very well."
"It is a stable solution."
"Cloud Pak for Integration is definitely scalable. That is the most important criteria."
"The most preferable aspect would be the elimination of the command, which was a significant improvement. In the past, it was a challenge, but now we can proceed smoothly with the implementation of our policies and everything is managed through JCP. It's still among the positive aspects, and it's a valuable feature."
"Redirection is a key feature. It helps in managing multiple microservices by centralizing control and access."
"The most valuable aspect of the Cloud Pak, in general, is the flexibility that you have to use the product."
"Rather than taking your production, or your business, and trying to make it fit a tool, you do the opposite; you make the tool fit your business."
"The most valuable feature is Data movement."
"The initial setup is easy."
"Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting."
"The ROI is good."
"The CAEM is very useful in its modularity and portability."
"The speed in which we create/generate our ETL mappings has increased by at least a factor of four as compared to Oracle Warehouse Builder."
"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."
 

Cons

"Setting up Cloud Pak for Integration is relatively complex. It's not as easy because it has not yet been fully integrated. You still have some products that are still not containerized, so you still have to run them on a dedicated VM."
"The pricing can be improved."
"Its queuing and messaging features need improvement."
"Enterprise bots are needed to balance products like Kafka and Confluent."
"The initial setup is not easy."
"What needs to be improved is the restriction that they have on the product."
"Click intensive on mapping Lots of mouse clicking GUI could be improved."
"One of the main disadvantages of the Oracle Data Integrator (ODI) is that it sometimes takes a lot of resources when handling multiple jobs."
"Stability could be improved because some operators have issues."
"First, it needs better error handling (i.e. messages, debugging). Second, it also needs the ability to perform more complex interfaces (i.e. multiple sources to targets)."
"Right now, they integrate with Subversion, and in the future, there's going to be more tools implemented there for configuration management and some new features there, so right now it's kind of one of those features that has been released, but it's sort of a beta version of that feature where a lot more functionality will be coming down the line."
"I think Oracle should add more functions to improve optimization."
"Reverse engineering is complicated and challenging to manage."
"ODI's "in-memory RDBMS" is still a black box for programmers as there are no tools/dashboards to monitor/administrate this in-memory database."
 

Pricing and Cost Advice

"The solution's pricing model is very flexible."
"It is an expensive solution."
"The solution is very expensive."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
"I rate the platform pricing as five out of ten."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
909,725 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
13%
Manufacturing Company
12%
Construction Company
9%
Government
8%
Financial Services Firm
14%
Government
9%
Outsourcing Company
8%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise44
 

Questions from the Community

What needs improvement with IBM Cloud Pak for Integration?
Enterprise bots are needed to balance products like Kafka and Confluent.
What is your primary use case for IBM Cloud Pak for Integration?
It manages APIs and integrates microservices at the enterprise level. It offers a range of capabilities for handling APIs, microservices, and various integration needs. The platform supports thousa...
What advice do you have for others considering IBM Cloud Pak for Integration?
IBM Cloud Pak for Integration includes monitoring capabilities to track the performance and health of your integrations. You can quickly roll back to a previous version if an issue arises. Addition...
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 those who might find the setup to be challenging. There are complications that c...
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 according technology/topology to be used and an incredible Versatility to build any Data...
 

Also Known As

No data available
ODI
 

Overview

 

Sample Customers

CVS Health Corporation
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration. Updated: August 2026.
909,725 professionals have used our research since 2012.