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 Designer is a tool that is pretty much easy to install."
"The most valuable features are the integrated properties and integrated connectivity."
"The solution is easy to integrate and user-friendly."
"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"Workflow automation, in general, is valuable."
"Alteryx Designer's best features are that it's easy to use and performs well."
"I like Alteryx Designer's drag-and-drop feature, where you drag a component, configure it and quickly run it."
"The product is intuitive and easy to use."
"Data Factory's most valuable feature is Copy Activity."
"It's extremely consistent."
"We have been using drivers to connect to various data sets and consume data."
"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 scalability of the product is impressive."
"Data Factory itself is great. It's pretty straightforward. You can easily add sources, join and lookup information, etc. The ease of use is pretty good."
"The user interface is very good. It makes me feel very comfortable when I am using the tool."
"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
"The product could offer more connectors and more databases with support for the in-database function."
"Alteryx Designer's cost should be improved."
"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."
"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."
"When it comes to the pivoting part, the drill-through option is not there in Alteryx."
"The conditional join feature should be improved."
"We need more documentation."
"We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on."
"Azure Data Factory's pricing in terms of utilization could be improved."
"Data Factory's cost is too high."
"One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"There are limitations when processing more than one GD file."
"I have not found any real shortcomings within the product."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
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, Informatica PowerCenter, SSIS, Palantir Foundry and SAP Data Services, whereas Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Snowflake, IBM InfoSphere DataStage and Microsoft Azure Synapse Analytics. 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.