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.2, while IBM is ranked #9 with an average rating of 8.4. Oracle holds a 4.3% mindshare in DI, compared to IBM’s 1.7% 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

7,797 Views
5,636 Comparison Views

96% willing to recommend

StreamSets

Read 24 StreamSets reviews

3,109 Views
1,983 Comparison Views

100% willing to recommend

Oracle GoldenGate

StreamSets

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Oracle GoldenGate and StreamSets based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

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

Buyer's Guide

Oracle GoldenGate vs. StreamSets

November 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

Oracle GoldenGate

Ranking in Data Integration

8th

Average Rating

8.2

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

No ranking in other categories

StreamSets

Ranking in Data Integration

9th

Average Rating

8.4

Reviews Sentiment

7.5

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Oracle GoldenGate is 4.3%, down from 4.7% compared to the previous year. The mindshare of StreamSets is 1.7%, 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

Reyansh Kumar

Technical Specialist at Accenture

We no longer need to hire highly skilled data engineers to create and monitor data pipelines

The things I like about StreamSets are its * overall user interface * efficiency * product features, which are all good. Also, the scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy. You just need to configure the data sources, the paths and their configurations, and you are ready to go. It is very efficient and very easy to use for ETL pipelines. It is a GUI-based interface in which you can easily create or design your own data pipelines with just a few clicks. As for moving data into modern analytics systems, we are using it with Microsoft Power BI, AWS, and some on-premises solutions, and it is very easy to get data from StreamSets into them. No hardcore coding or special technical expertise is required. It is also a no-code platform in which you can configure your data sources and data output for easy configuration of your data pipeline. This is a very important aspect because if a tool requires code development, we need to hire software developers to get the task done. By using StreamSets, it can be done with a few clicks.

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

"It is quite scalable."

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

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

"I am impressed with the tool's possibility of integrating different systems in a unified place."

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

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

"The replication of the data table is one of the best features."

"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

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

"The Ease of configuration for pipes is amazing. It has a lot of connectors. Mainly, we can do everything with the data in the pipe. I really like the graphical interface too"

"The scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy."

"The ETL capabilities are very useful for us. We extract and transform data from multiple data sources, into a single, consistent data store, and then we put it in our systems. We typically use it to connect our Apache Kafka with data lakes. That process is smooth and saves us a lot of time in our production systems."

"I really appreciate the numerous ready connectors available on both the source and target sides, the support for various media file formats, and the ease of configuring and managing pipelines centrally."

"The most valuable feature is the pipelines because they enable us to pull in and push out data from different sources and to manipulate and clean things up within them."

"The most valuable features are the option of integration with a variety of protocols, languages, and origins."

"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."

More StreamSets pros

Cons

"Some issues regarding stability need to be resolved."

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

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

"Lacks the ability to become a full-scale ETL tool."

"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 should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."

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

"What needs improvement in Oracle GoldenGate is the support. Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line. Simplifying how Oracle GoldenGate is used would also make the solution better."

More Oracle GoldenGate cons

"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."

"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."

"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."

"They need to improve their customer care services. Sometimes it has taken more than 48 hours to resolve an issue. That should be reduced. They are aware of small or generic issues, but not the more technical or deep issues. For those, they require some time, generally 48 to 72 hours to respond. That should be improved."

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

"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."

"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."

"Using ETL pipelines is a bit complicated and requires some technical aid."

More StreamSets cons

Pricing and Cost Advice

"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 have purchased corporate licensing to use Oracle GoldenGate."

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

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

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

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

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

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

More Oracle GoldenGate pricing and cost advice

"StreamSets is expensive, especially for small businesses."

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

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

"It's not expensive because you pay per month, and the tasks you can perform with it are huge. It's reliable and cost-effective."

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

"There are two editions, Professional and Enterprise, and there is a free trial. We're using the Professional edition and it is competitively priced."

"The overall cost is very flexible so it is not a burden for our organization... However, the cost should be improved. For small and mid-size organizations it might be a challenge."

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

816,406 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

17%

Computer Software Company

13%

Manufacturing Company

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

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

Fivetran vs Oracle GoldenGate

Compared 6% of the time

More Oracle GoldenGate Competitors

Informatica PowerCenter vs StreamSets

Compared 13% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 12% of the time

Fivetran vs StreamSets

Compared 10% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Confluent vs StreamSets

Compared 3% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Oracle GoldenGate

November 2024

Download Oracle GoldenGate product report

Buyer's Guide

StreamSets

October 2024

Download StreamSets product report

Also Known As

GoldenGate

No data available

Learn More

Oracle

Video not available

IBM

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

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.

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

November 2024

Free Report: Oracle GoldenGate vs. StreamSets

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

DOWNLOAD NOW

816,406 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.