Try our new research platform with insights from 80,000+ expert users

Alteryx Designer vs Azure Data Factory comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 8, 2024
 

Categories and Ranking

Alteryx Designer
Ranking in Data Integration
11th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
30
Ranking in other categories
No ranking in other categories
Azure Data Factory
Ranking in Data Integration
1st
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (3rd)
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Alteryx Designer is 3.3%, down from 4.3% compared to the previous year. The mindshare of Azure Data Factory is 11.1%, down from 13.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Ajay Nayak - PeerSpot reviewer
An easy-to-use automation solution with satisfying customer support
Sometimes, while getting data from a third-party product, like data sources that are not present in your system, Alteryx works a bit slowly. Even if you have a good configuration and you are pulling data from an SQL server like SAP, then the solution also has a slow work process. It shouldn't be that much slow if you are pulling ten thousand records, it should not take thirty minutes.
Thulani David Mngadi - PeerSpot reviewer
Data flow feature is valuable for data transformation tasks
The workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Alteryx is quite easy to use, learn, and understand as a product."
"It has an easy setup process."
"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."
"The solution's ability to hold a huge amount of data in its memory is significant."
"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"Alteryx Designer is stable."
"It has great UI."
"The product offers very good analytics."
"Microsoft supported us when we planned to provision Azure Data Factory over a private link. As a result, we received excellent support from Microsoft."
"For developers that are very accustomed to the Microsoft development studio, it's very easy for them to complete end-to-end data integration."
"I like that it's a monolithic data platform. This is why we propose these solutions."
"An excellent tool for pipeline orchestration."
"The platform excels in data transformation with its user-friendly interface and robust monitoring capabilities, making ETL processes seamless."
"The most valuable feature is the copy activity."
"We haven't had any issues connecting it to other products."
"The most valuable aspect is the copy capability."
 

Cons

"The conditional join feature should be improved."
"The price of the product is an area with certain shortcomings where improvements are required."
"We discontinued using Alteryx's data science studio because it was not very user-friendly."
"The product could offer more connectors and more databases with support for the in-database function."
"Alteryx's data science and machine learning capabilities are where it loses out to DataIQ."
"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."
"The only thing is sometimes it can be a bit slow."
"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."
"The product integration with advanced coding options could cater to users needing more customization."
"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."
"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."
"The thing we missed most was data update, but this is now available as of two weeks ago."
"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
"The solution needs to be more connectable to its own services."
"Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."
"In the next release, it's important that some sort of scheduler for running tasks is added."
 

Pricing and Cost Advice

"The tool is priced high."
"I rate the price of Alteryx Designer a ten on a scale of one to ten, where one is low price and ten is high price."
"The solution is expensive. It has license fees, which are renewable every year."
"Alteryx Designer is an expensive solution."
"The product is a bit expensive, it should be looked into."
"Alteryx Designer is an expensive solution."
"Each license is something like $4,000."
"I rate Alteryx Designer a six out of ten for pricing."
"I would not say that this product is overly expensive."
"Azure Data Factory gives better value for the price than other solutions such as Informatica."
"I don't see a cost; it appears to be included in general support."
"For our use case, it is not expensive. We take into the picture everything: resources, learning curve, and maintenance."
"It seems very low initially, but as the data grows, the solution’s bills grow exponentially."
"Pricing is comparable, it's somewhere in the middle."
"Azure products generally offer competitive pricing, suitable for diverse budget considerations."
"My company is on a monthly subscription for Azure Data Factory, but it's more of a pay-as-you-go model where your monthly invoice depends on how many resources you use. On a scale of one to five, pricing for Azure Data Factory is a four. It's just the usage fees my company pays monthly."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
24%
Financial Services Firm
16%
Manufacturing Company
8%
Computer Software Company
6%
Financial Services Firm
13%
Computer Software Company
12%
Manufacturing Company
9%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Alteryx Designer?
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.
What is your experience regarding pricing and costs for Alteryx Designer?
The solution is expensive. It has license fees, which are renewable every year.
What needs improvement with Alteryx Designer?
Alteryx Designer is not as fast as SSIS and is not good for large datasets. It also needs to improve database procedures. Though it is easy to use, it is limited in terms of technical aspects.
How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
 

Learn More

 

Overview

Information not available
 

Sample Customers

Information Not Available
1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa
Find out what your peers are saying about Alteryx Designer vs. Azure Data Factory and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.