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."Alteryx Designer's user interface is great, as it is very user-friendly."
"Alteryx Designer is a tool that is pretty much easy to install."
"The product is intuitive and easy to use."
"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."
"The solution is easy to integrate and user-friendly."
"When you open a raw Excel file, it can be hard to look at everything in detail. Alteryx makes it much easier to go through the data, summarize it, and use different tools for analysis."
"Alteryx is quite easy to use, learn, and understand as a product."
"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."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"It's saved time using visualization descriptions."
"The interface is very user-friendly."
"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."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The scalability of SSIS is good."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It is easy to set up. The deployment is also very quick."
"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."
"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."
"Alteryx Designer's cost should be improved."
"Alteryx Designer's pricing and support could be improved."
"The conditional join feature should be improved."
"The price of the product is an area with certain shortcomings where improvements are required."
"It is challenging to view the data using Alteryx Designer."
"The major concern in Alteryx Designer stems from the high costs attached to the product."
"We have issues with SSIS connectors while extracting data from Excel sources."
"It's a legacy tool, that is nearing the end of its useful life."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"The creation of the measure in the DAC's model could be improved."
"It needs more integration tools, so you can connect to different sources."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
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.