We performed a comparison between Alteryx Designer and StreamSets based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"The most valuable features are the integrated properties and integrated connectivity."
"I like Alteryx Designer's drag-and-drop feature, where you drag a component, configure it and quickly run it."
"Alteryx Designer offers a drag-and-drop interface, making it highly user-friendly. Unlike Python and Apache Airflow, which require coding, Alteryx allows users to accomplish tasks without any programming knowledge. Its simplicity makes it accessible to anyone, even those without coding experience, and this ease of use is one of Alteryx's key advantages."
"I like Alteryx's browser tool because you can view how your data is handled live. There are many other valuable tools like transpose and the crosstab. You can quickly pivot your data, and there are connections throughout the database. It's so easy to create a connection. If you connect to sign apps or a more complex database, the tool contains all the tools you need."
"Alteryx Designer is stable."
"The solution is user-friendly."
"I believe in the ability to connect to multiple data sources, as well as the ease of use to transform data and output data in a variety of formats."
"In StreamSets, everything is in one place."
"StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes."
"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."
"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."
"The ETL capabilities are very useful for us. We extract and transform data from multiple data sources, into a single, consistent data store, and then we put it in our systems. We typically use it to connect our Apache Kafka with data lakes. That process is smooth and saves us a lot of time in our production systems."
"It is really easy to set up and the interface is easy to use."
"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."
"The Ease of configuration for pipes is amazing. It has a lot of connectors. Mainly, we can do everything with the data in the pipe. I really like the graphical interface too"
"Its cost can sometimes be a drawback."
"We need more documentation."
"Sometimes, while getting data from a third-party product, the solution works slowly."
"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."
"The major concern in Alteryx Designer stems from the high costs attached to the product."
"Its price can be improved. It is too expensive for our country. Because of its high price, we can't sell Alteryx Designer in this region. We used to be their reseller partner. There is also an additional cost for automating the data and running the flows, which makes it even more expensive. It will be very good if they can let users automate the data for free. Other solutions like Tableau provide this feature for free."
"Alteryx Designer's cost should be improved."
"When it comes to the pivoting part, the drill-through option is not there in Alteryx."
"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."
"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."
"Visualization and monitoring need to be improved and refined."
"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."
"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."
"Sometimes, when we have large amounts of data that is very efficiently stored in Hadoop or Kafka, it is not very efficient to run it through StreamSets, due to the lack of efficiency or the resources that StreamSets is using."
"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."
"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."
Alteryx Designer is ranked 9th in Data Integration with 28 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. Alteryx Designer is rated 8.0, while StreamSets is rated 8.4. The top reviewer of Alteryx Designer writes "An easy-to-use automation solution with satisfying customer support". On the other hand, the top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". Alteryx Designer is most compared with Azure Data Factory, FME, SSIS, Informatica PowerCenter and SAP Data Services, whereas StreamSets is most compared with Fivetran, Informatica PowerCenter, Azure Data Factory, SSIS and IBM InfoSphere DataStage. See our Alteryx Designer vs. StreamSets report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.