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

Oracle Data Integrator (ODI) vs Oracle Database 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.9
Oracle Data Integrator offers strong ROI through automation and efficiency, with positive feedback on stability and cloud enhancements.
Sentiment score
5.7
Organizations experience good long-term ROI with Oracle Database, despite high initial costs, especially in high-traffic financial sectors.
It saved a lot of money and time because of the debugging peculiarities and also using Toad for Oracle software to optimize the coding and performance of data migration.
Qhse Manager at a outsourcing company with 10,001+ employees
 

Customer Service

Sentiment score
5.8
ODI customer support solves issues effectively, yet users face response delays, communication challenges, especially in multi-technology integrations.
Sentiment score
6.1
Oracle Database's customer service receives mixed reviews, highlighting responsiveness but concerns about response times and global support.
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
In some cases, they support me on a 24/7 basis, round the clock.
Senior Vice President IT Operations at ZTBL
Oracle support can improve both response time and quality, including not only response time but also the turnaround time for issue fixing, understanding the issue, routing it to the correct team, and debugging for resolution.
DB A Competency Manager at a computer software company with 201-500 employees
The customer support of Oracle Database is excellent and provides detailed assistance.
Qhse Manager at a outsourcing company with 10,001+ employees
 

Scalability Issues

Sentiment score
7.6
Oracle Data Integrator is scalable and adaptable, handling large projects effectively, though resource demands may pose challenges.
Sentiment score
7.4
Oracle Database is highly scalable, adaptable for growth, though its licensing model may impact scalability costs.
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
The database regularly releases new versions with better performance and security features.
Chief Executive Officer at LeaseWeb
RAC is the feature where I can distribute the load among multiple nodes, and it has helped our enterprise applications.
Senior Vice President IT Operations at ZTBL
 

Stability Issues

Sentiment score
7.4
Oracle Data Integrator shows strong stability improvements, with rare issues, efficient management of large volumes, and occasional integration challenges.
Sentiment score
8.0
Oracle Database is stable, reliable, handles vast data with minimal downtime, and is trusted for critical applications requiring data integrity.
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
Oracle Database is very robust, and I rate its stability nine out of ten.
Chief Executive Officer at LeaseWeb
I would rate stability for Oracle Database as a 10.
DB A Competency Manager at a computer software company with 201-500 employees
Oracle is really one of the biggest database software companies in the world.
Qhse Manager at a outsourcing company with 10,001+ employees
 

Room For Improvement

ODI needs better UI performance, tool compatibility, GitHub integration, error handling, real-time AI features, pricing, and external version control.
Oracle Database needs improved tools, cost-effective licensing, better support, easier setup, and enhanced integration with modern technologies.
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
Having that visibility of all the software products and providing free training and documentation on how you can improve and which products are best suited for integration to your product from Oracle would go a long way to help organizations and professionals.
Qhse Manager at a outsourcing company with 10,001+ employees
Oracle Database needs improvement in data analytics capabilities, AI involvement, machine learning, and deep learning.
Chief Executive Officer at LeaseWeb
One existing feature that distinguishes Oracle Database from others is its ability to log errors in the database itself.
Business Analyst at Tata Consultancy
 

Setup Cost

Oracle Data Integrator pricing varies; costs are influenced by licensing complexity, with potential savings through discounts and bundled solutions.
Oracle Database is robust but expensive, with high licensing costs, prompting small businesses to seek cheaper alternatives.
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
For medium businesses, Oracle and IBM DB2 pricing are quite similar.
Chief Executive Officer at LeaseWeb
Oracle Database is costly.
Senior Vice President IT Operations at ZTBL
 

Valuable Features

Oracle Data Integrator optimizes EL-T processing with flexible integration, supporting diverse technologies and enhancing data management efficiency.
Oracle Database is preferred for its robust security, scalability, high availability, disaster recovery, and integration capabilities.
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
Its data management capabilities include data quality, data integration, data architecture, modeling, and data security, which are very important for data-driven companies.
Chief Executive Officer at LeaseWeb
Regarding what I value about Oracle Database, as far as execution is concerned, I think it is one of the best databases I have come across.
Business Analyst at Tata Consultancy
The most valuable features in WebLogic Suite are its stability and security.
Senior Vice President IT Operations at ZTBL
 

Categories and Ranking

Oracle Data Integrator (ODI)
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
73
Ranking in other categories
Data Integration (10th)
Oracle Database
Average Rating
8.6
Reviews Sentiment
7.3
Number of Reviews
294
Ranking in other categories
Relational Databases Tools (2nd), Database Management Systems (DBMS) (2nd)
 

Mindshare comparison

Oracle Data Integrator (ODI) and Oracle Database aren’t in the same category and serve different purposes. Oracle Data Integrator (ODI) is designed for Data Integration and holds a mindshare of 2.6%, down 4.3% compared to last year.
Oracle Database, on the other hand, focuses on Relational Databases Tools, holds 10.4% mindshare, down 12.4% since last year.
Data Integration Mindshare Distribution
ProductMindshare (%)
Oracle Data Integrator (ODI)2.6%
Informatica Intelligent Data Management Cloud (IDMC)3.7%
SSIS3.7%
Other90.0%
Data Integration
Relational Databases Tools Mindshare Distribution
ProductMindshare (%)
Oracle Database10.4%
SQL Server10.5%
IBM Db2 Database6.6%
Other72.5%
Relational Databases Tools
 

Featured Reviews

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.
Philemon Olusegun - PeerSpot reviewer
Qhse Manager at a outsourcing company with 10,001+ employees
Reliable backups and high-capacity data management have transformed large-scale census projects
When it comes to how Oracle Database can be improved, for me it is all about training and development in terms of gamification, creating awareness, and spreading the word to aspiring database administrators and database developers. As I have used it in the past and in recent times, many people are trying to get into IT, so the opportunity exists. Oracle has the market opportunity to take this time to spread its offerings and ensure that many aspiring professionals are aware of its services and products. From my perspective, there is not much to add regarding the needed improvements for the interface and the documentation. I give it a nine because I think Oracle sometimes can make things complicated. You have many services, many products, and many tools for different use cases. So it is difficult for someone who is only used to a particular product, such as Oracle Database, to understand all the other products and services that it provides. Probably streamlining it and making it available with categorized use cases for specific job roles would help. If you are a database developer, these are the tools that you need to be familiar with in Oracle's suite of products, and if you are a database administrator, these are the tools. Categorizing them based on the job role or function of people who are accessing these products and providing training capabilities on how to use them and how these products interchange and talk to each other would be very important because that is one of the things I struggled with when I started my journey as an Oracle Database administrator. Having that visibility of all the software products and providing free training and documentation on how you can improve and which products are best suited for integration to your product from Oracle would go a long way to help organizations and professionals. Regarding Oracle Database's AI capabilities, I am very keen on its governance and security. I think more work needs to be done on the security and ensuring that the database for a large number of people is watertight. AI is here to stay; however, governance and more stress testing of the AI capabilities needs to be done to ensure there is no breach of data. I would rate it currently at 6 over 10 and there is room for improvement. As long as there are government policies and Oracle policies that can mitigate any breaches of data and serious security issues, releasing people's records over the internet, there is always room for improvement in that regard.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
904,748 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
14%
Government
9%
Manufacturing Company
8%
Outsourcing Company
7%
Financial Services Firm
12%
Construction Company
12%
Outsourcing Company
9%
Manufacturing Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise44
By reviewers
Company SizeCount
Small Business87
Midsize Enterprise66
Large Enterprise180
 

Questions from the Community

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...
How do you run Oracle Database at your organization and why?
My company has been using Oracle Exadata Database Service for some years now, and we are happy with it. I will allow myself to answer your questions about why and what benefits it provides us with ...
Do you know of any disadvantages of Oracle Database?
Undoubtedly, Oracle Database is a top product in its category. But it does have its disadvantages, and for me and my organization, that has been the limitations of the product. When it comes to Ora...
What is the best use for Oracle Database?
Oracle Database is flexible and can be used for many things. My company's main use case for this product is for storing data. We benefit from its high level of security as well as from the fact tha...
 

Also Known As

ODI
Oracle 12c, RDBMS
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Agncia Nacional de guas, Anbima, Aria Systems, Asiana Airlines, Astelit LLC, Australian Finance Group, Banco Occidental de Descuento, Bharat Petroleum Corporation Limited, BT, Caja de Seguros S.A., Casas GEO S.A.B. de C.V., Comic Relief UK, Corsair Components Inc., CSAM Health AS, CSOB Group, Datacraft Solutions, DenizBank A.S., Department of Treasury and Finance WA, Office of State Revenue, Deutsche B_rse AG, Deutsche Lufthansa AG, Deutsche Messe AG, Digicel Haiti, DPR COSEA, Essar Group, Essatto Software Pty Ltd, Farmšcia e Drogaria Nissei Ltda., Fomento Econ‹mico Mexicano S.A.B. de C.V. (FEMSA), FundaÊo Petrobras de Seguridade Social, Future Group, GFKL Financial Services AG, Grupo Posadas S.A.B. de C.V., Grupo Sinosserra, Guerra S.A. Implementos Rodovišrios, Hanatour International Service, Hays plc, Henan Mobile Co. Ltd, Hochschule Hof, Hong Kong and China Technology (Wuhan) Co. Ltd (Towngas Technology), Industries Corpa_al C.A., Infrastructure Development Finance Company Limited, Instituto Brasileiro de Geografia e Estatstica, Instituto Mexicano de la Propiedad Industrial, Kcell, LinkShare Corporation, MercadoLibre Inc., MetLife Inc., Nextgen Distribution, €BB-IKT GmbH, Octagon Research Solutions, Pacific Lutheran University, Paragon Data GmbH, Ping ltd., PJSC Trustbank, Prodaub _ Processamento de Dados de Uberl_ndia, Purdue University, Redknee Inc., Robi Axiata Limited, Shanghai Infoservice Technology Co. Ltd, Shanghai Sihua Technologies Co. Ltd, Sistema de Aguas de la Ciudad de M_xico, Solihull Metropolitan Borough Council, Suddenlink Communications, Suprajit Engineering Limited, Tallink Grupp, Terminales Ro de la Plata S.A., Therap Services LLC, Think Passenger Inc., Trafigura, Transmed S.A.L Lebanon, ValeShop, VelQuest Corporation, Vodafone Group plc, West Virginia Network, WIND Hellas Telecommunications S.A
Find out what your peers are saying about Informatica, Microsoft, Palantir and others in Data Integration. Updated: July 2026.
904,748 professionals have used our research since 2012.