Introducing G2.ai, the future of software buying.Try now

Compare Azure Data Factory and dbt

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Azure Data Factory
Azure Data Factory
Star Rating
(82)4.6 out of 5
Market Segments
Enterprise (62.3% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Azure Data Factory
dbt
dbt
Star Rating
(170)4.8 out of 5
Market Segments
Mid-Market (60.1% of reviews)
Information
Entry-Level Pricing
No pricing available
Free Trial is available
Learn more about dbt
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that Azure Data Factory excels in "Data Integration" with a score of 9.0, making it a strong choice for organizations needing to connect various data sources seamlessly. In contrast, dbt, while strong in "Data Transformation" with a score of 9.4, does not focus as heavily on integration capabilities.
  • Reviewers mention that Azure Data Factory's "Automation" features are robust, scoring 9.2, which allows for efficient workflow management. On the other hand, dbt also offers solid automation capabilities with a score of 9.3, but users note that it may require more manual setup compared to Azure's streamlined processes.
  • G2 users highlight Azure Data Factory's "Cloud Migration Capabilities" with a score of 9.2, which is particularly beneficial for enterprises looking to transition to cloud-based solutions. In contrast, dbt does not emphasize cloud migration, focusing more on transformation within existing data environments.
  • Reviewers say that Azure Data Factory's "Quality of Support" is rated at 8.8, indicating a strong support system for users. Conversely, dbt's support is rated slightly lower at 8.9, with some users mentioning that response times can vary.
  • Users on G2 report that Azure Data Factory's "Breadth of Data Sources" is rated at 8.7, allowing for diverse data connectivity options. In comparison, dbt's focus is more on SQL-based transformations, which may limit its versatility in connecting to various data sources.
  • Reviewers mention that Azure Data Factory's "Real-Time Analytics" score of 7.7 indicates some limitations in real-time data processing capabilities. In contrast, dbt shines in "Data Querying" with a score of 9.2, making it a better option for users who prioritize querying capabilities over real-time analytics.
Featured Products
Pricing
Entry-Level Pricing
Azure Data Factory
No pricing available
dbt
No pricing available
Free Trial
Azure Data Factory
No trial information available
dbt
Free Trial is available
Ratings
Meets Requirements
9.2
61
9.2
121
Ease of Use
9.0
62
9.0
121
Ease of Setup
9.1
27
8.5
61
Ease of Admin
8.5
21
8.4
52
Quality of Support
8.8
57
8.8
96
Has the product been a good partner in doing business?
9.4
21
8.8
46
Product Direction (% positive)
9.8
57
9.8
106
Features by Category
Not enough data
8.6
39
Data Source Access
Not enough data
8.8
35
Not enough data
9.2
37
Not enough data
8.6
30
Data Interaction
Not enough data
8.0
29
Not enough data
8.3
32
Not enough data
9.1
37
Not enough data
9.1
37
Not enough data
9.1
33
Not enough data
9.3
37
Not enough data
8.3
33
Not enough data
8.4
33
Data Exporting
Not enough data
8.4
33
Not enough data
8.5
32
Not enough data
9.3
34
Generative AI
Not enough data
6.1
19
Management
8.5
41
Feature Not Available
8.5
40
8.1
30
Functionality
9.1
43
Feature Not Available
9.3
43
9.3
36
9.4
40
Feature Not Available
9.2
43
9.4
32
9.3
41
9.2
30
Not enough data
8.7
42
Data Management
Not enough data
9.0
36
Not enough data
9.0
34
Not enough data
9.1
35
Not enough data
9.5
35
Agentic AI - DataOps Platforms
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Analytics
Not enough data
8.8
29
Not enough data
6.5
20
Monitoring and Management
Not enough data
8.6
30
Not enough data
8.9
37
Cloud Deployment
Not enough data
8.6
23
Not enough data
9.3
18
Generative AI
Not enough data
Not enough data
Not enough data
Not enough data
Data Warehouse AutomationHide 11 FeaturesShow 11 Features
Not enough data
8.9
34
Automation
Not enough data
8.8
30
Not enough data
8.4
28
Not enough data
8.9
32
Not enough data
Feature Not Available
Functionality
Not enough data
8.6
29
Not enough data
8.8
28
Not enough data
8.5
29
Administration
Not enough data
8.2
31
Not enough data
8.9
29
Not enough data
9.1
29
Agentic AI - Data Warehouse Automation
Not enough data
Not enough data
Not enough data
8.4
27
Data Transformation
Not enough data
7.9
20
Not enough data
9.2
26
Connectivity
Not enough data
7.9
16
Not enough data
8.3
16
Not enough data
8.3
22
Not enough data
8.5
19
Operations
Not enough data
Feature Not Available
Not enough data
9.5
25
Not enough data
8.5
20
Not enough data
8.4
18
Not enough data
8.1
19
Not enough data
8.0
37
Functionality
Not enough data
8.4
28
Not enough data
8.2
27
Not enough data
8.3
29
Not enough data
7.9
29
Not enough data
8.0
27
Management
Not enough data
8.0
28
Not enough data
9.5
32
Not enough data
8.8
29
Not enough data
8.0
30
Not enough data
8.3
33
Generative AI
Not enough data
6.1
16
Not enough data
6.4
16
Not enough data
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Azure Data Factory
Azure Data Factory
dbt
dbt
Azure Data Factory and dbt are categorized as ETL Tools and Big Data Integration Platforms
Unique Categories
Azure Data Factory
Azure Data Factory has no unique categories
Reviews
Reviewers' Company Size
Azure Data Factory
Azure Data Factory
Small-Business(50 or fewer emp.)
9.1%
Mid-Market(51-1000 emp.)
28.6%
Enterprise(> 1000 emp.)
62.3%
dbt
dbt
Small-Business(50 or fewer emp.)
23.2%
Mid-Market(51-1000 emp.)
60.1%
Enterprise(> 1000 emp.)
16.7%
Reviewers' Industry
Azure Data Factory
Azure Data Factory
Information Technology and Services
33.3%
Computer Software
14.1%
Financial Services
5.1%
Airlines/Aviation
5.1%
Retail
3.8%
Other
38.5%
dbt
dbt
Computer Software
17.9%
Information Technology and Services
14.9%
Financial Services
11.3%
Retail
5.4%
Marketing and Advertising
5.4%
Other
45.2%
Most Helpful Reviews
Azure Data Factory
Azure Data Factory
Most Helpful Favorable Review
Verified User
G
Verified User in Electrical/Electronic Manufacturing

It is mainly used to retrieve bulk data from various systems and integrate with different systems. Like the idea of using having pipelines and triggers. we use various types of triggers like blob and schedule triggers to make the pipeline run at predefined...

Most Helpful Critical Review
RJ
Ravindra J.
Verified User in Transportation/Trucking/Railroad

SOmetimes it becomes difficult to comprehend the errors due to which the data pipeline fails. Even after looking on internet doesn't help so may be the error message can be improved which helps users to comprehend and easily resolve it.

dbt
dbt
Most Helpful Favorable Review
Verified User
G
Verified User in Information Technology and Services

I love that we can document destinations and sources and automatically test the sources. We recently tried making dbt package and hopefully will soon bring it to production.

Most Helpful Critical Review
Verified User
G
Verified User in Computer Software

we can not able to load the data from source , we can only able to use data present in dataware houses, new users may face difficulties while learning, support also not that good from community

Alternatives
Azure Data Factory
Azure Data Factory Alternatives
SnapLogic Intelligent Integration Platform (IIP)
SnapLogic
Add SnapLogic Intelligent Integration Platform (IIP)
AWS Glue
AWS Glue
Add AWS Glue
Matillion
Matillion
Add Matillion
IBM DataStage
IBM DataStage
Add IBM DataStage
dbt
dbt Alternatives
Databricks Data Intelligence Platform
Databricks Data Intelligence Platform
Add Databricks Data Intelligence Platform
Alteryx
Alteryx
Add Alteryx
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
SnapLogic Intelligent Integration Platform (IIP)
SnapLogic
Add SnapLogic Intelligent Integration Platform (IIP)
Discussions
Azure Data Factory
Azure Data Factory Discussions
Is Azure data Factory an ETL tool?
1 comment
Dhiraj M.
DM
Yes Azure Data Factory is a No-Code ETL tool. Very easy to use.Read more
Monty the Mongoose crying
Azure Data Factory has no more discussions with answers
dbt
dbt Discussions
What is DBT tool used for?
2 comments
Ward W.
WW
I'm sorry, but it seems like the text you provided is not in an unknown language. It appears to be a reference to SQL (Structured Query Language) data...Read more
What is DBT data Modelling?
2 comments
Tyler H.
TH
dbt data modeling is not a thing. Dbt is a transformation tool that makes it easier to implement data modeling techniques like snowflake, data vault etc. Read more
What is DBT database tool?
1 comment
Skyler Y.
SY
DBT (DataBase Transformations) uses SQL select statements, with some added magic from Jinja templating language, to model and transform data. It's a highly...Read more