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.3
Number of Reviews
7
Ranking in other categories
Cloud Data Integration (22nd)
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

"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."
"It provides a good response for external microservices applications."
"Scalability-wise, I rate the solution a ten out of ten."
"We are heavily involved with GitHub for managing repositories, automatic deployments, and inner source projects."
"Oracle Database generally guarantees a good response for customer use cases."
"GoldenGate's best features are the desktop security features."
"GoldenGate can aggregate various data types from different sources."
"Oracle GoldenGate Cloud Service is valued for its ability to replicate data in real-time, offering significant benefits from a data perspective."
"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The solution is easy to use and developer friendly."
"The initial setup was easy."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
 

Cons

"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."
"Support could be improved. They lack knowledge."
"Oracle is always adding new features. I can't think of anything that's urgent currently."
"I am not very happy with Oracle Support. Over the past four to five years, I have experienced many problems when opening support requests."
"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 GoldenGate Cloud Service lacks AI. If AI gets introduced in Oracle GoldenGate Cloud Service, it would be much easier to do analysis."
"Over the past four to five years, I have experienced many problems when opening support requests."
"The security could be improved, as it is more important in our context."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Performance could be better."
"It would be nice if you could run SSIS on other environments besides Windows."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
 

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."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"The solution is available at a lesser price than that of Informatica."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"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."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"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."
"Our license with SSIS is annual."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
847,862 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
15%
Manufacturing Company
12%
Energy/Utilities Company
11%
Computer Software Company
10%
Financial Services Firm
18%
Computer Software Company
12%
Government
8%
Healthcare 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.
847,862 professionals have used our research since 2012.