What users are saying about

dbt vs Fivetran

dbt
14 Ratings
Fivetran
25 Ratings

dbt

14 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.3 out of 100

Based on 14 reviews and ratings

Fivetran

25 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Based on 25 reviews and ratings

Feature Set Ratings

  • dbt (data build tool) ranks higher in 2 feature sets: Data Transformations, Data Modeling

Data Transformations

9.0

dbt

90%
8.0

Fivetran

80%
dbt (data build tool) ranks higher in 2/2 features
dbt (data build tool) ranks higher in 2/2 features

Simple transformations

9.0
90%
1 Rating
8.0
80%
6 Ratings

Complex transformations

9.0
90%
1 Rating
8.0
80%
4 Ratings

Data Modeling

8.2

dbt

82%
8.0

Fivetran

80%
dbt (data build tool) ranks higher in 4/6 features
dbt (data build tool) ranks higher in 4/6 features

Data model creation

9.0
90%
1 Rating
7.6
76%
6 Ratings

Metadata management

9.0
90%
1 Rating
9.0
90%
4 Ratings

Business rules and workflow

6.0
60%
1 Rating
6.3
63%
5 Ratings

Collaboration

9.0
90%
1 Rating
8.3
83%
4 Ratings

Testing and debugging

8.0
80%
1 Rating
7.9
79%
3 Ratings

feature 1

N/A
0 Ratings
9.0
90%
1 Rating

Data Source Connection

dbt

Feature Set Not Supported
N/A
8.0

Fivetran

80%
Fivetran ranks higher in 2/2 features
Fivetran ranks higher in 2/2 features

Connect to traditional data sources

N/A
0 Ratings
8.7
87%
7 Ratings

Connecto to Big Data and NoSQL

N/A
0 Ratings
7.4
74%
5 Ratings

Data Governance

dbt

Feature Set Not Supported
N/A
7.5

Fivetran

75%
Fivetran ranks higher in 2/2 features
Fivetran ranks higher in 2/2 features

Integration with data quality tools

N/A
0 Ratings
7.1
71%
5 Ratings

Integration with MDM tools

N/A
0 Ratings
8.0
80%
3 Ratings

Attribute Ratings

  • dbt (data build tool) and Fivetran are tied in 1 area: Likelihood to Recommend

Likelihood to Recommend

8.7

dbt

87%
3 Ratings
8.7

Fivetran

87%
8 Ratings

Usability

dbt

N/A
0 Ratings
9.0

Fivetran

90%
1 Rating

Performance

dbt

N/A
0 Ratings
8.0

Fivetran

80%
2 Ratings

Likelihood to Recommend

dbt

dbt (data build tool) has the capability to make your data models more accessible; other teams can read documentation, follow along the lineage, and even collaborate to make changes themselves dbt (data build tool) also has the capability to easily increase your database cost and write complex data models. The key to mitigating this risk is to adhere to best practices from the community and within your organization. Look to your data engineering teams to help guide scalable and efficient dbt (data build tool) processes and listen to your analysts for building well-documented and reusable data models.

Read full review

Obed Espina | TrustRadius Reviewer
Obed Espina
View all 3 answers on this topic

Fivetran

Mostly Fivetran can be useful for working with risk reduction operations during agile data analysis processes. I.e., in the short term the heaviest data movement operations would be safe. If you need to create an automated infrastructure for the data, the ability to create data list transformations in SQL is useful for keeping the work integrable or with schema changes. For situations that require a lot of speed: setting up the Fivetran platform is very easy, as you only need to authenticate the sources of the data to start working, and this is excellent for covering fast storage operations.

Read full review

Murray Clear | TrustRadius Reviewer
Murray Clear
View all 8 answers on this topic

Pros

dbt

  • Model creation and management.
  • Deployments and CI/CD.
  • Automatically generates documentation.

Read full review

Daniel Denunzio | TrustRadius Reviewer
Daniel Denunzio
View all 3 answers on this topic

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

Anonymous | TrustRadius Reviewer
Verified User
View all 8 answers on this topic

Cons

dbt

  • Ability to trigger alerts when a job fails

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 3 answers on this topic

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

Anonymous | TrustRadius Reviewer
Verified User
View all 8 answers on this topic

Pricing Details

dbt

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Starting Price

$0 per month per seat

dbt Editions & Modules

—
Additional Pricing Details
—

Fivetran

General

Free Trial
—
Free/Freemium Version
—
Premium Consulting/Integration Services
—
Entry-level set up fee?
No

Starting Price

$1 per credit

Fivetran Editions & Modules

Edition
Starter$1.001
Standard$1.501
Enterprise$2.001
  1. per credit
Additional Pricing Details
—

Usability

dbt

No score
No answers yet
No answers on this topic

Fivetran

Fivetran 9.0
Based on 1 answer
Just need to input connection info.

Read full review

Scott Laronge | TrustRadius Reviewer
Scott Laronge
View all 1 answers on this topic

Performance

dbt

No score
No answers yet
No answers on this topic

Fivetran

Fivetran 8.0
Based on 2 answers
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

Scott Laronge | TrustRadius Reviewer
Scott Laronge
View all 2 answers on this topic

Alternatives Considered

dbt

Airflow can accomplish the same work as dbt (data build tool), however, dbt's (data build tool) development workflow and UI can open up data transformation and modeling work to non-data engineering teams. Looker might also be able to define data models via LookML with a version control-like workflow. However, there's an added step here to learn LookML, compared to dbt (data build tool) which primarily relies on SQL (note: there is also Jinja so you could argue that you need to learn this too).

Read full review

Obed Espina | TrustRadius Reviewer
Obed Espina
View all 3 answers on this topic

Fivetran

Fivetran came well with the connectors' availability and updates with the source changes. We had an idea on data requirements in our case which helped us to work out on cost implication and take a decision for Fivetran as a data provider for our organization. These were 2 places where Fivetran out-performed, other vendors.

Read full review

Sudarshan Kothari | TrustRadius Reviewer
Sudarshan Kothari
View all 8 answers on this topic

Return on Investment

dbt

  • dbt has reduced our time to insight dramatically.
  • dbt has allowed us to leverage packages and analytics from our other vendors (Fivetran).
  • dbt has empowered our Analysts to build and manage their own models without adding more engineering resources.

Read full review

Daniel Denunzio | TrustRadius Reviewer
Daniel Denunzio
View all 3 answers on this topic

Fivetran

  • Development cost have reduced for each connector
  • The pay-per-use model is still not out their which requires lot of overhead cost

Read full review

Sudarshan Kothari | TrustRadius Reviewer
Sudarshan Kothari
View all 8 answers on this topic

Add comparison