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.2, while Microsoft is ranked #4 with an average rating of 7.7. Oracle holds a 4.2% mindshare in DI, compared to Microsoft’s 8.8% 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

7,354 Views
5,312 Comparison Views

96% willing to recommend

SSIS

Read 72 SSIS reviews

14,200 Views
11,375 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: November 2024).

Buyer's Guide

Oracle GoldenGate vs. SSIS

November 2024

Download the complete report

Helped 824,053 peers since 2012

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 December 2024, in the Data Integration category, the mindshare of Oracle GoldenGate is 4.2%, down from 4.5% compared to the previous year. The mindshare of SSIS is 8.8%, 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

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Its ability to transform and transport data is extremely valuable

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

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 replication of the data table is one of the best features."

"We can replicate data across different data centers and different technologies."

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

"Data migration is the most valuable feature of Oracle GoldenGate."

"It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers."

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

"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."

"Oracle GoldenGate helps to select and target specific tables for replication. Any changes or operations on those tables are immediately reflected in the source and target environments."

More Oracle GoldenGate pros

"The initial setup of this solution is very straightforward."

"The solution is stable."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"It's saved time using visualization descriptions."

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."

"The solution is easy to use and developer friendly."

"It is easy to set up the product."

"It's already very user-friendly and has a good dashboard."

More SSIS pros

Cons

"Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration."

"Oracle GoldenGate could improve the price."

"The GoldenGate license is very costly."

"The product lacks some features and it's expensive."

"Microservices Architecture is not user-friendly."

"IBM CDC has one central control while Oracle GoldenGate has two controls. In IBM CDC we can do all things in frontend. The solution needs to incorporate a feature where we can connect it to a standby database."

"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."

"Monitoring must be a bit more enhanced."

More Oracle GoldenGate cons

"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."

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

"I would like to see better integration with Power BI."

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

"The performance of this solution is not as good as other tools in the market."

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

"At one point, we did have to purchase an add-on."

"It's a legacy tool, that is nearing the end of its useful life."

More SSIS cons

Pricing and Cost Advice

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

"In addition to the licensing fee, customers are also required to pay an additional 24 percent for the support."

"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 tool is a bit expensive."

"Licensing for Oracle GoldenGate is paid yearly."

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

"The one feature that I think Oracle could perhaps consider is, at the moment, the Veridata option is an extra cost. Golden Gate is an expensive product. You pay a lot for the best. But not including the Veridata license to prove that everything is working correctly... The big improvement for me would be to have that license built in. That would take it to the next level. That would make it a much better product. You may want to look at buying term licenses if you've just got a single migration to do. In that situation, you might want a term license for perhaps a year to save a lot of money, rather than buying a perpetual license."

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

More Oracle GoldenGate pricing and cost advice

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

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

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

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"Our license with SSIS is annual."

"People have to opt for a perpetual-based licensing model."

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

"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

824,053 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 product is expensive. Due to the high cost, we are considering alternative solutions.

See all answers

What needs improvement with Oracle GoldenGate?

The solution sometimes has issues with long transactions and replication delays. Its pricing needs improvement.

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 18% of the time

Qlik Replicate vs Oracle GoldenGate

Compared 13% of the time

Quest SharePlex vs Oracle GoldenGate

Compared 7% of the time

Azure Data Factory 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 23% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Ab Initio Co>Operating System vs SSIS

Compared 2% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Oracle GoldenGate

December 2024

Download Oracle GoldenGate product report

Buyer's Guide

SSIS

November 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

November 2024

Free Report: Oracle GoldenGate vs. SSIS

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

DOWNLOAD NOW

824,053 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.