Try our new research platform with insights from 80,000+ expert users

StreamSets vs Workato comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
8.1
StreamSets speeds up data processing, boosts efficiency and revenue, simplifies tasks, enhances security, and reduces costs significantly.
Sentiment score
4.5
Workato improved integration and efficiency, leading to cost savings and allowing focus on growth and product development.
By replacing multiple legacy systems and teams with a single automated platform, organizations see significant cost savings and improved business operations.
For main recipes, there are charges, so by focusing on creating as many callable recipes as possible based on requirements, we can improve cost efficiency for the business.
In my experience, we have seen a return on investment, with results visible within a week.
 

Customer Service

Sentiment score
6.7
StreamSets support is responsive and knowledgeable, offering effective solutions, though response times and technical handling could improve.
Sentiment score
6.1
Workato's customer service is praised for responsiveness, though some report 24/7 availability issues and technical limitations.
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
Whenever we faced issues with data volume, the support team helped us by suggesting solutions like breaking the data into chunks.
I reach out to the professional services team or customer success team for technical support, and they provide immediate responses.
Workato's support is robust, featuring first and second-level support.
 

Scalability Issues

Sentiment score
7.6
StreamSets is scalable and flexible, favored for cloud use but could improve auto-scaling for large data migrations.
Sentiment score
5.9
Workato is scalable, handling diverse tasks well, but faces challenges with data spikes and complex scaling in high workloads.
There are scalability limitations with Workato.
Allows dynamic connection switching at runtime.
Even when clients overutilize the product, Workato allows them to continue without interruption, charging accordingly rather than limiting usage.
 

Stability Issues

Sentiment score
7.8
StreamSets is praised for stability and reliability, despite minor memory issues, with high user ratings and market competitiveness.
Sentiment score
6.5
Workato is stable daily, but stability varies under high load, with occasional connector issues and data file limitations.
Once deployed, solutions do not break, making it more reliable than other solutions like Microsoft Power Automate that often disconnect.
During the initial data loads with large volumes, Workato was unable to handle the data effectively, which indicates stability issues under high loads.
To handle more than 50,000 records, I use scripting actions like Python or JavaScript to process large data in chunks.
 

Room For Improvement

StreamSets struggles with integration, real-time processing, clarity in UI, memory issues, security, documentation, and cloud storage performance.
Workato must improve in scalability, flexibility, global reach, integration, and AI, while enhancing collaboration and customization features.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
Workato struggles with scalability when handling high volumes of data, such as terabytes, requiring chunking for initial data loads.
One area for improvement is the CI/CD pipeline, which lacks a version control system similar to GitHub for easier deployment.
Currently, there's no way to set breakpoints to stop the process and debug an error as you can in other tools like webMethods.
 

Setup Cost

StreamSets provides flexible pricing models, with varied user satisfaction, favoring larger enterprises over smaller companies due to cost.
Workato offers competitive and flexible pricing, appealing to small to medium enterprises, with costs varying by usage and features.
Higher volume is less expensive, but in general, it is kind of pricey.
While the upfront cost is high due to task-based pricing, the cost is relatively low in terms of development because Workato provides necessary connectors for integration use cases.
Compared to other iPaaS solutions like Boomi, Workato’s pricing model charges per connection step, which increases the cost.
 

Valuable Features

StreamSets offers intuitive interface, extensive connectors, and features accessible to non-technical users for seamless data integration and manipulation.
Workato excels in ease of use, rapid integration, low-code automation, and efficiency, offering quick onboarding and robust documentation.
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
It allows app-to-app and real-time integrations, which significantly enhance process efficiency.
It comes with pre-built connectors, eliminating the need to write APIs.
The platform's ease of use for connecting to different integrations, like Salesforce and NetSuite, is very beneficial because development isn't necessary, and everything is readily available.
 

Categories and Ranking

StreamSets
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
21
Ranking in other categories
Data Integration (22nd)
Workato
Average Rating
8.4
Reviews Sentiment
6.2
Number of Reviews
26
Ranking in other categories
Integration Platform as a Service (iPaaS) (6th)
 

Mindshare comparison

StreamSets and Workato aren’t in the same category and serve different purposes. StreamSets is designed for Data Integration and holds a mindshare of 1.4%, down 1.5% compared to last year.
Workato, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 4.9% mindshare, up 4.2% since last year.
Data Integration Market Share Distribution
ProductMarket Share (%)
StreamSets1.4%
Informatica PowerCenter6.3%
SSIS5.9%
Other86.4%
Data Integration
Integration Platform as a Service (iPaaS) Market Share Distribution
ProductMarket Share (%)
Workato4.9%
Microsoft Azure Logic Apps13.1%
Boomi iPaaS12.4%
Other69.6%
Integration Platform as a Service (iPaaS)
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
Useful for data transformation and helps with column encryption
We use various tools and alerting systems to notify us of pipeline errors or failures. StreamSets supports data governance and compliance by allowing us to encrypt incoming data based on specified rules. We can easily encrypt columns by providing the column name and hash key. If you're considering using StreamSets for the first time, I would advise first understanding why you want to use it and how it will benefit you. If you're dealing with change tracking or handling large amounts of data, it could be cost-effective compared to services like Amazon. It's easy to schedule and manage tasks with the tool, and you can enhance your skills as an ETL developer. You can easily migrate traditional pipelines built on platforms like Informatica or Talend to StreamSets. I rate the overall solution an eight out of ten.
Isaac Viana - PeerSpot reviewer
Integration support simplifies automation and reduces errors without existing frustrations
In Workato, I can see everything that goes behind the process. You can see how everything works, how the tool works in the background. If something goes bad and an error appears, I can see why it happened. The best features Workato offers, in my opinion, are the easy integration with many different types of tools. The Workato interface is so easy to use. Workato has impacted my organization positively by reducing errors, which is one of the most important improvements I can see, and one great thing is that in Workato I can do many things that the main BPA platform we use does not do. Error reduction has helped our team in Workato as we can see more details about the most common errors and what makes everything go bad. With this specific data, we can develop a new and better solution. Workato helped us to do this. We can see more details about the errors and solve them. Workato has improved a lot of my work because there I can develop many flows easier and faster. At this moment, I do not have anything that frustrates me.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
867,497 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
11%
Financial Services Firm
9%
Manufacturing Company
9%
Insurance Company
9%
Computer Software Company
14%
Financial Services Firm
11%
Manufacturing Company
9%
Retailer
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise2
Large Enterprise11
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise6
Large Enterprise7
 

Questions from the Community

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...
What needs improvement with StreamSets?
One issue I observed with StreamSets is that the memory runs out quickly when processing large volumes of data. Because of this memory issue, we have to upgrade our EC2 boxes in the Amazon AWS infr...
What is your primary use case for StreamSets?
We are using StreamSets for batch loading.
What needs improvement with Workato?
While there are still a few areas where Workato has room for improvement, they’re making impressive strides in advancing their AI capabilities and enhancing their RPA features. Their recent confere...
What is your primary use case for Workato?
We use Workato for our G&A across finance, accounting, procurement, audit and compliance, HR, GTM which covers sales, marketing, customer success, as well as IT. Wherever we need process automa...
What advice do you have for others considering Workato?
I have experience in the automation space for more than 18 years, and I have worked on multiple integration platforms including JCAPS, Oracle SOA Suite, Oracle Service Bus, BPM, MuleSoft, Boomi, an...
 

Comparisons

 

Overview

 

Sample Customers

Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Panera Bread, Berkshire Hathaway, Salesforce, Box, Splunk, ComScore, IBM, Complex Media, Microsoft, Home Depot, Cisco, News Corp, Braille Institute
Find out what your peers are saying about StreamSets vs. Workato and other solutions. Updated: July 2023.
867,497 professionals have used our research since 2012.