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

"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"The platform excels in data transformation with its user-friendly interface and robust monitoring capabilities, making ETL processes seamless."
"The trigger scheduling options are decently robust."
"Data Factory's most valuable feature is Copy Activity."
"One advantage of Azure Data Factory is that it's fast, unlike SSIS and other on-premise tools. It's also very convenient because it has multiple connectors. The availability of native connectors allows you to connect to several resources to analyze data streams."
"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 like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft."
"Zapier luckily has a wide range of integrations, I would say."
"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."
"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."
"Zapier’s most valuable feature is its ability to interconnect applications or devices."
"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."
"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 connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"The product's most valuable feature is automation."
 

Cons

"The tool’s workflow is not user-friendly. It should also improve its orchestration monitoring."
"I do not have any notes for improvement."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"It would be better if it had machine learning capabilities."
"For some of the data, there were some issues with data mapping. Some of the error messages were a little bit foggy. There could be more of a quick start guide or some inline examples. The documentation could be better."
"There's no Oracle connector if you want to do transformation using data flow activity, so Azure Data Factory needs more connectors for data flow transformation."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"Customer service is not satisfactory. Third-party personnel handle support and rely on a knowledge repository."
"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."
"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."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"The pricing of the solution is quite expensive."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
"It could support various languages along with Python."
"The solution does not work properly when we apply filters and we get errors."
 

Pricing and Cost Advice

"Understanding the pricing model for Data Factory is quite complex."
"The licensing cost is included in the Synapse."
"Azure Data Factory gives better value for the price than other solutions such as Informatica."
"The pricing model is based on usage and is not cheap."
"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."
"Azure products generally offer competitive pricing, suitable for diverse budget considerations."
"I would rate Data Factory's pricing nine out of ten."
"It seems very low initially, but as the data grows, the solution’s bills grow exponentially."
"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."
"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."
"There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."
"Zapier's price is good."
"Think your Zaps through to make sure you don't use more Zaps than you need."
"It's very affordable."
"The price of Zapier is approximately $75 monthly."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
846,617 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.
846,617 professionals have used our research since 2012.