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 9.5%, down 12.7% compared to last year.
Zapier, on the other hand, focuses on Cloud Data Integration, holds 1.9% 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

"Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process."
"It's extremely consistent."
"Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."
"We have been using drivers to connect to various data sets and consume data."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"I can do everything I want with SSIS and Azure Data Factory."
"It is easy to integrate."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"Zapier handles everything under the sun that you would think you need in automation. It is the most mature integration platform and service on the market."
"Zapier luckily has a wide range of integrations, I would say."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"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."
"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 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."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
 

Cons

"The deployment should be easier."
"The setup and configuration process could be simplified."
"There aren't many third-party extensions or plugins available in the solution."
"Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful."
"Some of the optimization techniques are not scalable."
"We require Azure Data Factory to be able to connect to Google Analytics."
"It would be better if it had machine learning capabilities."
"Real-time replication is required, and this is not a simple task."
"The pricing of the solution is quite expensive."
"It could support various languages along with Python."
"System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"I would like to see them improve the Quickbase integration. Currently, it only allows triggering actions when records are added, but it would be more useful if we could also trigger actions when records are modified or deleted."
"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."
 

Pricing and Cost Advice

"ADF is cheaper compared to AWS."
"The price you pay is determined by how much you use it."
"The licensing cost is included in the Synapse."
"The solution's fees are based on a pay-per-minute use plus the amount of data required to process."
"I don't see a cost; it appears to be included in general support."
"The price is fair."
"In terms of licensing costs, we pay somewhere around S14,000 USD per month. There are some additional costs. For example, we would have to subscribe to some additional computing and for elasticity, but they are minimal."
"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."
"The price of Zapier is approximately $75 monthly."
"There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."
"The product is reasonably priced."
"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."
"Zapier's price is good."
"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."
"Per task, there is a monthly plan involving 15 euros...Also, in different forms, they just give you the ability to use different features. They charge 18.58 euros for the first standard plan, which includes 750 tasks. So, it is about 25 cents per task."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
847,625 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
6%
Computer Software Company
16%
Financial Services Firm
9%
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.
847,625 professionals have used our research since 2012.