Oracle GoldenGate vs SSIS comparison

Oracle and Microsoft are both solutions in the Data Integration category. Oracle is ranked #8 with an average rating of 8.3, while Microsoft is ranked #4 with an average rating of 8.0. Oracle holds a 3.6% mindshare in DI, compared to Microsoft’s 8.0% mindshare. Additionally, 96% of Oracle users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Oracle GoldenGate

Read 49 Oracle GoldenGate reviews

6,629 Views
4,732 Comparison Views

96% willing to recommend

SSIS

Read 72 SSIS reviews

13,122 Views
10,210 Comparison Views

79% willing to recommend

Oracle GoldenGate

SSIS

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

SSIS and Oracle GoldenGate compete in the data integration sector. Oracle GoldenGate holds an advantage with superior real-time data processing and scalability, while SSIS is favored for its cost-effectiveness and ease of use.

Features: SSIS offers data transformation and workflow management, seamlessly integrating with Microsoft products, making it optimal for Microsoft environments. Oracle GoldenGate provides real-time data synchronization, high availability, and heterogeneous environment support, suiting enterprises requiring quick data replication and integration.

Room for Improvement: SSIS could enhance its real-time data handling, increase scalability, and improve support for non-Microsoft platforms. Oracle GoldenGate might simplify its deployment process, reduce complexity for smaller enterprises, and offer more competitive pricing.

Ease of Deployment and Customer Service: SSIS is praised for its straightforward integration in Microsoft settings, benefitting from SQL Server support resources. Oracle GoldenGate, though needing a complex deployment for multi-platform support, delivers comprehensive technical assistance, catering to diverse infrastructures.

Pricing and ROI: SSIS is cost-effective with lower initial setup costs and flexible pricing, offering an attractive ROI for budget-conscious organizations. Oracle GoldenGate, despite higher expenses, provides substantial ROI through advanced real-time data management and efficiency improvements.

To learn more, read our detailed Oracle GoldenGate vs. SSIS Report (Updated: February 2025).

Buyer's Guide

Oracle GoldenGate vs. SSIS

February 2025

Download the complete report

Helped 838,640 peers since 2012

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

Ranking in Data Integration

8th

Average Rating

8.2

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

SSIS

Ranking in Data Integration

4th

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of Oracle GoldenGate is 3.6%, down from 3.8% compared to the previous year. The mindshare of SSIS is 8.0%, up from 8.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Q&A Highlights

RajneeshShukla

Solution Architect at a tech vendor with 10,001+ employees

Sep 09, 2021

Which ETL tool would you recommend to populate data from OLTP to OLAP?

We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator). But OLAP exporting wasn't in our scope until now.

See all answers

Featured Reviews

Vijay Manoharan

IT Technical Specialist at a healthcare company with 10,001+ employees

Performs real-time replication without data loss, but we cannot do much automation

The setup with the classic GoldenGate architecture was easy. Oracle has now moved to Microservices Architecture. It is a real pain. There are a lot of new things we have to learn. I rate the ease of setup of the classic architecture a seven out of ten. For Microservices, I rate the ease of setup a three out of ten. The deployment takes a couple of hours. We need one system administrator to deploy the tool. We need to maintain the tool. We are a team of four people. We need at least three people for maintenance. The time taken for maintenance depends on how big the environment is. We spend a lot of time on maintenance because our environment is big.

Read full review

BobAmy

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

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.

Read full review

Quotes from Members

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

Pros

"The product's initial setup phase was very simple."

"The platform's most helpful features are its speed and its guarantee of data replication from one database to another."

"They've recently improved the ease of implementation."

"With Oracle GoldenGate, you can easily sync the tables and put them into the ODS database."

"It is quite scalable."

"The live application feature is most valuable. The solution is stable. I rate it a seven out of ten."

"Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."

"It scales well. You can either have it working in with the databases, or you can move it outside. It's got the ability to parallelize up, so you can certainly extract and replay the data from your databases in parallel. So it does have horizontal scalability. That is probably one of its stronger features, the ability just to automatically parallelize the replay and playing of data to allow to scale to large volumes."

More Oracle GoldenGate pros

"The simplicity of the solution is great. The solution also offers excellent integration."

"The most valuable features of this solution are the fast insert and fuzzy logic matching."

"It has good data integration and good processes."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"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."

"SSIS' most valuable feature is its reporting services."

"It is easy to set up the product."

"The UI is very user-friendly."

More SSIS pros

Cons

"Monitoring must be a bit more enhanced."

"I find the user interface to be difficult for non-technical people."

"A clean and user-friendly graphical interface based on common design principles would be beneficial."

"It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."

"The front-end management isn't very good."

"The problem with GoldenGate is it is very complex to use. You need heavyweight skills to use it."

"The tool's connections are disconnected at times. The tool needs to integrate other databases."

"The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging."

More Oracle GoldenGate cons

"Generic processes should be used instead of custom code for each table."

"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."

"SSIS is not stable."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

"SSIS is stable, but extensive ETL data processing can have some performance issues."

"Improvement as per customer requirements."

"The performance of SSIS could improve when comparing it to Oracle Database."

"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."

More SSIS cons

Pricing and Cost Advice

"The product is expensive."

"Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing. There don't seem to be any additional costs."

"We do like the price of this solution."

"Oracle GoldenGate's license can be expensive compared to other solutions like Qlik Replicate or SAP Replicate."

"The return on investment would make it a worthwhile deal."

"The price is high. Consequently, when clients or customers acquire the solution, they tend to utilize it to its maximum extent due to this factor."

"The solution would be costly for a small organization."

"The price of Oracle GoldenGate should be lowered. It is expensive compared to other solutions."

More Oracle GoldenGate pricing and cost advice

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"All of my clients have this product included as part of their Microsoft license."

"SSIS' licensing is a little high, but it gives good value for money."

"The solution is available at a lesser price than that of Informatica."

"Our license with SSIS is annual."

"This solution is included with the MSSQL server package."

"It would be beneficial if the solution had a less costly cloud offering."

"The solution comes free of cost."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

838,640 professionals have used our research since 2012.

Comparison Review

it_user90069

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…

Read full review

Answers from the Community

RajneeshShukla

Solution Architect at a tech vendor with 10,001+ employees

Sep 9, 2021

Which ETL tool would you recommend to populate data from OLTP to OLAP?

There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables . Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs There are many other pure ETL ...

2 out of 12 answers

Stefan Schäfer

CEO / Owner with 51-200 employees

Apr 6, 2020

We usually use Talend. Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719

Read full answer

RajneeshShukla

Solution Architect at a tech vendor with 10,001+ employees

Apr 7, 2020

Thanks Stefan !!! May I know if Talend is opensource /free ? It is available in all 3 editions - basic , standard end enterprise? it is capable to read data from all heterogeneous system like various types of data bases and files etc..?

Read full answer

See all 12 answers

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

12%

Manufacturing Company

Government

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Oracle GoldenGate?

The product is reliable for data integrity.

See all answers

What is your experience regarding pricing and costs for Oracle GoldenGate?

The pricing of Oracle GoldenGate is quite high. However, its cost-effectiveness stems from its unique features that are not commonly available in other products. Still, it is not cheap, and I would...

See all answers

What needs improvement with Oracle GoldenGate?

There is room for improvement in Oracle GoldenGate's pricing, which is a bit high. Additionally, the configuration process could be made simpler. Although it serves well, these aspects could be imp...

See all answers

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...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

The solution comes free of cost.

See all answers

Comparisons

AWS Database Migration Service vs Oracle GoldenGate

Compared 16% of the time

Qlik Replicate vs Oracle GoldenGate

Compared 14% of the time

Quest SharePlex vs Oracle GoldenGate

Compared 8% of the time

Fivetran vs Oracle GoldenGate

Compared 8% of the time

JumpMind SymmetricDS vs Oracle GoldenGate

Compared 3% of the time

More Oracle GoldenGate Competitors

Informatica PowerCenter vs SSIS

Compared 21% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

Boomi iPaaS vs SSIS

Compared 2% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Oracle GoldenGate

February 2025

Download Oracle GoldenGate product report

Buyer's Guide

SSIS

January 2025

Download SSIS product report

Also Known As

GoldenGate

SQL Server Integration Services

Overview

Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds.

Oracle GoldenGate Features

Oracle GoldenGate has many valuable key features, including:

Simple to use web interface
Fast and easy installation or provisioning
Command line access via AdminClient that can run anywhere
RESTful APIs for DevOps
Offers built-in monitoring but also can be easily adapted to roll your own monitoring
APIs are protected by Cross Site Request Forgery (CSRF) authentication.

Oracle GoldenGate Benefits

Some of the benefits of using Oracle GoldenGate include:

Oracle GoldenGate is deeply integrated with the Oracle Database (logging, redo, backup and recovery layer, security, administration, data guard, data vault, autonomous database etc.).
It is the most stable, performant, and reliable CDC / replication solution for Oracle.
High performance: Oracle GoldenGate is capable of sub-second latency for data movement. featuring low impact capture, routing, transformation, and delivery of transactional data.
GoldenGate is the only CDC / replication tool that keeps pace with new and emerging innovations (security, features, data types, etc) in the core Oracle Database.
The solution supports a wide range of use cases, from conventional OLTP data replication and high availability to data lake ingestion or multi-cloud ingestion, SaaS application replication, and messaging replication.
GoldenGate is the only CDC / replication technology certified for Exadata, Exadata Cloud Service, and Exadata Cloud at Customer.
For fault-tolerance, GoldenGate has its own mechanism to keep track of how much work is completed and how much is pending. This mechanism is independent of any database and ensures, with the help of automatic gap-resolution, that no data loss occurs.
GoldenGate uses its own proprietary format files for keeping the committed data coming from the source database, making it independently functional irrespective of the database in use.
To maintain the performance and consistency, only committed data is sent. Uncommitted data is captured by GoldenGate, but is discarded after receiving a Rollback.
With GoldenGate, data sending is in “near real time,” which reduces the possibility of latency.

Reviews from Real Users

Below are some reviews and helpful feedback written by Oracle GoldenGate users.

PeerSpot user Steve-J., Cloud Migration Software Consultant - UK & EMEA at 1PLACE, says, "What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."

Pinak S., Senior Manager of System and Database at ESL, mentions, “We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema. The solution is quite stable. They've recently improved the ease of implementation.”

A Database Administrator at a manufacturing company explains, "It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."

An Oracle ERP DBA Consultant - Oracle Super Cluster T5-8 Admin at a government comments, "GoldenGate can connect and collect data from multiple sources, such as SQL Server."

Oracle

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Microsoft

Sample Customers

Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom

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

Buyer's Guide

Oracle GoldenGate vs. SSIS

February 2025

Free Report: Oracle GoldenGate vs. SSIS

Find out what your peers are saying about Oracle GoldenGate vs. SSIS and other solutions. Updated: February 2025.

DOWNLOAD NOW

838,640 professionals have used our research since 2012.

See our Oracle GoldenGate vs. SSIS report.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.