Azure Data Factory vs Zapier comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
26,170 views|20,469 comparisons
91% willing to recommend
Zapier Logo
1,549 views|699 comparisons
95% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Azure Data Factory and Zapier based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Azure Data Factory vs. Zapier Report (Updated: May 2023).
768,886 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The flexibility that Azure Data Factory offers is great.""The data factory agent is quite good and programming or defining the value of jobs, processes, and activities is easy.""Allows more data between on-premises and cloud solutions""The security of the agent that is installed on-premises is very good.""It's extremely consistent.""ADF is another ETL tool similar to Informatica that can transform data or copy it from on-prem to the cloud or vice versa. Once we have the data, we can apply various transformations to it and schedule our pipeline according to our business needs. ADF integrates with Databricks. We can call our Databricks notebooks and schedule them via ADF.""The trigger scheduling options are decently robust.""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."

More Azure Data Factory Pros →

"Zapier is a really good tool for connecting multiple different platforms and data sources. For example, with Quickbase, I can easily integrate data from other sources like AWS or task-tracking platforms such as ClickUp or Asana.""The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve.""Webhooks are the most valuable feature of Zapier.""The product's initial setup phase was very easy.""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.""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.""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."

More Zapier Pros →

Cons
"In the next release, it's important that some sort of scheduler for running tasks is added.""Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful.""A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement.""Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters.""Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations.""Data Factory's cost is too high.""There's space for improvement in the development process of the data pipelines.""When the record fails, it's tough to identify and log."

More Azure Data Factory Cons →

"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.""My biggest concern with Zapier would be their pricing strategy.""The pricing of the solution is quite expensive.""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.""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.""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""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."

More Zapier Cons →

Pricing and Cost Advice
  • "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."
  • "This is a cost-effective solution."
  • "The price you pay is determined by how much you use it."
  • "Understanding the pricing model for Data Factory is quite complex."
  • "I would not say that this product is overly expensive."
  • "The licensing is a pay-as-you-go model, where you pay for what you consume."
  • "Our licensing fees are approximately 15,000 ($150 USD) per month."
  • "The licensing cost is included in the Synapse."
  • More Azure Data Factory Pricing and Cost Advice →

  • "There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."
  • "Think your Zaps through to make sure you don't use more Zaps than you need."
  • "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 price of Zapier is approximately $75 monthly."
  • "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."
  • "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."
  • "It's very affordable."
  • "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."
  • More Zapier Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    768,886 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:AWS Glue and Azure Data factory for ELT best performance cloud services.
    Top Answer: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 and… more »
    Top Answer: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… more »
    Top Answer:The product's most valuable feature is automation.
    Top Answer:Zapier's price is high, but it is worth it. You have to pay a premium in order for Zapier to work smoothly. To make your work automation smooth, you have to pay a premium for it because you don't have… more »
    Top Answer:One notable concern is the time-out resources assigned to automation when running. It could support various languages along with Python.
    Ranking
    1st
    out of 100 in Data Integration
    Views
    26,170
    Comparisons
    20,469
    Reviews
    46
    Average Words per Review
    489
    Rating
    8.0
    10th
    Views
    1,549
    Comparisons
    699
    Reviews
    14
    Average Words per Review
    505
    Rating
    8.4
    Comparisons
    Learn More
    Overview

    Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.

    Zapier is a tool for primarily non-technical users to connect together web apps.

    An integration between two apps is called a Zap. A Zap is made up of a Trigger and one or more Actions or Searches.

    Whenever the trigger happens in one app, Zapier will automatically perform the actions or searches in another app in order.

    Zaps are very lightweight and easy to set up. Zaps do not import or export old data (they only operate on new items created after the Zap is enabled). Zaps are also not kept in sync ("two way syncing") after the Zap is triggered.

    Zaps are deceivingly simple if you're used to dealing with complex and difficult integrations. Their simplicity is what enables anyone to create them.


    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
    Top Industries
    REVIEWERS
    Computer Software Company34%
    Insurance Company11%
    Manufacturing Company8%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Financial Services Firm13%
    Manufacturing Company8%
    Healthcare Company7%
    REVIEWERS
    Recruiting/Hr Firm15%
    Computer Software Company15%
    Marketing Services Firm15%
    Leisure / Travel Company8%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Comms Service Provider7%
    University6%
    Financial Services Firm6%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise19%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise70%
    REVIEWERS
    Small Business65%
    Midsize Enterprise20%
    Large Enterprise15%
    VISITORS READING REVIEWS
    Small Business32%
    Midsize Enterprise14%
    Large Enterprise54%
    Buyer's Guide
    Azure Data Factory vs. Zapier
    May 2023
    Find out what your peers are saying about Azure Data Factory vs. Zapier and other solutions. Updated: May 2023.
    768,886 professionals have used our research since 2012.

    Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Zapier is ranked 10th in Cloud Data Integration with 40 reviews. Azure Data Factory is rated 8.0, while Zapier is rated 8.6. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of Zapier writes "A tool for automation purposes requiring an easy initial setup while offering a very helpful technical support team ". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas Zapier is most compared with AWS Glue, Alteryx Designer, Tray.io, MuleSoft Composer and SnapLogic. See our Azure Data Factory vs. Zapier report.

    We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.