Azure Data Factory vs Fivetran comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
25,660 views|20,160 comparisons
91% willing to recommend
Fivetran Logo
4,401 views|2,957 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: May 2024).
771,212 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 workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem.""UI is easy to navigate and I can retrieve VTL code without knowing in-depth coding languages.""The most valuable feature is the copy activity.""The solution has a good interface and the integration with GitHub is very useful.""The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable.""We use the solution to move data from on-premises to the cloud.""Data Flow and Databricks are going to be extremely valuable services, allowing data solutions to scale as the business grows and new data sources are added.""The scalability of the product is impressive."

More Azure Data Factory Pros →

"The solution is stable. We've never faced any stability issues.""The product has some seamless connectors, which are readily available.""The product is very easy to use and very easy to configure.""The compare feature is the most valuable piece of it.""The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized.""Fivetran can perform data migration incredibly fast, depending on the source and target.""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 simplicity of the solution is its valuable feature."

More Fivetran Pros →

Cons
"There is room for improvement primarily in its streaming capabilities. For structured streaming and machine learning model implementation within an ETL process, it lags behind tools like Informatica.""The solution needs to integrate more with other providers and should have a closer integration with Oracle BI.""Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue.""We have experienced some issues with the integration. This is an area that needs improvement.""There's space for improvement in the development process of the data pipelines.""A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement.""The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way.""The number of standard adaptors could be extended further."

More Azure Data Factory Cons →

"I would like Fivetran to implement additional resource monitoring and restriction policies.""The connections with SAP must be improved.""The interface needs to be more user-friendly.""HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed.""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.""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.""We experience cost issues because Fivetran is charged on a usage basis. When you reach a certain level, the tool should focus on reducing the costs. The solution is expensive when you are moving gigabytes and petabytes of data. It should also focus more on REST APIs and webhooks.""The solution is very expensive. I would like to have a better integration of the solution with Azure."

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.
    771,212 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 101 in Data Integration
    Views
    25,660
    Comparisons
    20,160
    Reviews
    47
    Average Words per Review
    509
    Rating
    8.0
    13th
    out of 101 in Data Integration
    Views
    4,401
    Comparisons
    2,957
    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 Company11%
    Financial Services Firm11%
    Manufacturing Company9%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise19%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    REVIEWERS
    Small Business17%
    Midsize Enterprise25%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise30%
    Large Enterprise56%
    Buyer's Guide
    Azure Data Factory vs. Fivetran
    May 2024
    Find out what your peers are saying about Azure Data Factory vs. Fivetran and other solutions. Updated: May 2024.
    771,212 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 20 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 IBM InfoSphere DataStage, 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.