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

Alteryx Designer vs StreamSets comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Alteryx Designer
Ranking in Data Integration
11th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
30
Ranking in other categories
No ranking in other categories
StreamSets
Ranking in Data Integration
9th
Average Rating
8.4
Reviews Sentiment
7.5
Number of Reviews
24
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Alteryx Designer is 3.3%, down from 4.3% compared to the previous year. The mindshare of StreamSets is 1.7%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Ajay Nayak - PeerSpot reviewer
An easy-to-use automation solution with satisfying customer support
Sometimes, while getting data from a third-party product, like data sources that are not present in your system, Alteryx works a bit slowly. Even if you have a good configuration and you are pulling data from an SQL server like SAP, then the solution also has a slow work process. It shouldn't be that much slow if you are pulling ten thousand records, it should not take thirty minutes.
Reyansh Kumar - PeerSpot reviewer
We no longer need to hire highly skilled data engineers to create and monitor data pipelines
The things I like about StreamSets are its * overall user interface * efficiency * product features, which are all good. Also, the scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy. You just need to configure the data sources, the paths and their configurations, and you are ready to go. It is very efficient and very easy to use for ETL pipelines. It is a GUI-based interface in which you can easily create or design your own data pipelines with just a few clicks. As for moving data into modern analytics systems, we are using it with Microsoft Power BI, AWS, and some on-premises solutions, and it is very easy to get data from StreamSets into them. No hardcore coding or special technical expertise is required. It is also a no-code platform in which you can configure your data sources and data output for easy configuration of your data pipeline. This is a very important aspect because if a tool requires code development, we need to hire software developers to get the task done. By using StreamSets, it can be done with a few clicks.

Quotes from Members

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

Pros

"Alteryx Designer's best features are that it's easy to use and performs well."
"The product is intuitive and easy to use."
"When you open a raw Excel file, it can be hard to look at everything in detail. Alteryx makes it much easier to go through the data, summarize it, and use different tools for analysis."
"The solution is user-friendly."
"We use Alteryx Designer for analytics. It's quite helpful because once we set it up, we don't have to manually update or process data repeatedly. It saves time, especially for financial reporting, which is typically done monthly or quarterly. Once we set it up initially, we only need to make occasional updates if necessary."
"I have been using Alteryx Designer only for data modeling and data structuring."
"Alteryx Designer is easier to use for machine learning models. However, I am not very good at Python scripts which you will need to make the machine learning scripts."
"The most valuable features are the integrated properties and integrated connectivity."
"It is really easy to set up and the interface is easy to use."
"StreamSets Transformer is a good feature because it helps you when you are developing applications and when you don't want to write a lot of code. That is the best feature overall."
"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 most valuable features are the option of integration with a variety of protocols, languages, and origins."
"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."
"What I love the most is that StreamSets is very light. It's a containerized application. It's easy to use with Docker. If you are a large organization, it's very easy to use Kubernetes."
"For me, the most valuable features in StreamSets have to be the Data Collector and Control Hub, but especially the Data Collector. That feature is very elegant and seamlessly works with numerous source systems."
"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."
 

Cons

"I would like to be able to include small snippets of code inside of the solution. The tool has only drag-and-drop features to make it easy to use, but sometimes I feel like this makes it more complicated."
"An improvement for Alteryx Designer would be faster bug fixes and updates."
"Alteryx's data science and machine learning capabilities are where it loses out to DataIQ."
"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."
"Based on my experience, the tool could be improved by providing sample reports or pre-configured workflows tailored to specific industries, like finance. It needs to integrate an AI chatbot as well."
"It is challenging to view the data using Alteryx Designer."
"Sometimes, while getting data from a third-party product, the solution works slowly."
"The product could offer more connectors and more databases with support for the in-database function."
"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."
"Sometimes, it is not clear at first how to set up nodes. A site with an explanation of how each node works would be very helpful."
"They need to improve their customer care services. Sometimes it has taken more than 48 hours to resolve an issue. That should be reduced. They are aware of small or generic issues, but not the more technical or deep issues. For those, they require some time, generally 48 to 72 hours to respond. That should be improved."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"We've seen a couple of cases where it appears to have a memory leak or a similar problem."
"Visualization and monitoring need to be improved and refined."
"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."
"The design experience is the bane of our existence because their documentation is not the best. Even when they update their software, they don't publish the best information on how to update and change your pipeline configuration to make it conform to current best practices. We don't pay for the added support. We use the "freeware version." The user community, as well as the documentation they provide for the standard user, are difficult, at best."
 

Pricing and Cost Advice

"Alteryx is a little bit expensive compared to competing solutions."
"The solution is expensive. It has license fees, which are renewable every year."
"I rate the price of Alteryx Designer as a five on a scale of one to ten, where one is extremely expensive, and ten is a highly cheap product."
"Each license is something like $4,000."
"I rate the price of Alteryx Designer a ten on a scale of one to ten, where one is low price and ten is high price."
"I rate the product's pricing a two to three out of ten."
"The tool is priced high."
"The product is a bit expensive, it should be looked into."
"It's not so favorable for small companies."
"StreamSets is an expensive solution."
"It has a CPU core-based licensing, which works for us and is quite good."
"We are running the community version right now, which can be used free of charge."
"The pricing is affordable for any business."
"There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."
"It's not expensive because you pay per month, and the tasks you can perform with it are huge. It's reliable and cost-effective."
"The pricing is too fixed. It should be based on how much data you need to process. Some businesses are not so big that they process a lot of data."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
24%
Financial Services Firm
16%
Manufacturing Company
8%
Computer Software Company
6%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
8%
Insurance Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Alteryx Designer?
When you open a raw Excel file, it can be hard to look at everything in detail. Alteryx makes it much easier to go through the data, summarize it, and use different tools for analysis.
What is your experience regarding pricing and costs for Alteryx Designer?
The solution is expensive. It has license fees, which are renewable every year.
What needs improvement with Alteryx Designer?
Alteryx Designer is not as fast as SSIS and is not good for large datasets. It also needs to improve database procedures. Though it is easy to use, it is limited in terms of technical aspects.
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?
We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which ...
What is your primary use case for StreamSets?
StreamSets is used for data transformation rather than ETL processes. It focuses on transforming data directly from sources without handling the extraction part of the process. The transformed data...
 

Learn More

Video not available
 

Overview

Information not available
 

Sample Customers

Information Not Available
Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Find out what your peers are saying about Alteryx Designer vs. StreamSets and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.