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 solution is user-friendly."
"The product is intuitive and easy to use."
"The product offers very good analytics."
"One of the things I like about Alteryx Designer is how easy it is to connect numerous data inputs, including API connectors. This helps tremendously in reducing the time required to extract data from systems like SAP that don't have straightforward connectivity options."
"The most valuable feature of Alteryx Designer is its ability to select all the inputs and formulas."
"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"Alteryx is quite easy to use, learn, and understand as a product."
"It helps them to create customized workflows, transform data, perform calculations, and consolidate multiple data sources into a target database."
"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 most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"It is easy to set up the product."
"The initial setup was easy."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It's a competent product."
"It is easy to set up the solution."
"Overall, it's a good product."
"If the price were reduced then it would be more competitive."
"Alteryx's data science and machine learning capabilities are where it loses out to DataIQ."
"An improvement for Alteryx Designer would be faster bug fixes and updates."
"The only thing is sometimes it can be a bit slow."
"Alteryx Designer overall should be easier to use."
"It is challenging to view the data using Alteryx 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."
"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."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The high prices attached to the product can be an area of concern where improvements are required."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Tuning using this solution requires extensive expertise to improve performance."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
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.