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.
"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."
"Alteryx Designer is stable."
"The solution is user-friendly."
"The product is intuitive and easy to use."
"The solution is easy to integrate and user-friendly."
"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."
"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 has an easy setup process."
"The trigger scheduling options are decently robust."
"The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
"The solution has a good interface and the integration with GitHub is very useful."
"It has built-in connectors for more than 100 sources and onboarding data from many different sources to the cloud environment."
"Powerful but easy-to-use and intuitive."
"Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft."
"The solution is okay."
"The most important feature is that it can help you do the multi-threading concepts."
"Alteryx Designer's pricing and support could be improved."
"Alteryx Designer's cost should be improved."
"Its cost can sometimes be a drawback."
"The conditional join feature should be improved."
"We need more documentation."
"Sometimes, while getting data from a third-party product, the solution works slowly."
"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."
"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."
"Data Factory's performance during heavy data processing isn't great."
"Areas for improvement in Azure Data Factory include connectivity and integration. When you use integration runtime, whenever there's a failure, the backup process in Azure Data Factory takes time, so this is another area for improvement."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
"If the user interface was more user friendly and there was better error feedback, it would be helpful."
"It does not appear to be as rich as other ETL tools. It has very limited capabilities."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"There is room for improvement primarily in its streaming capabilities. For structured streaming and machine learning model implementation within an ETL process, it lags behind tools like Informatica."
"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."
Alteryx Designer is ranked 9th in Data Integration with 27 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, Informatica PowerCenter, SSIS, Palantir Foundry and SAP Data Services, whereas Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Snowflake, Microsoft Azure Synapse Analytics and IBM InfoSphere DataStage. 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.