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

Oracle Data Integrator (ODI) vs Oracle GoldenGate 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 (ODI)
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
Data Integration (8th)
Oracle GoldenGate Cloud Ser...
Average Rating
8.0
Reviews Sentiment
7.4
Number of Reviews
7
Ranking in other categories
Cloud Data Integration (22nd)
 

Featured Reviews

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…
Emmanuel Catalano - PeerSpot reviewer
Offers reliable data management and simple to use but requires more intuitive configuration
I am not very happy with Oracle Support. Over the past four to five years, I have experienced many problems when opening support requests. A lot of the time, the support asks the same questions repeatedly, which takes time. Usually, I solve my issue myself before they give me solutions. It seems like they do not really understand my problem, even if I translate what I want to say from Italian with tools like Google Translate. Sometimes it is very difficult to communicate with them. We have some Oracle support staff in Italy whom I can reach directly, which helps, but there seems to be a problem with the support requests. It is also an issue when different Oracle representatives handle my request at different times and ask me to explain the problem again despite it being written in the support request. This makes it very frustrating. Additionally, issues arise with product understanding. For example, in dedicated infrastructure, the Oracle staff handling the support request may not be familiar with the product or suggest solutions suitable for other infrastructures but not mine. Oracle Support should know the solutions that fit my infrastructure since they manage it, not me.

Quotes from Members

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

Pros

"It's scalable."
"The CAEM is very useful in its modularity and portability."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"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."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"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."
"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 provides a good response for external microservices applications."
"This has significantly eased the process of migration from on-premise to cloud. Instead of configuring everything from the ground up, the Oracle GoldenGate Cloud Service has made it seamless to build and render databases in cloud."
"Scalability-wise, I rate the solution a ten out of ten."
"Oracle GoldenGate Cloud Service is valued for its ability to replicate data in real-time, offering significant benefits from a data perspective."
"GoldenGate's best features are the desktop security features."
"GoldenGate can aggregate various data types from different sources."
"Oracle Database generally guarantees a good response for customer use cases."
"We are heavily involved with GitHub for managing repositories, automatic deployments, and inner source projects."
 

Cons

"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"If you have something like Cisco on top of it, you will have endless problems."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"We used a third party to do the implementation of ODI."
"The performance of the user interface is in need of improvement."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"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."
"Over the past four to five years, I have experienced many problems when opening support requests."
"Support could be improved. They lack knowledge."
"The initial setup was a little complex, and we required support from Oracle to complete it."
"I am not very happy with Oracle Support. Over the past four to five years, I have experienced many problems when opening support requests."
"Oracle GoldenGate Cloud Service lacks AI. If AI gets introduced in Oracle GoldenGate Cloud Service, it would be much easier to do analysis."
"Pricing is rather expensive. Oracle typically prices on the higher side, and there is scope for them to reconsider the price, especially since it is a cloud service."
"Oracle is always adding new features. I can't think of anything that's urgent currently."
"More technical documentation is needed, especially in terms of mapping and conversion of data, while integration would also be very helpful."
 

Pricing and Cost Advice

"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."
"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."
"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."
"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."
"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."
"I rate the platform pricing as five out of ten."
"I rate the product price a six on a scale of one to ten, where one is cheap, and ten is expensive."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
865,384 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
Financial Services Firm
17%
Government
9%
Computer Software Company
9%
Manufacturing Company
7%
Financial Services Firm
11%
Manufacturing Company
9%
Government
7%
Energy/Utilities Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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...
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...
What do you like most about Oracle GoldenGate Cloud Service?
Scalability-wise, I rate the solution a ten out of ten.
What is your experience regarding pricing and costs for Oracle GoldenGate Cloud Service?
Pricing is rather expensive. Oracle typically prices on the higher side, and there is scope for them to reconsider the price, especially since it is a cloud service.
What needs improvement with Oracle GoldenGate Cloud Service?
One area that could be improved is the configuration flexibility. There are a lot of restrictions on how it can be configured because it is being deployed in the cloud. More flexibility for develop...
 

Also Known As

ODI
No data available
 

Overview

 

Sample Customers

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