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."The solution's existing SaaS platform for data integration gives us an edge."
"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."
"The product's microservice architecture is scalable."
"You can use Oracle GoldenGate as a DR for your system."
"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."
"I am impressed with the tool's possibility of integrating different systems in a unified place."
"GoldenGate can connect and collect data from multiple sources, such as SQL Server."
"This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
"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."
"It is really easy to set up and the interface is easy to use."
"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved."
"The UI is user-friendly, it doesn't require any technical know-how and we can navigate to social media or use it more easily."
"It's very easy to integrate. It integrates with Snowflake, AWS, Google Cloud, and Azure. It's very helpful for DevOps, DataOps, and data engineering because it provides a comprehensive solution, and it's not complicated."
"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 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"
"Also, the intuitive canvas for designing all the streams in the pipeline, along with the simplicity of the entire product are very big pluses for me. The software is very simple and straightforward. That is something that is needed right now."
"The solution costs a lot."
"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."
"We struggle with memory. It's limited. However, it may be because of our unique business case and how we use it that it's limiting for us."
"I find the user interface to be difficult for non-technical people."
"It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
"I would like to see the interface more graphical and easier to use."
"Lacks the ability to become a full-scale ETL tool."
"Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."
"Sometimes, when we have large amounts of data that is very efficiently stored in Hadoop or Kafka, it is not very efficient to run it through StreamSets, due to the lack of efficiency or the resources that StreamSets is using."
"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."
"We've seen a couple of cases where it appears to have a memory leak or a similar problem."
"Using ETL pipelines is a bit complicated and requires some technical aid."
"I would like to see it integrate with other kinds of platforms, other than Java. We're going to have a lot of applications using .NET and other languages or frameworks. StreamSets is very helpful for the old Java platform but it's hard to integrate with the other platforms and frameworks."
"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."
"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."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
Oracle GoldenGate is ranked 6th in Data Integration with 47 reviews while StreamSets is ranked 8th in Data Integration with 23 reviews. Oracle GoldenGate is rated 8.2, while StreamSets is rated 8.4. The top reviewer of Oracle GoldenGate writes "Performs real-time replication without data loss, but we cannot do much automation". On the other hand, the top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". Oracle GoldenGate is most compared with AWS Database Migration Service, Qlik Replicate, Quest SharePlex and Azure Data Factory, whereas StreamSets is most compared with Fivetran, Azure Data Factory, Informatica PowerCenter, SSIS and Talend Open Studio. 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.