Fivetran vs dbt comparison

Read 27 Fivetran reviews

3,228 Views
2,319 Comparison Views

89% willing to recommend

dbt

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

Fivetran and dbt compete in the data management category, with Fivetran focusing on data integration and dbt on data transformation. dbt has a slight advantage due to its robust feature set and in-depth data modeling capabilities.

Features: Fivetran offers seamless data integration, automated data pipelines, and reliable data movement. dbt provides advanced data transformation, complex data modeling, and powerful version control and testing capabilities.

Ease of Deployment and Customer Service: Fivetran emphasizes ease of deployment with minimal setup and extensive support during integration. dbt requires a more complex setup but offers detailed documentation and strong community support.

Pricing and ROI: Fivetran offers an attractive pricing model beneficial for simple data integration tasks, providing clear ROI through time savings. dbt, while higher in initial cost due to setup complexity, offers significant ROI in terms of data precision and transformation.

To learn more, read our detailed Fivetran vs. dbt Report (Updated: April 2025).

Download the complete report

Fivetran vs. dbt

April 2025

Helped 850,028 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

dbt

Ranking in Data Integration

38th

Average Rating

7.6

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

Fivetran

Ranking in Data Integration

12th

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Replication (3rd), Cloud Data Integration (8th)

Featured Reviews

Ninad Magdum

Senior Machine Learning Engineer at Happiest Minds Technologies

Developer-friendly and easy to use, but doesn't have many optimization options

We also use stored procedures and Talend. They are not replaced by dbt completely. We use dbt only for the transformation process. My recommendations would depend on an organization’s requirements and problems. I will recommend the tool to others. The product is developer-friendly. However, it is still dependent on the data warehouse for big data and optimization. It's just a SQL transformation tool. It doesn't have a lot of optimization options like Spark. It's a good tool for Snowflake. If it were only for Snowflake, I would have rated it an eight out of ten. However, there are other data platforms. Overall, I rate the tool a six and a half out of ten.

Read full review

Mediha Šiljić

Lead Data Engineer at Sensilab

Built-in connectors offer extensive data source integration and time savings

Fivetran could improve by adapting more for technical users and by providing more options for such users. There should be more adaptability in terms of new features. If a specific feature is required, it should be integrated promptly. Improvement in existing connectors with new features is desirable. Enhancements around customer-focused product adaptation are also suggested.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The product is developer-friendly."

"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."

"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,."

"Overall, I would rate Fivetran nine out of ten."

"The portal is very intuitive and easy to use."

"The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."

"Making the decision to implement Fivetran was supported by the fact that they have better connectors than other competitors."

"The simplicity and scalability are the strongest features of Fivetran."

"You can manage all of your connectors individually, which gives you a very good ability to trace which one of your ETL processes is running and when."

More Fivetran pros

Cons

"The solution must add more Python-based implementations."

"The connections with SAP must be improved."

"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."

"The environment must be more development-friendly."

"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 documentation is decent, but it's hard to find information online about Fivetran. For example, if you try to search for an error code, you won't find much information about it in forums."

"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."

"There is not a lot of options to customize the pipeline, and the cost is high."

"Fivetran could improve in the area of customization, especially in how they socialize their tools."

More Fivetran cons

Pricing and Cost Advice

"The solution’s pricing is affordable."

"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."

"When you have a lot of workflows and complex use cases, pricing goes down as you use it more."

"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 rate the pricing a six out of ten."

"The pricing model is okay and mid to large companies will not have an issue with it."

"The solution is affordable."

"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."

More Fivetran pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

850,028 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Insurance Company

13%

Computer Software Company

Healthcare Company

Educational Organization

24%

Computer Software Company

12%

Financial Services Firm

12%

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What is your experience regarding pricing and costs for dbt?

It is cheap because dbt is open source. If you compare the pay-per-service of Dbt with the open source option you can manage. We are managing the solution, when we were acquiring service from them....

What needs improvement with dbt?

SQL statements that beyond DML, are not possible. Currently, they are not possible in Dbt. Having more features in SQL statements will support us. Another issue is the terms of data ingestion becau...

What is your primary use case for dbt?

We use the solution to deal with data transformations inside different organizations.

What's the deal with the HVR software acquisition?

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 som...

Does HVR Software provide reliable insights?

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 ...

How much traffic can HVR Software handle?

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 Softwar...

Informatica PowerCenter vs dbt

Comparisons

SSIS vs dbt

Compared 30% of the time

Compared 15% of the time

Tobiko vs dbt

Compared 8% of the time

Palantir Foundry vs dbt

Compared 7% of the time

Rivery vs dbt

Compared 7% of the time

More dbt Competitors

AWS Database Migration Service vs Fivetran

Compared 15% of the time

Oracle GoldenGate vs Fivetran

Compared 14% of the time

Qlik Replicate vs Fivetran

Compared 8% of the time

Azure Data Factory vs Fivetran

Compared 6% of the time

AWS Glue vs Fivetran

Compared 5% of the time

More Fivetran Competitors

Product Reports

Download dbt product report

Data Integration

March 2025

Download Fivetran product report

April 2025

Overview

dbt is a transformational tool that empowers data teams to quickly build trusted data models, providing a shared language for analysts and engineering teams. Its flexibility and robust feature set make it a popular choice for modern data teams seeking efficiency.

Designed to integrate seamlessly with the data warehouse, dbt enables analytics engineers to transform raw data into reliable datasets for analysis. Its SQL-centric approach reduces the learning curve for users familiar with it, allowing powerful transformations and data modeling without needing a custom backend. While widely beneficial, dbt could improve in areas like version management and support for complex transformations out of the box.

What are the most valuable features of dbt?

SQL-Based Development: Facilitates transformations using SQL, streamlining the data modeling process.
Modularity: Encourages reusable components, making projects easier to manage and scale.
Version Control: Integrates with version control systems to track changes and collaborate effectively.
Testing Framework: Ensures data quality through automated tests, increasing trust in data outputs.

What benefits should you expect from using dbt?

Efficiency: Cuts down data processing times, allowing faster access to insights.
Collaboration: Promotes teamwork through shared data models and a common working language.
Scalability: Supports growing data demands by transforming complex data more flexibly and modularly.
Transparency: Provides clear documentation and lineage tracking, aiding in troubleshooting and understanding.

In the finance industry, dbt helps in cleansing and preparing transactional data for analysis, leading to more accurate financial reporting. In e-commerce, it empowers teams to rapidly integrate and analyze customer behavior data, optimizing marketing strategies and improving user experience.

dbt Labs

Fivetran, the global leader in data movement, is trusted by companies like OpenAI, LVMH, Pfizer, Verizon and Spotify to centralize data from SaaS applications, databases, files, and other sources into cloud destinations, including data lakes. With high-performance pipelines, seamless interoperability, and enterprise-grade security, Fivetran empowers organizations to modernize their data infrastructure, power analytics and AI, ensure compliance, and achieve transformative business outcomes. Learn more at Fivetran.com

Sample Customers

Information Not Available

Autodesk, Condé Nast, JetBlue, Morgan Stanley, OpenAI, LVMH, Pfizer, Verizon, SpotifyNational Australia Bank, Saks, Cemex, Okta, Dropbox, Pitney Bowes, World Fuel Services,Lufthansa, AutoZone, ASICS, ASOS, Coupa, Databricks, Hermes, New Relic, Intercom,Canva, Honeywell, Square, DocuSign, Nandos, Oldcastle Infrastructure