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."It helps them to create customized workflows, transform data, perform calculations, and consolidate multiple data sources into a target database."
"The solution is user-friendly."
"Alteryx Designer is stable."
"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."
"The product is very stable. The performance is reliable."
"I have been using Alteryx Designer only for data modeling and data structuring."
"Alteryx is quite easy to use, learn, and understand as a product."
"Alteryx Designer's best features are that it's easy to use and performs well."
"It's a competent product."
"The UI is very user-friendly."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It's saved time using visualization descriptions."
"We need more documentation."
"Alteryx Designer's pricing and support could be improved."
"Improving the key-based sign-on process and making it more user-friendly would be a benefit."
"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."
"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."
"When configuring the Logix, the UA could be improved."
"Sometimes, while getting data from a third-party product, the solution works slowly."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Performance could be better."
"We'd like more integration capabilities."
"I would like to see better technical documentation because many times information is missing."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Improvement as per customer requirements."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
Alteryx Designer is ranked 9th in Data Integration with 27 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, Palantir Foundry and SAP Data Services, 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.