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

Oracle Data Integrator (ODI) vs ibi Open Data Hub for Mainframe comparison

Why PeerSpot?
 

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

ibi Open Data Hub for Mainf...
Ranking in Data Integration
64th
Average Rating
10.0
Reviews Sentiment
5.4
Number of Reviews
1
Ranking in other categories
No ranking in other categories
Oracle Data Integrator (ODI)
Ranking in Data Integration
12th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
73
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2026, in the Data Integration category, the mindshare of ibi Open Data Hub for Mainframe is 0.6%, up from 0.5% compared to the previous year. The mindshare of Oracle Data Integrator (ODI) is 2.9%, down from 3.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Oracle Data Integrator (ODI)2.9%
ibi Open Data Hub for Mainframe0.6%
Other96.5%
Data Integration
 

Featured Reviews

it_user3876 - PeerSpot reviewer
Database Manager at a tech company with 51-200 employees
Provides High Reliability and Data Security
• Data in the datahub refreshes nightly. As the data only refreshes once every day, it is necessary to have to wait for any changes to thesource systems to become available.The daily refresh can be extremely useful for reconciling data. • DataHub only displays details of current members of the Organization. So it has much limited data available for generation of dynamic reports. • DataHub is volatile. The records are completely re-loaded each day. It puts burden on the system. • There are very few summary tables available due to storage of data in a detailed format. • The detailed information is not stored in the DataHub. It is stored in the relevant source system. Only commonly required data is stored within the DataHub.
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

"All staff members and users can request an account which can be accessed from all PCs on the company’s network."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"Oracle Data Integrator (ODI)'s ELT architecture has helped optimize my data movement and transformation significantly."
"Before adopting this solution we used to work hard, and we now feel better because our manual work is completely over."
"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."
"It increased ETL development efficiency 1/3 in time."
"The best feature of this solution is the documentation, as everything is set out clearly with step-by-step instructions."
"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"We spend much less time developing integrations because all we need to focus on is the business logic."
 

Cons

"DataHub is volatile; the records are completely re-loaded each day, which puts a burden on the system."
"Although we're satisfied with its overall performance in terms of integrity, scalability, and usability, it could be improved by including a separate UI for viewing the session runs through the operator layer of ODI."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The main problem with ODI is that you have to create each step of the transformation as a new interface. A big data flow can have more than 100 interfaces, which can make it difficult to trace the data."
"I would like more different tools of transformation. In the current version I have only worked with lookup and filter, and sometimes it is not good enough for what I use it for."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration."
"The Oracle Data Integrator interface is extremely slow, especially when using remote desktop connections."
"It used to crash with large datasets."
"Error handling can always be improved with ODI. A lot of the errors are generic, but I will say that with a little experience, you can decipher the errors to help you fix them."
 

Pricing and Cost Advice

Information not available
"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."
"The solution is very expensive."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"ODI comes included when buying the cloud version of the Oracle database license."
"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."
"The solution is expensive because of the model they use. The cost is for the license and for support."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
919,586 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
Construction Company
20%
Performing Arts
12%
Comms Service Provider
12%
Financial Services Firm
9%
Financial Services Firm
14%
Outsourcing Company
10%
Manufacturing Company
9%
Government
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

Ask a question
Earn 20 points
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

iWay Data Hub, Data Hub, Information Builders Data Hub
ODI
 

Overview

 

Sample Customers

Ford Motor Company, City of Erlanger, Kentucky Police Dept., Helzberg Diamond Inc.
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Informatica, Palantir, Microsoft and others in Data Integration. Updated: October 2026.
919,586 professionals have used our research since 2012.