Oracle GoldenGate vs StreamSets comparison

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

Oracle GoldenGate

Read 49 Oracle GoldenGate reviews

6,275 Views
4,463 Comparison Views

96% willing to recommend

StreamSets

Read 20 StreamSets reviews

2,525 Views
1,707 Comparison Views

100% willing to recommend

Oracle GoldenGate

StreamSets

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

Oracle GoldenGate and StreamSets are prominent in the data integration and replication software category. StreamSets appears to have the upper hand when it comes to ease of use and affordability, while Oracle GoldenGate excels in features and performance.

Features: Oracle GoldenGate offers real-time data replication, robust change data capture, and seamless integration with Oracle environments. It supports large dataset transformations quickly and integrates well with cloud platforms. StreamSets provides a user-friendly setup, eliminating the need for coding expertise. It features a wide range of connectors, effective data drift management, and supports both batch and streaming ETL tasks.

Room for Improvement: Oracle GoldenGate could enhance user-friendliness, simplify non-Oracle database integration, and reevaluate its pricing structure. It faces challenges with complex setups, DDL replication, and high licensing fees. StreamSets needs to improve its interface, memory management, and bolster security. Better monitoring, logging, and documentation would enhance usability across deployments.

Ease of Deployment and Customer Service: Oracle GoldenGate offers versatile deployment, including on-premises and hybrid cloud options, though its setup is complex. Customer service feedback is mixed, indicating inconsistent support and response times. StreamSets is praised for public and hybrid cloud deployment flexibility and effective customer service, addressing issues promptly. However, its pricing and support models need clarification for some users.

Pricing and ROI: Oracle GoldenGate's core-based pricing is viewed as expensive but offers substantial ROI for intensive projects, particularly in large environments by reducing downtime. StreamSets attracts smaller enterprises with free community versions and diverse pricing plans, although commercial versions can be costly. Both solutions provide significant ROI when aligned with enterprise goals, with GoldenGate noted for efficient downtime and cost reductions.

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

Buyer's Guide

Oracle GoldenGate vs. StreamSets

February 2025

Download the complete report

Helped 842,651 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

StreamSets

Ranking in Data Integration

15th

Average Rating

8.4

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of March 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 StreamSets is 1.6%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

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

Nantabo Jackie

Sales Manager at Soft Hostings Limited

Simplified pipelines and helped us break down data silos within our organization

The design experience when implementing batch streaming or ECL pipelines is very easy and straightforward. When we initially attempted to integrate StreamSets with Kafka, it was somewhat challenging until we consulted the documentation, after which it became straightforward. We use StreamSets to move data into modern analytics platforms. Moving the data into modern analytics platforms is still complex. It requires a lot of understanding of logic. StreamSets enables us to build data pipelines without knowing how to code. StreamSets' ability to build data pipelines without requiring us to know complex programming is very important, as it allows us to focus on our projects without spending time writing code. StreamSets' Transformer for Snowflake is simple to use for designing both simple and complex transformation logic. StreamSets' Transformer for Snowflake is extremely important to me as it helps me to connect external data sources and keep my internal workflow organized. Transformer for Snowflake's functionality is a perfect ten out of ten. It is important and cost-effective that Transformer for Snowflake is a serverless engine embedded within the platform, as without this feature, it would be very expensive. This feature helps us to sell at lower budget costs, which would otherwise be at a high cost with other servers. StreamSets has helped improve our organization. StreamSets simplified pipelines for our organization. It is easier to complete a project when we know where and how to start, and working with the team remotely makes it more efficient. This helps us to save time and be more organized when creating data pipelines. Being a structured company that produces reliable resources for our application benefits both our clients and contacts. StreamSets' built-in data drift resilience plays a part in our ETL operations. With prior knowledge, the built-in data drift resilience is very effective, but it can be challenging to implement without the preexisting knowledge. The built-in data drift resilience reduced the time it takes us to fix data drift breakages by 45 percent. StreamSets helped us break down data silos within our organization. The use of StreamSets to break down data silos enabled us to be confident in the services and products we provide, as well as the real-time streaming we offer. This has had a positive impact on our business, as it allowed us to accurately determine the analytics we need to present to stakeholders, clients, and our sources while ensuring that the process is secure and transparent. StreamSets saved us time because anyone can use StreamSets not just developers. We can save around 40 percent of our time. StreamSets' reusable assets helped us reduce workload by around 25 percent. StreamSets saved us money by not having to hire developers with specialized skills. We saved around $2,000 US. StreamSets helped us scale our data operations. Since StreamSets makes it easy to scale our data operations, it enabled us to know exactly where to start at any time. We are aware of the timeline for completing the project, and depending on our familiarity with the software, we can come up with a solution quickly.

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

"We use the tool to pull on-prem data."

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

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

"One feature that stands out for me is the data center capability."

"When we are replicating data between similar databases then it is straightforward."

"It is quite scalable."

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

"The CDC feature is interesting."

More Oracle GoldenGate pros

"The ability to have a good bifurcation rate and fewer mistakes is valuable."

"I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."

"It is really easy to set up and the interface is easy to use."

"One of the things I like is the data pipelines. They have a very good design. Implementing pipelines is very straightforward. It doesn't require any technical skill."

"StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes."

"The best feature that I really like is the integration."

"For me, the most valuable features in StreamSets have to be the Data Collector and Control Hub, but especially the Data Collector. That feature is very elegant and seamlessly works with numerous source systems."

"The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customize it to do what you need. Many other tools have started to use features similar to those introduced by StreamSets, like automated workflows that are easy to set up."

More StreamSets pros

Cons

"Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."

"The product is not easy to use."

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

"The solution, in general, should be easier to use, with less need to perform workarounds within the system."

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

"The solution needs to improve its latency, monitoring and support."

"The solution's licensing price is very expensive and could be made more competitive."

More Oracle GoldenGate cons

"We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back."

"Sometimes, it is not clear at first how to set up nodes. A site with an explanation of how each node works would be very helpful."

"We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which was painful. Also, pipeline failures were common, and data drifting wasn't addressed, which made things worse. Licensing was another issue we encountered."

"We've seen a couple of cases where it appears to have a memory leak or a similar problem."

"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."

"Visualization and monitoring need to be improved and refined."

"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."

"There aren't enough hands-on labs, and debugging is also an issue because it takes a lot of time. Logs are not that clear when you are debugging, and you can only select a single source for a pipeline."

More StreamSets cons

Pricing and Cost Advice

"We do like the price of this solution."

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

"The product is expensive."

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

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

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

"It is an expensive product."

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

More Oracle GoldenGate pricing and cost advice

"StreamSets is an expensive solution."

"We are running the community version right now, which can be used free of charge."

"There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."

"The pricing is too fixed. It should be based on how much data you need to process. Some businesses are not so big that they process a lot of data."

"We use the free version. It's great for a public, free release. Our stance is that the paid support model is too expensive to get into. They should honestly reevaluate that."

"I believe the pricing is not equitable."

"StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."

"The licensing is expensive, and there are other costs involved too. I know from using the software that you have to buy new features whenever there are new updates, which I don't really like. But initially, it was very good."

More StreamSets 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

842,651 professionals have used our research since 2012.

Comparison Review

it_user99375

Database Administrator at a tech services company with 51-200 employees

Mar 31, 2014

Oracle GoldenGate vs. Oracle Active Dataguard

As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

12%

Manufacturing Company

Government

Financial Services Firm

14%

Computer Software Company

11%

Manufacturing Company

10%

Insurance 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

What do you like most about StreamSets?

The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customiz...

See all answers

What needs improvement with StreamSets?

We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which ...

See all answers

What is your primary use case for StreamSets?

StreamSets is used for data transformation rather than ETL processes. It focuses on transforming data directly from sources without handling the extraction part of the process. The transformed data...

See all answers

Comparisons

AWS Database Migration Service vs Oracle GoldenGate

Compared 15% of the time

Qlik Replicate vs Oracle GoldenGate

Compared 14% of the time

Fivetran vs Oracle GoldenGate

Compared 9% of the time

Quest SharePlex vs Oracle GoldenGate

Compared 8% of the time

Azure Data Factory vs Oracle GoldenGate

Compared 5% of the time

More Oracle GoldenGate Competitors

Informatica PowerCenter vs StreamSets

Compared 14% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 12% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Azure Data Factory vs StreamSets

Compared 8% of the time

Confluent vs StreamSets

Compared 4% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Oracle GoldenGate

March 2025

Download Oracle GoldenGate product report

Buyer's Guide

StreamSets

March 2025

Download StreamSets product report

Also Known As

GoldenGate

No data available

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

StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.

IBM

Sample Customers

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

Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge

Buyer's Guide

Oracle GoldenGate vs. StreamSets

February 2025

Free Report: Oracle GoldenGate vs. StreamSets

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

DOWNLOAD NOW

842,651 professionals have used our research since 2012.

See our Oracle GoldenGate vs. StreamSets 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.