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

Oracle GoldenGate Cloud Service vs SSIS 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 GoldenGate Cloud Ser...
Average Rating
8.0
Reviews Sentiment
7.4
Number of Reviews
7
Ranking in other categories
Cloud Data Integration (15th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Featured Reviews

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.
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Quotes from Members

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

Pros

"GoldenGate's best features are the desktop security features."
"We are heavily involved with GitHub for managing repositories, automatic deployments, and inner source projects."
"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 Database generally guarantees a good response for customer use cases."
"Oracle GoldenGate Cloud Service is valued for its ability to replicate data in real-time, offering significant benefits from a data perspective."
"GoldenGate can aggregate various data types from different sources."
"It provides a good response for external microservices applications."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The product's deployment phase is easy."
"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The technical support is very good."
"SSIS integrates well with SQL servers and Microsoft products."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
 

Cons

"Oracle GoldenGate Cloud Service lacks AI. If AI gets introduced in Oracle GoldenGate Cloud Service, it would be much easier to do analysis."
"Support could be improved. They lack knowledge."
"Over the past four to five years, I have experienced many problems when opening support requests."
"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."
"The initial setup was a little complex, and we required support from Oracle to complete it."
"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."
"I am not very happy with Oracle Support. Over the past four to five years, I have experienced many problems when opening support requests."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"We'd like them to develop data exploration more."
"The high prices attached to the product can be an area of concern where improvements are required."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The performance of this solution is not as good as other tools in the market."
 

Pricing and Cost Advice

"I rate the product price a six on a scale of one to ten, where one is cheap, and ten is expensive."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"The solution is available at a lesser price than that of Informatica."
"Our license with SSIS is annual."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"All of my clients have this product included as part of their Microsoft license."
"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
"People have to opt for a perpetual-based licensing model."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
850,076 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Energy/Utilities Company
11%
Computer Software Company
10%
Manufacturing Company
10%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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?
Today, pricing is not an aspect I usually manage, however, I have a feeling from my customers that they are not very happy. In the past, we considered other cloud providers like AWS. The point is t...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

No data available
SQL Server Integration Services
 

Overview

 

Sample Customers

FORTH, Capital One
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Oracle GoldenGate Cloud Service vs. SSIS and other solutions. Updated: April 2025.
850,076 professionals have used our research since 2012.