We performed a comparison between Alteryx Designer and Azure Data Factory based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Alteryx Designer ultimately wins out in this comparison. According to its reviewers, it is a very powerful solution. Azure Data Factory does come out on top in the pricing category, however.
"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."
"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"Alteryx Designer is a tool that is pretty much easy to install."
"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."
"The features I found most valuable are the preparation features – the Join and the Transform."
"It helps them to create customized workflows, transform data, perform calculations, and consolidate multiple data sources into a target database."
"I have been using Alteryx Designer only for data modeling and data structuring."
"It has great UI."
"UI is easy to navigate and I can retrieve VTL code without knowing in-depth coding languages."
"The initial setup is very quick and easy."
"We have found the bulk load feature very valuable."
"From what we have seen so far, the solution seems very stable."
"For me, it was that there are dedicated connectors for different targets or sources, different data sources. For example, there is direct connector to Salesforce, Oracle Service Cloud, etcetera, and that was really helpful."
"Data Factory's best features are simplicity and flexibility."
"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."
"The trigger scheduling options are decently robust."
"The conditional join feature should be improved."
"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."
"When it comes to the pivoting part, the drill-through option is not there in Alteryx."
"Alteryx Designer's cost should be improved."
"When configuring the Logix, the UA could be improved."
"The only thing is sometimes it can be a bit slow."
"An improvement for Alteryx Designer would be faster bug fixes and updates."
"The price of the product is an area with certain shortcomings where improvements are required."
"They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"The number of standard adaptors could be extended further."
"It would be better if it had machine learning capabilities."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"Azure Data Factory could benefit from improvements in its monitoring capabilities to provide a more robust feature set. Enhancing the ease of deployment to higher environments within Azure DevOps would be beneficial, as the current process often requires extensive scripting and pipeline development. It is also known for the flexibility of the data flow feature, particularly in supporting more dynamic data-driven architectures. These enhancements would contribute to a more seamless and efficient workflow within GitLab."
Alteryx Designer is ranked 9th in Data Integration with 28 reviews while Azure Data Factory is ranked 1st in Data Integration with 81 reviews. Alteryx Designer is rated 8.0, while Azure Data Factory is rated 8.0. 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 Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". Alteryx Designer is most compared with FME, SSIS, Informatica PowerCenter, SAP Data Services and Palantir Foundry, whereas Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Snowflake, IBM InfoSphere DataStage and Palantir Foundry. See our Alteryx Designer vs. Azure Data Factory 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.