We performed a comparison between Alteryx Designer and SSIS 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."One of the things I like about Alteryx Designer is how easy it is to connect numerous data inputs, including API connectors. This helps tremendously in reducing the time required to extract data from systems like SAP that don't have straightforward connectivity options."
"Alteryx is quite easy to use, learn, and understand as a product."
"I like Alteryx Designer's drag-and-drop feature, where you drag a component, configure it and quickly run it."
"Alteryx Designer's best features are that it's easy to use and performs well."
"The functionality of drag and drop is the most valuable. It is a very user-friendly tool that can be understood easily. My teams also work with other solutions, such as Integration Services, and these solutions are very difficult for people who don't have technical knowledge."
"The features I found most valuable are the preparation features – the Join and the Transform."
"The solution is easy to integrate and user-friendly."
"I have been using Alteryx Designer only for data modeling and data structuring."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The initial setup of this solution is very straightforward."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The data reader is the most valuable feature."
"The solution is stable."
"It's already very user-friendly and has a good dashboard."
"The price of the product is an area with certain shortcomings where improvements are required."
"An improvement for Alteryx Designer would be faster bug fixes and updates."
"Improving the key-based sign-on process and making it more user-friendly would be a benefit."
"Alteryx Designer's cost should be improved."
"The conditional join feature should be improved."
"Optimizing processing times is one area I would like to see improved in Alteryx Designer. Sometimes, the workflows take an extremely long time to run. There are days when I have had to wait two to three hours for a single process to complete. There needs to be a functionality to split the processes."
"We need more documentation."
"It is challenging to view the data using Alteryx Designer."
"The creation of the measure in the DAC's model could be improved."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The solution could improve on integrating with other types of data sources."
"The solution could improve by having quicker release updates."
"It would be nice if you could run SSIS on other environments besides Windows."
Alteryx Designer is ranked 9th in Data Integration with 28 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Alteryx Designer is rated 8.0, while SSIS is rated 7.6. 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 SSIS writes "Maintaining the solution and contacting its support team is easy". Alteryx Designer is most compared with Azure Data Factory, FME, Informatica PowerCenter, SAP Data Services and Palantir Foundry, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Matillion ETL. See our Alteryx Designer vs. SSIS 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.