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 7.7. Oracle holds a 4.3% mindshare in DI, compared to Microsoft’s 8.9% 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 50 Oracle GoldenGate reviews

6,965 Views
5,016 Comparison Views

96% willing to recommend

SSIS

Read 72 SSIS reviews

13,383 Views
10,644 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: January 2025).

Buyer's Guide

Oracle GoldenGate vs. SSIS

January 2025

Download the complete report

Helped 831,158 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 January 2025, in the Data Integration category, the mindshare of Oracle GoldenGate is 4.3%, down from 4.6% compared to the previous year. The mindshare of SSIS is 8.9%, down from 9.5% 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

"I like that the product transforms data and provides real-time applications."

"GoldenGate can connect and collect data from multiple sources, such as SQL Server."

"GoldenGate enables us to merge and transform data from various sources in real time. It's a powerful tool that can read and load most data sources."

"The most valuable feature of Oracle GoldenGate is its ability to sync data in real-time, which is crucial for me."

"For small databases, GoldenGate handles the migration well."

"You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time."

"The most valuable feature is data replication capability."

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

More Oracle GoldenGate pros

"SSIS integrates well with SQL servers and Microsoft products."

"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."

"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

"SSIS' best feature is SFTP connectivity."

"It's saved time using visualization descriptions."

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

"The technical support is very good."

More SSIS pros

Cons

"Troubleshooting issues is not always the easiest. It should be easier to troubleshoot. Their support can also be improved. They don't read your problem statement and waste a lot of time. GoldenGate for big data is actually a separate license. It is sort of a separate product, but it might fall underneath your GoldenGate category. If we're talking about big data, its interaction with big data sources is poorly documented."

"Oracle GoldenGate could improve the price."

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

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

"Monitoring must be a bit more enhanced."

"The solution's performance needs improvement."

"GoldenGate is expensive. It's costly because this solution is unique in our market. The GoldenGate Cloud Service is cheaper than the on-premise solution."

"It is not a very stable tool, and you need to monitor it perfectly."

More Oracle GoldenGate cons

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."

"Improving the login procedure would make our reporting easier on monitoring our ETL processes."

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

"Improvement as per customer requirements."

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"There were some issues when we tried to connect it to data storage. It was a connection issue."

More SSIS cons

Pricing and Cost Advice

"We pay a yearly licensing fee for Oracle GoldenGate, which is very expensive."

"The tool is a bit expensive."

"Pricing is based on anual licensing with additional costs for support packages."

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

"It is an expensive product."

"The price of this solution is good."

"The licensing model should be improved to be more cost-effective for the end users."

"We have an enterprise license for it. It might be for three years or so. I'm not aware of any additional costs to the standard licensing fee."

More Oracle GoldenGate pricing and cost advice

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

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

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

831,158 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 17% of the time

Qlik Replicate vs Oracle GoldenGate

Compared 13% of the time

Quest SharePlex vs Oracle GoldenGate

Compared 8% of the time

Fivetran vs Oracle GoldenGate

Compared 7% of the time

Confluent vs Oracle GoldenGate

Compared 3% of the time

More Oracle GoldenGate Competitors

Informatica PowerCenter vs SSIS

Compared 22% of the time

Talend Open Studio vs SSIS

Compared 12% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

SAP Data Services vs SSIS

Compared 2% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Oracle GoldenGate

January 2025

Download Oracle GoldenGate product report

Buyer's Guide

SSIS

December 2024

Download SSIS product report

Also Known As

GoldenGate

SQL Server Integration Services

Learn More

Oracle

Microsoft

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

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.

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

January 2025

Free Report: Oracle GoldenGate vs. SSIS

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

DOWNLOAD NOW

831,158 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.