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 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."
"I like Alteryx's browser tool because you can view how your data is handled live. There are many other valuable tools like transpose and the crosstab. You can quickly pivot your data, and there are connections throughout the database. It's so easy to create a connection. If you connect to sign apps or a more complex database, the tool contains all the tools you need."
"The product is intuitive and easy to use."
"The product offers very good analytics."
"Alteryx is quite easy to use, learn, and understand as a product."
"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."
"The solution is easy to integrate and user-friendly."
"The scalability of SSIS is good."
"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 initial setup of this solution is very straightforward."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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."
"It is easy to set up. The deployment is also very quick."
"If the price were reduced then it would be more competitive."
"When configuring the Logix, the UA could be improved."
"Alteryx Designer's pricing and support could be improved."
"Sometimes, while getting data from a third-party product, the solution works slowly."
"It is challenging to view the data using Alteryx Designer."
"Its cost can sometimes be a drawback."
"Alteryx Designer overall should be easier to use."
"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."
"The high prices attached to the product can be an area of concern where improvements are required."
"It would be nice if you could run SSIS on other environments besides Windows."
"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."
"I would like to see better integration with Power BI."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"The solution could improve by having quicker release updates."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"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."
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, 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.