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 (22nd)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
74
Ranking in other categories
Data Integration (3rd)
 

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.
Sean Achim - PeerSpot reviewer
Building impactful organizational KPIs with ease and precision
Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.

Quotes from Members

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

Pros

"It provides a good response for external microservices applications."
"GoldenGate can aggregate various data types from different sources."
"GoldenGate's best features are the desktop security features."
"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."
"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."
"Oracle Database generally guarantees a good response for customer use cases."
"Overall, it's a good product."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."
"The initial setup was easy."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The UI is very user-friendly."
 

Cons

"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."
"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."
"I am not very happy with Oracle Support. Over the past four to five years, I have experienced many problems when opening support requests."
"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."
"Support could be improved. They lack knowledge."
"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."
"Video training would be a helpful addition."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
"I would like to see better integration with Power BI."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
 

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 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."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"SSIS is fairly well-priced - I would rate it at four out of five."
"People have to opt for a perpetual-based licensing model."
"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."
"We have an enterprise license for this solution."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
859,129 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
8%
Computer Software Company
8%
Manufacturing Company
8%
Financial Services Firm
19%
Computer Software Company
11%
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?
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...
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: June 2025.
859,129 professionals have used our research since 2012.