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
3.9
Workato boosts productivity and cost savings with automation, faster setups, and improved operations, achieving 40% ROI within a week.
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
5.9
Workato's customer service is praised for responsiveness and effectiveness, though some note time zone limitations in assistance.
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.0
Workato is scalable and elastic but may face challenges with high data volumes and specific configuration needs.
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.7
Workato is stable and efficient for daily tasks, though issues may occur with large data volumes and CSV limits.
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 needs enhancements in collaboration, API management, UI improvements, data handling, customization, and AI integration for better efficiency.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
The team is actively working on customizing the platform per client requirements and is rapidly releasing features to address these limitations.
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.
 

Setup Cost

StreamSets provides flexible pricing models, with varied user satisfaction, favoring larger enterprises over smaller companies due to cost.
Workato offers competitive, flexible pricing from $50K-$130K annually, suitable for scalable integrations with no hidden costs.
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 simplifies integration with pre-built connectors and a user-friendly interface, empowering non-technical users with low-code solutions.
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.2
Reviews Sentiment
5.9
Number of Reviews
28
Ranking in other categories
Integration Platform as a Service (iPaaS) (5th)
 

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.5%, down 1.6% compared to last year.
Workato, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 5.3% mindshare, up 4.0% since last year.
Data Integration Market Share Distribution
ProductMarket Share (%)
StreamSets1.5%
Informatica PowerCenter6.0%
SSIS5.7%
Other86.8%
Data Integration
Integration Platform as a Service (iPaaS) Market Share Distribution
ProductMarket Share (%)
Workato5.3%
Boomi iPaaS12.5%
Microsoft Azure Logic Apps12.4%
Other69.8%
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.
871,829 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
10%
Financial Services Firm
9%
Insurance Company
9%
Manufacturing Company
7%
Computer Software Company
14%
Financial Services Firm
10%
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?
In Workato, there are some limitations regarding very high transactional data in file formats. For instance, we have a 90-minute job timeout, and queues larger than 10,000 size will be purged. Addi...
What is your primary use case for Workato?
The usual use cases for Workato include real-time data processing from either SFTP or SAS, and we have implemented multiple use cases for our clients in the past 3.5 years. For example, the employe...
What advice do you have for others considering Workato?
I have been working with clients for Workato implementation, focusing on consulting and implementing solutions for their business needs. We automate basic workflows and handle various complexities ...
 

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