Azure Data Factory vs. Fivetran

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Data Factory
Score 8.2 out of 10
N/A
Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.N/A
Fivetran
Score 8.4 out of 10
N/A
Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using cloud-based software and storage, traditional ETL tools badly underperformed, and the complicated configurations they required often led to project failures. To streamline and accelerate…
$0.01
Pricing
Azure Data FactoryFivetran
Editions & Modules
No answers on this topic
Starter
$0.01
per credit
Standard
$0.01
per credit
Enterprise
$0.01
per credit
Offerings
Pricing Offerings
Azure Data FactoryFivetran
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
Azure Data FactoryFivetran
Considered Both Products
Azure Data Factory
Chose Azure Data Factory
Azure Data Factory helps us automate to schedule jobs as per customer demands to make ETL triggers when the need arises. Anyone can define the workflow with the Azure Data Factory UI designer tool and easily test the systems. It helped us automate the same workflow with …
Fivetran
Chose Fivetran
Fivetran is more intuitive and easier to use than code-based ETL/ELT tools. The data modelling Fivetran performs makes the data more usable more quickly. Fivetran's dbt support and integration is unique.
Top Pros
Top Cons
Features
Azure Data FactoryFivetran
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Azure Data Factory
9.1
7 Ratings
9% above category average
Fivetran
9.9
7 Ratings
17% above category average
Connect to traditional data sources9.17 Ratings9.97 Ratings
Connecto to Big Data and NoSQL9.07 Ratings9.95 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Azure Data Factory
8.5
7 Ratings
3% above category average
Fivetran
4.6
6 Ratings
56% below category average
Simple transformations9.17 Ratings5.26 Ratings
Complex transformations7.87 Ratings4.14 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Azure Data Factory
7.5
7 Ratings
7% below category average
Fivetran
6.1
7 Ratings
28% below category average
Data model creation8.25 Ratings2.36 Ratings
Metadata management7.36 Ratings4.24 Ratings
Business rules and workflow7.37 Ratings7.95 Ratings
Collaboration6.76 Ratings7.14 Ratings
Testing and debugging7.37 Ratings8.93 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Azure Data Factory
7.6
7 Ratings
9% below category average
Fivetran
9.9
6 Ratings
17% above category average
Integration with data quality tools7.37 Ratings9.85 Ratings
Integration with MDM tools8.07 Ratings9.93 Ratings
Best Alternatives
Azure Data FactoryFivetran
Small Businesses
Skyvia
Skyvia
Score 9.7 out of 10
Skyvia
Skyvia
Score 9.7 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Data FactoryFivetran
Likelihood to Recommend
9.3
(7 ratings)
9.0
(8 ratings)
Usability
-
(0 ratings)
9.0
(1 ratings)
Performance
-
(0 ratings)
8.0
(1 ratings)
Support Rating
7.0
(1 ratings)
-
(0 ratings)
User Testimonials
Azure Data FactoryFivetran
Likelihood to Recommend
Microsoft
Well-suited Scenarios for Azure Data Factory (ADF): When an organization has data sources spread across on-premises databases and cloud storage solutions, I think Azure Data Factory is excellent for integrating these sources. Azure Data Factory's integration with Azure Databricks allows it to handle large-scale data transformations effectively, leveraging the power of distributed processing. For regular ETL or ELT processes that need to run at specific intervals (daily, weekly, etc.), I think Azure Data Factory's scheduling capabilities are very handy. Less Appropriate Scenarios for Azure Data Factory: Real-time Data Streaming - Azure Data Factory is primarily batch-oriented. Simple Data Copy Tasks - For straightforward data copy tasks without the need for transformation or complex workflows, in my opinion, using Azure Data Factory might be overkill; simpler tools or scripts could suffice. Advanced Data Science Workflows: While Azure Data Factory can handle data prep and transformation, in my experience, it's not designed for in-depth data science tasks. I think for advanced analytics, machine learning, or statistical modeling, integration with specialized tools would be necessary.
Read full review
Fivetran
Fivetran's business model justifies the use-case where we require data from a single source basically a lot of data but if the requirement is not on the heavier side, Fivetran comes to costly operation when compared to its peers. Otherwise, I'll recommend Fivetran for stability and update and seamless service provider.
Read full review
Pros
Microsoft
  • It allows copying data from various types of data sources like on-premise files, Azure Database, Excel, JSON, Azure Synapse, API, etc. to the desired destination.
  • We can use linked service in multiple pipeline/data load.
  • It also allows the running of SSIS & SSMS packages which makes it an easy-to-use ETL & ELT tool.
Read full review
Fivetran
  • Easily connects to source data using delivered connectors
  • Transforms data into standard models and schemas
  • Has very good documentation to help quickly setup connectors
Read full review
Cons
Microsoft
  • Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
  • Does not yet have parity with SSIS as far as the transforms available.
Read full review
Fivetran
  • More detailed logging
  • More flexible choices for time range over which records are synced
  • More options for masking and excluding sensitive data
Read full review
Usability
Microsoft
No answers on this topic
Fivetran
Just need to input connection info.
Read full review
Performance
Microsoft
No answers on this topic
Fivetran
It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.
Read full review
Support Rating
Microsoft
We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue
Read full review
Fivetran
No answers on this topic
Alternatives Considered
Microsoft
The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.
Read full review
Fivetran
We never seriously considered using anything else. Our data engineers had used Fivetran extensively in previous roles so when it came time to make a decision, there wasn't much of a process. They gladly signed the contract with Fivetran pretty quickly.
Read full review
Return on Investment
Microsoft
  • It is very useful and make things easier
  • Debugging can improve
  • Its better suited than other products with the same objective
Read full review
Fivetran
  • Business and product data now co-located in the warehouse
  • Dashboards can be built using data from all corners of the business
  • Better visibility into customer health, product usage, business financials, and more
  • Enabled high-traffic operational dashboards that increase efficiency of our sales and ops teams
Read full review
ScreenShots