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."
"The solution is easy to integrate and user-friendly."
"Workflow automation, in general, is valuable."
"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."
"Alteryx is quite easy to use, learn, and understand as a product."
"The product is very stable. The performance is reliable."
"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."
"It's already very user-friendly and has a good dashboard."
"The data reader is the most valuable feature."
"It's a competent product."
"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."
"It is easy to set up. The deployment is also very quick."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"We can connect with multiple data sources easily using an external connector in SSIS."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"Alteryx Designer overall should be easier to use."
"The only thing is sometimes it can be a bit slow."
"The product could offer more connectors and more databases with support for the in-database function."
"I would like to be able to include small snippets of code inside of the solution. The tool has only drag-and-drop features to make it easy to use, but sometimes I feel like this makes it more complicated."
"Improving the key-based sign-on process and making it more user-friendly would be a benefit."
"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."
"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."
"Alteryx Designer's pricing and support could be improved."
"Performance could be better."
"It needs more integration tools, so you can connect to different sources."
"This solution needs full support for real-time processing."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"The security could be improved, as it is more important in our context."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"I would like to see better technical documentation because many times information is missing."
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 SAP Data Services. 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.