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."The product offers very good analytics."
"Alteryx Designer is a tool that is pretty much easy to install."
"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."
"Workflow automation, in general, is valuable."
"Alteryx is quite easy to use, learn, and understand as a product."
"The features I found most valuable are the preparation features – the Join and the Transform."
"It has an easy setup process."
"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."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The UI is very user-friendly."
"SSIS is easy to use."
"SSIS integrates well with SQL servers and Microsoft products."
"SSIS' best feature is SFTP connectivity."
"If the price were reduced then it would be more competitive."
"When it comes to the pivoting part, the drill-through option is not there in Alteryx."
"The actual usage part of it needs to be explained more. It's too vague right now."
"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."
"It would be simpler if they provided a component where you could simply enter some parameters and see the results."
"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."
"Alteryx Designer's cost should be improved."
"The price of the product is an area with certain shortcomings where improvements are required."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"We have issues with SSIS connectors while extracting data from Excel sources."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Performance could be better."
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.
