CloverDX vs. dbt

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
CloverDX
Score 9.0 out of 10
N/A
CloverDX is a rapid, end-to-end data integration solution. The vendor states that businesses choose CloverDX for its usability and intuitive controls, along with its lightweight footprint, flexibility, and processing speed. Achieving true, rapid data integration means much more than just raw data processing power. Rapid refers to an end-to-end process that begins the moment a data-related problem is recognized to the point when the data is in the right place and form to be analyzed and…N/A
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
Pricing
CloverDXdbt
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
CloverDXdbt
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
CloverDXdbt
Considered Both Products
CloverDX
Chose CloverDX
CloverDX was a less expensive alternative to Talend and had a more intuitive interface from what I could see during the evaluation.
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
Features
CloverDXdbt
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
CloverDX
9.0
Ratings
8% above category average
dbt
-
Ratings
Connect to traditional data sources9.00 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
CloverDX
8.5
Ratings
5% above category average
dbt
9.7
Ratings
18% above category average
Simple transformations9.00 Ratings10.00 Ratings
Complex transformations8.00 Ratings9.50 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
CloverDX
8.0
Ratings
2% above category average
dbt
9.1
Ratings
15% above category average
Data model creation8.00 Ratings9.70 Ratings
Metadata management8.00 Ratings8.70 Ratings
Business rules and workflow8.00 Ratings9.00 Ratings
Collaboration00 Ratings10.00 Ratings
Testing and debugging00 Ratings8.00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
CloverDX
8.0
Ratings
0% below category average
dbt
-
Ratings
Integration with data quality tools8.00 Ratings00 Ratings
Best Alternatives
CloverDXdbt
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
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
CloverDXdbt
Likelihood to Recommend
9.0
(0 ratings)
10.0
(0 ratings)
Likelihood to Renew
9.0
(0 ratings)
-
(0 ratings)
Usability
-
(0 ratings)
9.7
(0 ratings)
Support Rating
9.0
(0 ratings)
-
(0 ratings)
User Testimonials
CloverDXdbt
Likelihood to Recommend
CloverDX designer as a standalone is well suited for fairly straightforward transformations of data. If you want to do large scale data integrations, then their server edition adds an extra level of automation and job control.
Read full review
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
Pros
  • Connects with Salesforce very well
  • The graphical view of the transformations allows for easy creations and maintenance
  • Support has always been eager to assist with any graph creation difficulties I run into
Read full review
  • 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
Cons
  • The initial learning curve is a little steep. Not very steep or super steep, just a little steep.
  • Having enough memory for large multi-step problems can be an issue if the graph isn't designed well.
Read full review
  • 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
Usability
No answers on this topic
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
Support Rating
While CloverDX has an active forum for users to submit questions and assist with answers, their in house support team is incredibly responsive when I've contacted them for assistance. This seems almost at odds with most other software companies who try to save money on tech support by promoting a forum or knowledge base.
Read full review
No answers on this topic
Alternatives Considered
CloverDX was a less expensive alternative to Talend and had a more intuitive interface from what I could see during the evaluation.
Read full review
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
Return on Investment
  • Work that use to take multiple people 20 to 30 hours a week to complete each has now been fully automated to where only 1 or 2 hours a week for maintenance is required.
Read full review
  • 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
ScreenShots

CloverDX Screenshots

Screenshot of