dbt vs. Hevo Data

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
dbt
Score 9.1 out of 10
N/A
dbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.N/A
Hevo
Score 4.2 out of 10
N/A
Hevo Data is a no-code, bi-directional data pipeline platform specially built for modern ETL, ELT, and Reverse ETL Needs. It helps data teams streamline and automate org-wide data flows to save engineering time/week and drive faster reporting, analytics, and decision making. The platform supports 100+ ready-to-use integrations across Databases, SaaS Applications, Cloud Storage, SDKs, and Streaming Services. The platform boasts 500 data-driven companies spread across 35+…
$0
per month
Pricing
dbtHevo Data
Editions & Modules
No answers on this topic
Free
$0
per month
Starter
$149 to $999
Per Month (Paid Yearly)
Business
Custom Pricing
Offerings
Pricing Offerings
dbtHevo
Free Trial
YesYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsHevo offers a Free Plan and a 14-day Free Trial for all the paid plans.
More Pricing Information
Community Pulse
dbtHevo Data
Considered Both Products
dbt
Chose dbt
dbt is very flexible and can fit into most data pipelines. This is a pro for most organizations that aren't fully bought into one platform (Google Cloud, etc.)
Chose dbt
Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.
Chose dbt
I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT …
Chose dbt
Snaplogic is great at the Extraction and Load processes of ETL. It can pull data from anywhere, even behind firewalls. So if you need to get data from various APIs, databases, files, S3, SFTP, etc it is easy to do so. However, it requires special knowledge in order to build …
Chose dbt
I haven't come across anything like DBT before.
Chose dbt
Most ETL pipeline products have a T layer, but dbt just does it better. The transformation is on steroids compared to the others. Also, just allows much more Adhoc solutions for very specific projects. Those ETL tools are probably better on the T part if you don't need too many …
Chose 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 …
Chose dbt
dbt is great because of its transformation capabilities
Hevo
Chose Hevo
Fivetran is a really good product, but it is extremely pricey. Especially if you don't have dollar buying power in your country. If you don't require complex transforms and data governance tools then Hevo is much cheaper and probably a better fit for purpose product. …
Chose Hevo
Much lower cost and faster syncs but not as good support. More flexible in terms of pricing, though. Fivetran requires annual contracts and is very inflexible.
Features
dbtHevo Data
Data Transformations
Comparison of Data Transformations features of Product A and Product B
dbt
9.7
Ratings
18% above category average
Hevo Data
-
Ratings
Simple transformations10.00 Ratings00 Ratings
Complex transformations9.50 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
dbt
9.1
Ratings
15% above category average
Hevo Data
-
Ratings
Data model creation9.70 Ratings00 Ratings
Metadata management8.70 Ratings00 Ratings
Business rules and workflow9.00 Ratings00 Ratings
Collaboration10.00 Ratings00 Ratings
Testing and debugging8.00 Ratings00 Ratings
Best Alternatives
dbtHevo Data
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Astera Data Pipeline Builder (Centerprise)
Astera Data Pipeline Builder (Centerprise)
Score 8.7 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Control-M
Control-M
Score 9.3 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
dbtHevo Data
Likelihood to Recommend
10.0
(0 ratings)
8.8
(0 ratings)
Usability
9.7
(0 ratings)
-
(0 ratings)
User Testimonials
dbtHevo Data
Likelihood to Recommend
dbt (Data Build Tool) is best suited for doing the data transformation. dbt is just a transformation tool and it is not suitable for building a data pipeline which requires extraction of data and loading. dbt is well suited for SQL based transformation logic and it is less appropriate when transformation logic requires python.
Read full review
Hevo Data is professionally sound in data management and credible analytical processes, where there is proper sourcing and data connectivity, from the different sources. Further, Hevo Data brings huge transformation and analytical approaches, which increases the viability of every operation in the company, and results are credibly issued. The integration that Hevo Data provides is comprehensively sound, and it gives quality coordination.
Read full review
Pros
  • user experience makes it easy to work with SQL and version control
  • customer success team and the dbt (data build tool) community help establish best practices
  • thorough and clear documentation
Read full review
  • 5 Minute Sync with Salesforce
  • Transformations
  • Auto Schema Mapping
  • Push to Salesforce
Read full review
Cons
  • Slow load times of the dbt cloud environment (they're working on it via a new UI though)
  • More out-of-the-box solutions for managing procedures, functions, etc would be nice to have, but honestly, it's pretty easy to figure out how to adapt dbt macros
Read full review
  • If we are getting data from other sheets then sheet which is connected to Hevo Data doesn't updates in real-time.
  • Hevo Data change time in it's workbench on its own. For e.g. If our database timestamp is in UTC format then Hevo Data will automatically change the time to IST but if I run the same code outside the Hevo Data workbench then time is still in UTC. This creates lots of confusion while working on Hevo Data.
Read full review
Usability
dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.
Read full review
No answers on this topic
Alternatives Considered
Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.
Read full review
1. Cost efficient 2. Creation of automated pipeline 3. Can load data from multiple data sources 4. Updates data in near real-time - We were able to get near real time insights from the data model which we have created in hevo 5. It has good integration with different BI tools
Read full review
Return on Investment
  • In 3 months we re-wrote the data warehouse (15-20 sources) in dbt with 3 developers.
  • We are using it continually for the past year with no issues.
  • Sorry, I don't have ROI numbers but the impact was huge.
Read full review
  • Increased Time
  • Decreased Failures
  • Increased User Happiness
Read full review
ScreenShots

Hevo Screenshots

Screenshot of TransformationsScreenshot of Pipeline OverviewScreenshot of Schema MapperScreenshot of Select Source TypeScreenshot of Query EditorScreenshot of Transformations