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.
"Alteryx is quite easy to use, learn, and understand as a product."
"The features I found most valuable are the preparation features – the Join and the Transform."
"Alteryx Designer is a tool that is pretty much easy to install."
"Alteryx Designer is stable."
"The product is very stable. The performance is reliable."
"It has an easy setup process."
"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"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."
"It's cloud-based, allowing multiple users to easily access the solution from the office or remote locations. I like that we can set up the security protocols for IP addresses, like allow lists. It's a pretty user-friendly product as well. The interface and build environment where you create pipelines are easy to use. It's straightforward to manage the digital transformation pipelines we build."
"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."
"ADF is another ETL tool similar to Informatica that can transform data or copy it from on-prem to the cloud or vice versa. Once we have the data, we can apply various transformations to it and schedule our pipeline according to our business needs. ADF integrates with Databricks. We can call our Databricks notebooks and schedule them via ADF."
"I like the basic features like the data-based pipelines."
"The most valuable features of the solution are its ease of use and the readily available adapters for connecting with various sources."
"The most valuable feature is the ease in which you can create an ETL pipeline."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"The flexibility that Azure Data Factory offers is great."
"If the price were reduced then it would be more competitive."
"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."
"It would be simpler if they provided a component where you could simply enter some parameters and see the results."
"An improvement for Alteryx Designer would be faster bug fixes and updates."
"Alteryx's data science and machine learning capabilities are where it loses out to DataIQ."
"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."
"We need more documentation."
"Alteryx Designer's pricing and support could be improved."
"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."
"The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it."
"Data Factory's monitorability could be better."
"Integration of data lineage would be a nice feature in terms of DevOps integration. It would make implementation for a company much easier. I'm not sure if that's already available or not. However, that would be a great feature to add if it isn't already there."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
"Real-time replication is required, and this is not a simple task."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"Lacks in-built streaming data processing."
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.