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 is intuitive and easy to use."
"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."
"Alteryx Designer is a tool that is pretty much easy to install."
"The features I found most valuable are the preparation features – the Join and the Transform."
"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 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."
"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"I like Alteryx Designer's drag-and-drop feature, where you drag a component, configure it and quickly run it."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"SSIS is easy to use."
"The interface is very user-friendly."
"The initial setup of this solution is very straightforward."
"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."
"When it comes to the pivoting part, the drill-through option is not there in Alteryx."
"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."
"If the price were reduced then it would be more competitive."
"The conditional join feature should be improved."
"Improving the key-based sign-on process and making it more user-friendly would be a benefit."
"Alteryx needs to improve its web governance. The gallery you use to filter the data is something else that could use some work. For instance, if you have a report connected to a database and want to filter a specific user, you should be able to suggest a specific region or a particular year. I know that the Alteryx isn't designed for data governance, but that would be great to think about."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"I would like to see more features in terms of the integration with Azure Data Factory."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Tuning using this solution requires extensive expertise to improve performance."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"The performance of SSIS could improve when comparing it to Oracle Database."
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.