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

Azure Data Factory vs Zapier comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Azure Data Factory
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
90
Ranking in other categories
Data Integration (1st), Cloud Data Warehouse (3rd)
Zapier
Average Rating
8.6
Reviews Sentiment
7.1
Number of Reviews
41
Ranking in other categories
Cloud Data Integration (10th)
 

Mindshare comparison

While both are Data Integration and Access solutions, they serve different purposes. Azure Data Factory is designed for Data Integration and holds a mindshare of 8.9%, down 12.5% compared to last year.
Zapier, on the other hand, focuses on Cloud Data Integration, holds 2.0% mindshare, up 1.8% since last year.
Data Integration
Cloud Data Integration
 

Featured Reviews

Joy Maitra - PeerSpot reviewer
Facilitates seamless data pipeline creation with good analytics and and thorough monitoring
Azure Data Factory is a low code, no code platform, which is helpful. It provides many prebuilt functionalities that assist in building data pipelines. Also, it facilitates easy transformation with all required functionalities for analytics. Furthermore, it connects to different sources out-of-the-box, making integration much easier. The monitoring is very thorough, though a more readable version would be appreciable.
FrankHo - PeerSpot reviewer
Though the tool offers a visually appealing UI, it needs to improve its documentation
With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation. The product has many bugs, so users have to wait for a period ranging from five minutes to an hour to see where the Zap went. In Zapier, Zaps aren't very understandable owing to the way they work. As a user, you would think that in Zapier, a Zap works in a particular way once you set it up, but it won't happen. At times, some Zaps can interfere with each other, because of which there might be infinite loops that may occur, owing to which multiple Zaps continue to run or break down in general, after which nothing would run in your environment. You would not be notified about the breakdown of Zaps. The bugs in the product may be considered to understand or get an explanation of how Zaps works between software systems, so for something between Gmail and HubSpot, Zapier would explain through better documentation what would work and what wouldn't work. Maybe if Zapier had better functionality with Python or any other coding language in general, it would make the product a lot better.

Quotes from Members

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

Pros

"It is beneficial that the solution is written with Spark as the back end."
"The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
"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."
"The most valuable aspect is the copy capability."
"The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."
"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"The data copy template is a valuable feature."
"The most valuable feature of this solution would be ease of use."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."
"Zapier's interface, for me, is the solution's greatest value proposition. It is designed and developed for people who don't have a clue about what they're trying to do. It has a very user-friendly interface."
"The solution is a SaaS and does not require a complex setup."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"The product's most valuable feature is automation."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
 

Cons

"The tool’s workflow is not user-friendly. It should also improve its orchestration monitoring."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"It would be better if it had machine learning capabilities."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"The one element of the solution that we have used and could be improved is the user interface."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."
"My biggest concern with Zapier would be their pricing strategy."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"I think that this solution should have more apps connected to it."
"The solution does not work properly when we apply filters and we get errors."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."
"Being able to share Zaps and organize them with teammates would allow sharing and refining scenarios and even combining steps that require different people's credentials."
"The pricing could be a little cheaper."
 

Pricing and Cost Advice

"The solution's fees are based on a pay-per-minute use plus the amount of data required to process."
"Azure products generally offer competitive pricing, suitable for diverse budget considerations."
"There's no licensing for Azure Data Factory, they have a consumption payment model. How often you are running the service and how long that service takes to run. The price can be approximately $500 to $1,000 per month but depends on the scaling."
"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."
"Understanding the pricing model for Data Factory is quite complex."
"The solution is cheap."
"Our licensing fees are approximately 15,000 ($150 USD) per month."
"The least expensive plan is $24 a month, and you can go all the way to $800 a month if you're a huge company using many tasks."
"Think your Zaps through to make sure you don't use more Zaps than you need."
"Zapier is a paid service. Its license renews monthly, and Zapier will downgrade your subscription to the free version when your credit card doesn't have funds. That significantly impacts your service because everything halts completely. Zapier doesn't have any hidden costs."
"The price of Zapier is approximately $75 monthly."
"It's very affordable."
"The product is reasonably priced."
"There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."
"It's very straightforward licensing. There's only one cost you have to pay, and if you want a relevant pricing plan, I think you have two or three different models or packages which include the number of notifications or Zaps, as they call it, that you can program."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
849,963 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Computer Software Company
12%
Manufacturing Company
9%
Healthcare Company
7%
Computer Software Company
16%
Financial Services Firm
10%
University
9%
Educational Organization
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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...
What do you like most about Zapier?
The product's most valuable feature is automation.
What is your experience regarding pricing and costs for Zapier?
The pricing is suitable. It's not cheap, but not expensive.
What needs improvement with Zapier?
The pricing could be a little cheaper.
 

Overview

 

Sample Customers

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
BuzzFeed, Groupon, Spotify, Columbia University, FOX
Find out what your peers are saying about Azure Data Factory vs. Zapier and other solutions. Updated: May 2023.
849,963 professionals have used our research since 2012.