Azure Data Factory vs Zapier comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
24,893 views|19,539 comparisons
91% willing to recommend
Zapier Logo
1,498 views|672 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).
772,679 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
"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.""Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft.""The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components.""The solution can scale very easily.""Allows more data between on-premises and cloud solutions""We have found the bulk load feature very valuable.""This solution will allow the organisation to improve its existing data offerings over time by adding predictive analytics, data sharing via APIs and other enhancements readily.""The most valuable feature of this solution would be ease of use."

More Azure Data Factory Pros →

"Webhooks are the most valuable feature of Zapier.""The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve.""The initial setup is pretty easy to do.""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 product's most valuable feature is automation.""We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature.""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.""The product's initial setup phase was very easy."

More Zapier Pros →

Cons
"There are limitations when processing more than one GD file.""Some of the optimization techniques are not scalable.""Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful.""The thing we missed most was data update, but this is now available as of two weeks ago.""Azure Data Factory can improve by having support in the drivers for change data capture.""My only problem is the seamless connectivity with various other databases, for example, SAP.""We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on.""There aren't many third-party extensions or plugins available in the solution."

More Azure Data Factory Cons →

"After mapping them out, and they'd worked for a while, I've had Zapier fail.""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.""The user interface for Zapier could be improved. It also takes some time to sync the data between different environments.""The pricing could be a little cheaper.""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""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."

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.
    772,679 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 103 in Data Integration
    Views
    24,893
    Comparisons
    19,539
    Reviews
    45
    Average Words per Review
    507
    Rating
    8.0
    9th
    Views
    1,498
    Comparisons
    672
    Reviews
    15
    Average Words per Review
    487
    Rating
    8.5
    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 Firm14%
    Computer Software Company14%
    Marketing Services Firm14%
    Leisure / Travel Company7%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Comms Service Provider7%
    Financial Services Firm6%
    Media Company6%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise19%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    REVIEWERS
    Small Business63%
    Midsize Enterprise22%
    Large Enterprise15%
    VISITORS READING REVIEWS
    Small Business33%
    Midsize Enterprise14%
    Large Enterprise53%
    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.
    772,679 professionals have used our research since 2012.

    Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Zapier is ranked 9th in Cloud Data Integration with 41 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 IBM InfoSphere DataStage, whereas Zapier is most compared with AWS Glue, Alteryx Designer, Tray.io, Coefficient and Workato. 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.