Azure Data Factory vs Fivetran comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
26,170 views|20,469 comparisons
91% willing to recommend
Fivetran Logo
4,412 views|2,978 comparisons
86% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Azure Data Factory and Fivetran 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. Fivetran Report (Updated: March 2024).
768,415 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
"Azure Data Factory became more user-friendly when data-flows were introduced.""The trigger scheduling options are decently robust.""The overall performance is quite good.""The most valuable aspect is the copy capability.""It is easy to deploy workflows and schedule jobs.""Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure.""The solution can scale very easily.""It is beneficial that the solution is written with Spark as the back end."

More Azure Data Factory Pros →

"Fivetran's most valuable feature is replication.""Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic.""The product is very easy to use and very easy to configure.""The most important feature of the solution is its ability to build data pipelines in less time.""The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized.""There's the general feature of the platform where it just makes it very easy to integrate different things, but I would say a specific difference is their integration of DBT,.""The product has some seamless connectors, which are readily available.""The simplicity of the solution is its valuable feature."

More Fivetran Pros →

Cons
"Azure Data Factory uses many resources and has issues with parallel workflows.""Lacks in-built streaming data processing.""The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others.""Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog.""Data Factory's performance during heavy data processing isn't great.""The setup and configuration process could be simplified.""There aren't many third-party extensions or plugins available in the solution.""Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."

More Azure Data Factory Cons →

"We use a separate tool for "reverse ETL", which is the opposite of what Fivetran does; it pushes data from your data warehouse back out to business applications. If Fivetran pulls data from those same applications, they should also enable users to push it back. I would love to do both ETL and reverse ETL in the same tool.""It should have a few more monitoring functionalities.""Fivetran is very expensive for data sources with a lot of rows, such as email data. I would like to see cheaper pricing for data sources like that.""The documentation can be laid out better to make it easier to find things, and I really wish there was built-in support for changing passwords. Some features don't work as advertised for the platform/repository database, and HVR is not always the fastest at getting results.""The customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly.""There was a random change to our contract in a unilateral manner after the first year. The overall cost of using Fivetran was then unclear and this is the reason I would not recommend this solution.""The solution is very expensive. I would like to have a better integration of the solution with Azure.""I would like Fivetran to implement additional resource monitoring and restriction policies."

More Fivetran 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 →

  • "I don't have the exact information, but I know it is high, and it is on a yearly basis. There is no additional cost for what we're doing. We're always open to doing things cheaper, so we might potentially implement a different solution."
  • "I've heard that the license for HVR is a bit costly compared to its competitors, but since it's reliable and efficient, I think the customer shouldn't be bothered about the cost."
  • "Fivetran is very expensive, and its database-driven pricing model is outdated."
  • "I can't give exact amounts because that's based on usage, but it's more expensive than some of its competitors."
  • "In the first year, we were given a very good discount. It was approximately 20,000 Euros per year. In the third year, we purchased credit for two years and the price was 33,000 Euros per year."
  • "I would say they're a little bit on the expensive side, and their contract process is not particularly good, but there is a lot of potential flexibility."
  • "The pricing model is okay and mid to large companies will not have an issue with it."
  • "The licensing costs are extremely high for the usage of somebody who has one GB or two GB of usage per day for real-time traffic. There are many other players in the market which are similarly priced or competitively priced. On average per month, it used to come around 12,000-15,000 USD, which is very high."
  • More Fivetran Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    768,415 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:As a user of HVR Software I followed this deal closely. Fivetran is apparently trying to establish more in its sector and by buying an already established data replication software, they become some… more »
    Top Answer: I honestly can't think of another data replication software that can give you better statistics and insight than HVR Software. There's the feature for topology and statistics and both of them can… more »
    Top Answer:As someone who works at a company where a high volume of information is replicated and has tried several data replication softwares, I can tell you that you're looking at the right one. HVR Software… more »
    Ranking
    1st
    out of 100 in Data Integration
    Views
    26,170
    Comparisons
    20,469
    Reviews
    46
    Average Words per Review
    489
    Rating
    8.0
    13th
    out of 100 in Data Integration
    Views
    4,412
    Comparisons
    2,978
    Reviews
    15
    Average Words per Review
    603
    Rating
    8.0
    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.

    Fivetran is a data integration and migration solution that centralizes data from various sources into a data warehouse (such as Snowflake or BigQuery) for analytics. Its most valuable features include replication and managed pipelines, integration with DBT for data transformation, and many source connections. 

    Fivetran is easy to use, with fast data migration and an intuitive portal for easy setup and troubleshooting. It has helped organizations integrate and manage data, saving time and resources.

    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
    DocuSign, Oldcastle Infrastructure, Crossmedia, Talkdesk, Chubbies, Brandwatch
    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
    Manufacturing Company42%
    Outsourcing Company17%
    Transportation Company8%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Educational Organization24%
    Computer Software Company12%
    Financial Services Firm11%
    Manufacturing Company9%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise19%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise70%
    REVIEWERS
    Small Business13%
    Midsize Enterprise26%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise30%
    Large Enterprise57%
    Buyer's Guide
    Azure Data Factory vs. Fivetran
    March 2024
    Find out what your peers are saying about Azure Data Factory vs. Fivetran and other solutions. Updated: March 2024.
    768,415 professionals have used our research since 2012.

    Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Fivetran is ranked 13th in Data Integration with 19 reviews. Azure Data Factory is rated 8.0, while Fivetran is rated 8.0. 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 Fivetran writes "Solution reduces time-to-value; high ROI". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Oracle GoldenGate, Informatica Cloud Data Integration and StreamSets. See our Azure Data Factory vs. Fivetran report.

    See our list of best Data Integration vendors.

    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.