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
5.5
Organizations saw improved cash flow, productivity, and efficiency, with ROI over 40%, through rapid automation integration with Workato.
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.7
Workato's responsive support is praised, though 24/7 availability and time zone alignment improvements are desired for complex issues.
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
6.3
Workato is scalable with cloud support but may face challenges with high data volumes and performance issues for some users.
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
7.1
Workato is highly stable, reliable on AWS, with some minor issues in HTTP requests and large data handling.
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 requires improvements in collaboration, UI, scalability, and flexibility, with enhanced data handling, support, and advanced 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's enterprise pricing includes a flat subscription, recipe-based model, with costs ranging from $120K-$130K annually, plus potential add-ons.
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 offers intuitive automation with low-code, drag-and-drop UI, enhancing efficiency and integration for seamless data management.
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 (23rd)
Workato
Average Rating
8.4
Reviews Sentiment
6.5
Number of Reviews
22
Ranking in other categories
Integration Platform as a Service (iPaaS) (7th)
 

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.6%, up 1.4% compared to last year.
Workato, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 4.8% mindshare, up 4.3% since last year.
Data Integration
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.
Rohit Sircar - PeerSpot reviewer
Great automation and strong workflows useful for integration
The initial setup is quite straightforward. When connecting Workato with your on-premises system, you have to install the Workato agent on your network. It was not complex but a long process to configure and settle. Workato has not gone live for us yet, so only the developers are currently using it. But in terms of users, we will have close to 250 and maybe 30 additional direct users. We are seeing a lot of different use cases where we can add new recipes because we started small, and there are many different areas where we can implement Workato for automation.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
861,803 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
11%
Computer Software Company
11%
Manufacturing Company
10%
Insurance Company
9%
Financial Services Firm
13%
Computer Software Company
11%
Manufacturing Company
10%
Educational Organization
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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 do you like most about Workato?
Workato is low code, intuitive, and easy to use.
What needs improvement with Workato?
I am currently in the exploratory phase. While the cloud-native aspect is beneficial, having deployment options similar to MuleSoft would be a great additional feature. Their approach aims to remov...
What is your primary use case for Workato?
I have been using Workato for the past two years now. Our current project was doing automation earlier with workflows using MuleSoft. These have now been moved to Workato for integrating systems fo...
 

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.
861,803 professionals have used our research since 2012.