No more typing reviews! Try our Samantha, our new voice AI agent.

Oracle GoldenGate Cloud Service vs SSIS comparison

Why PeerSpot?
 

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.1
Number of Reviews
8
Ranking in other categories
Cloud Data Integration (21st)
SSIS
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
Data Integration (3rd)
 

Featured Reviews

Tarek Diab - PeerSpot reviewer
Advisor Business Analysis & Data Management at Saudi Telecom Company
Real-time integration and seamless data synchronization enhance user experience
The stability of Oracle GoldenGate Cloud Service is one of its most useful features, although its performance is not too steady. It excels with bidirectional data synchronization. It supports diverse databases and platforms. We link the ODS with numerous source systems, including Oracle, Tarek Data, and Microsoft, with no integration issues. The solution caters to enterprise needs, fitting any organizational requirement, apart from data security issues common to cloud solutions. The cloud data security challenge is notable, necessitating solutions such as private cloud offerings to allay security concerns.
reviewer2318280 - PeerSpot reviewer
Tech Lead at a consultancy with 11-50 employees
Reporting has become streamlined for year-end data checks but integration still needs improvement
When I talk about SQL Server, I am working with SSIS, the data integration tool. I am not entirely sure if I use SSIS as a library of transformations or if I personally work with an extensive library of transformations. I have integrated SSIS with SQL Server Management Studio, and I am very satisfied with the integration as it is integrated well. I am not using the debugging feature in SSIS because the developers would be the ones that would actually utilize it. I have noticed that in 2022, AI functionality has actually been implemented already. I would rate this review overall at a 7.

Quotes from Members

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

Pros

"Oracle GoldenGate Cloud Service is valued for its ability to replicate data in real-time, offering significant benefits from a data perspective."
"GoldenGate is a good solution to implement in terms of scalability and flexibility."
"Scalability-wise, I rate the solution a ten out of ten."
"It provides a good response for external microservices applications."
"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."
"This has significantly eased the process of migration from on-premise to cloud, as instead of configuring everything from the ground up, the Oracle GoldenGate Cloud Service has made it seamless to build and render databases in cloud."
"The workflow features have been very valuable; you can have automated workflows and all the steps are controlled, and the workflow functionality of integration services is excellent."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market."
"SSIS integrates well with SQL servers and Microsoft products, is a cheaper option than other ETL tools, has a lot of in-built transformation, and is easy to learn."
"The stability is very good and I recommend it to my friends, my coworkers, and the other companies."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It's saved time using visualization descriptions."
 

Cons

"Support could be improved. They lack knowledge."
"The initial setup was a little complex, and we required support from Oracle to complete it."
"With Oracle GoldenGate Cloud Service, we have usual cloud solution issues such as privacy and data security."
"More technical documentation is needed, especially in terms of mapping and conversion of data, while integration would also be very helpful."
"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."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"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."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"Sometimes, there are compatibility issues with some features."
"This solution is stable, but the performance is not good."
"Need to improve error logging although it does provide error logs but there is still more room for improvement in this area."
"Another consideration is real-time processing needs. If this is a requirement then I would recommend against using this solution, unless the next version has a new set of features specifically for real-time processing."
 

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."
"The solution is available at a lesser price than that of Informatica."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"The solution comes free of cost."
"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"This solution is included with the MSSQL server package."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
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
Construction Company
15%
Manufacturing Company
11%
Comms Service Provider
10%
Performing Arts
7%
Financial Services Firm
13%
Construction Company
8%
Manufacturing Company
8%
Outsourcing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Midsize Enterprise1
Large Enterprise4
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise58
 

Questions from the Community

What is your experience regarding pricing and costs for Oracle GoldenGate Cloud Service?
I do not have an idea about the solution's cost, but given the ongoing use, it appears to be good for them.
What needs improvement with Oracle GoldenGate Cloud Service?
With Oracle GoldenGate Cloud Service, we have usual cloud solution issues such as privacy and data security. These issues especially concern clients needing a private cloud solution to meet regulat...
What is your primary use case for Oracle GoldenGate Cloud Service?
We are using Oracle GoldenGate Cloud Service for real-time data integration, as our audience is real-time. Oracle GoldenGate Cloud Service is used for ODS operating data store in SSD. For the ODS, ...
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 is your experience regarding pricing and costs for SSIS?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
What needs improvement with SSIS?
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly. The initial setup for SSIS is somewhat complex in the beginning, but once you und...
 

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 Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration. Updated: September 2026.
915,341 professionals have used our research since 2012.