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

Azure Data Factory vs Zapier comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Azure Data Factory
Average Rating
8.0
Number of Reviews
85
Ranking in other categories
Data Integration (1st), Cloud Data Warehouse (3rd)
Zapier
Average Rating
8.6
Number of Reviews
41
Ranking in other categories
Cloud Data Integration (9th)
 

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 11.1%, down 13.3% compared to last year.
Zapier, on the other hand, focuses on Cloud Data Integration, holds 2.1% mindshare, down 2.4% since last year.
Data Integration
Cloud Data Integration
 

Featured Reviews

Camilo Velasco - PeerSpot reviewer
Oct 27, 2022
No deployment cost, quick implementation, pay only for the processing time and data
The primary use case of this solution is to extract ETLS, transform and load data, and organize database synchronization The most valuable feature of this solution is the data flow, which is the same SQL server in important service, integration services, which is a very robust and powerful tool…
Dimitris Goudis - PeerSpot reviewer
May 16, 2023
A tool for automation purposes requiring an easy initial setup while offering a very helpful technical support team
Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work. So, it's not about the automation process but the triggers that trigger an automation to start running. Sometimes if you set up an automation trigger on a specific application, we wouldn't know if Zapier received data to start running. So we cannot understand whether the problem is in Zapier or the steps before. Branching scenarios is something I want to add to the solution to make my life easier. We want to apply a logical workflow with a yes or no condition. On Zapier, you can have a condition, but you can build the actions after one value on this condition. So, the question can be responded to with a yes-no option or not answered. In your scenario, you have only the actions after yes get chosen. A second scenario is needed for the answer, no, and a third one for not answered. While in Make, we create a diagram, according to which if the response is yes, then do follow this path, and if it's no, then follow another path.

Quotes from Members

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

Pros

"The overall performance is quite good."
"It has built-in connectors for more than 100 sources and onboarding data from many different sources to the cloud environment."
"Data Factory's best features are simplicity and flexibility."
"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 feature I found most helpful in Azure Data Factory is the pipeline feature, including being able to connect to different sources. Azure Data Factory also has built-in security, which is another valuable feature."
"The data factory agent is quite good and programming or defining the value of jobs, processes, and activities is easy."
"The tool's most valuable features are its connectors. It has many out-of-the-box connectors. We use ADF for ETL processes. Our main use case involves integrating data from various databases, processing it, and loading it into the target database. ADF plays a crucial role in orchestrating these ETL workflows."
"I like the basic features like the data-based pipelines."
"The product's most valuable feature is automation."
"There are a few valuable features, like the stability that it comes with and also the number of features that it offers. I've used other services like Pabbly, but they don't offer similar numbers of applications that Zapier has or allows to integrate with – it's maximum."
"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 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."
"What's most valuable in Zapier is its simplicity, seamlessness, and smooth plug-in, so you won't need to build code for every action. I'm not a developer, but I can use Zapier."
"Webhooks are the most valuable feature of Zapier."
"The initial setup is pretty easy to do."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
 

Cons

"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"The Microsoft documentation is too complicated."
"The initial setup is not very straightforward."
"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."
"We require Azure Data Factory to be able to connect to Google Analytics."
"Real-time replication is required, and this is not a simple task."
"Lacks a decent UI that would give us a view of the kinds of requests that come in."
"The pricing model should be more transparent and available online."
"It could support various languages along with Python."
"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 could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"I think that this solution should have more apps connected to it."
"It is not worth the money if you have a little bit of a technical mind...Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work."
"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

"The solution is cheap."
"The solution's fees are based on a pay-per-minute use plus the amount of data required to process."
"Azure Data Factory gives better value for the price than other solutions such as Informatica."
"Data Factory is expensive."
"Data Factory is affordable."
"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."
"The pricing is a bit on the higher end."
"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."
"It's very affordable."
"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."
"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."
"The product is reasonably priced."
"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."
"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."
"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."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Computer Software Company
13%
Manufacturing Company
9%
Healthcare Company
7%
Computer Software Company
22%
University
8%
Comms Service Provider
8%
Financial Services Firm
8%
 

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.
 

Learn More

 

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.
814,649 professionals have used our research since 2012.