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

Oracle Data Integrator (ODI) vs Oracle Data Integrator Cloud Service 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

Oracle Data Integrator Clou...
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
7
Ranking in other categories
Cloud Data Integration (20th)
Oracle Data Integrator (ODI)
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
Data Integration (7th)
 

Featured Reviews

Peeyush Chouksey - PeerSpot reviewer
Allows us to integrate different cloud services with different applications
It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot. When it comes to mapping, you are quite restricted. If you have to use a specific, typical function, you need to do a Java callout or something. OSB has a lot of features they are using like Java APIs because it's on-premises.
Jozsef Gazsik - PeerSpot reviewer
Offers a very good development environment and supports the use of multiple programming languages
We are using a graphical tool called PowerDesigner to create logical and physical models. From that, we create code that can be run by Oracle Data Integrator, which then maps the data based on these models and sends it to its destination. It is currently very integrated with Oracle The Oracle…

Quotes from Members

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

Pros

"Having a single vendor supporting the entire suite of applications."
"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"It's on the cloud, so it's scalable and quite easy to work with."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It uses the power of the database system efficiently."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"The initial setup is easy."
"Oracle Data Integrator offers a very good development environment and supports the use of multiple programming languages, including Python. It runs scenarios effectively, even when executing complex, long SQL scripts that are not runnable on other clients."
"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."
"The product has an ELT approach."
"It is an ETL tool, which does the extract, transform, and load."
 

Cons

"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"I've found technical support not very effective. They should work to improve their services."
"This is an expensive solution compared to other products on the market."
"The pricing could be more competitive."
"Bulk uploading can be a problem when you hit the upper limit."
"I would like to see different cloud adapters or connectors in case of integration. When you have Oracle to Oracle, they are good. They have really good connectors, but if it is a different ERP, like Obsidian, that is where they are faced with problems in OIC."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"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."
"Oracle support services are not up to the mark."
"It needs easier security."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"Stability could be improved because some operators have issues."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
 

Pricing and Cost Advice

"The price is competitive compared to Boomi which is much higher."
"The solution is very expensive."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"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."
"I rate the platform pricing as five out of ten."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"ODI comes included when buying the cloud version of the Oracle database license."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
861,524 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
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
No data available
Financial Services Firm
18%
Computer Software Company
11%
Government
9%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Data Integrator Cloud Service?
The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process.
What needs improvement with Oracle Data Integrator Cloud Service?
It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process str...
What is your primary use case for Oracle Data Integrator Cloud Service?
I have experience working with Korean Telecom (Katie) on various projects involving data integration, especially with Oracle databases. These projects included tasks such as data collection, ETL (E...
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...
What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?
If I use the whole Oracle system, it can be cost-effective. ODI is cheaper compared to Informatica PowerCenter ( /products/informatica-powercenter-reviews ) and IBM DataStage. However, for tools li...
 

Also Known As

No data available
ODI
 

Overview

 

Sample Customers

Amplifon
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. Oracle Data Integrator Cloud Service and other solutions. Updated: July 2025.
861,524 professionals have used our research since 2012.