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

StreamSets vs Zapier 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
6.5
Users experience benefits from Zapier's automation and cost savings, though calculating specific ROI can be challenging.
In a scenario where employing three resources for three months might cost approximately $18,000 to $20,000, Zapier provides substantial cost savings.
 

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
7.2
Mixed experiences with Zapier support: praised for responsiveness and knowledge, yet some note delays and lack of chat.
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
Their technical support is good; they respond promptly and are very helpful.
This can help if you need assistance, as you can communicate with the community and support system, and most issues are already resolved by AI.
Sometimes, in my early days, when I was stuck with something, they helped me solve these issues, and even helped me solve some of my automations.
 

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
7.6
Zapier is ideal for small businesses prioritizing simple tasks, though costs and stability may concern larger organizations.
Zapier is suitable for small or simpler automation but not for complex ones.
Scaling it gets quite expensive, and while I cannot evaluate it purely from a technology perspective, compared to Workato, I would give Zapier a seven for scalability.
 

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.9
Users find Zapier reliable, with minor issues often linked to third-party tools, and rate stability highly for varied needs.
In my current company, we had significant challenges with Zapier regarding maintenance, as Zaps were often broken, not necessarily due to Zapier, but due to changes in the input variables.
 

Room For Improvement

StreamSets struggles with integration, real-time processing, clarity in UI, memory issues, security, documentation, and cloud storage performance.
Zapier users face issues with Google Sheets, insufficient integrations, complex workflows, high costs, and limited customization and support.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
The error message options in the dashboard should be improved. It should be user-friendly so that beginners or non-technical users can figure out the problems and solutions on their own.
You can build similar or dependent automations in one Zap, which helps with understanding the process without switching between different records.
I would appreciate if there would be a feature where we can use actions right after loops. Currently, you cannot use any other action after the loop. Everything needs to be within the loop.
 

Setup Cost

StreamSets provides flexible pricing models, with varied user satisfaction, favoring larger enterprises over smaller companies due to cost.
Enterprise buyers find Zapier cost-effective for its integrations, despite some viewing it as pricier than alternatives.
The pricing is in accordance with market standards and even lower in some cases.
The pricing of Zapier is slightly higher compared to other market automation tools such as Pabbly, Make.com, and N8N, which have good features but are priced lower than Zapier.
 

Valuable Features

StreamSets offers intuitive interface, extensive connectors, and features accessible to non-technical users for seamless data integration and manipulation.
Zapier offers over 20,000 integrations, automating workflows without coding, enhancing productivity with user-friendly, drag-and-drop functionality.
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
They have approximately 7,000 connections.
Even a person with no technical knowledge can use Zapier to create automations.
The automation capabilities are impressive.
 

Categories and Ranking

StreamSets
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
21
Ranking in other categories
Data Integration (23rd)
Zapier
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
49
Ranking in other categories
Cloud Data Integration (10th)
 

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.
Sachin Shrtivastava - PeerSpot reviewer
Automation of simple tasks improves with user-friendly interface but needs enhancement in handling complex scenarios
In my opinion, what could be improved in Zapier is its UI, which operates as a one-line system. Compared to Make.com and other tools that have a drag-and-drop system, this is lacking. If the scenario or automation is complex, it becomes difficult to create and deploy because of various routes. For example, with 20 routes, it becomes really difficult to create them due to certain limits, and the UI is not conducive for viewing all the routes.
report
Use our free recommendation engine to learn which Cloud 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%
Computer Software Company
12%
Financial Services Firm
11%
University
8%
Educational Organization
7%
 

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 Zapier?
The product's most valuable feature is automation.
What is your experience regarding pricing and costs for Zapier?
The pricing is in accordance with market standards and even lower in some cases. The license setup cost is reasonable.
What needs improvement with Zapier?
In my opinion, what could be improved in Zapier is its UI, which operates as a one-line system. Compared to Make.com and other tools that have a drag-and-drop system, this is lacking. If the scenar...
 

Comparisons

 

Overview

 

Sample Customers

Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
BuzzFeed, Groupon, Spotify, Columbia University, FOX
Find out what your peers are saying about StreamSets vs. Zapier and other solutions. Updated: July 2025.
861,803 professionals have used our research since 2012.