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
IBM DataStage
Score 7.6 out of 10
N/A
IBM® DataStage® is a data integration tool that helps users to design, develop and run jobs that move and transform data. At its core, the DataStage tool supports extract, transform and load (ETL) and extract, load and transform (ELT) patterns. A basic version of the software is available for on-premises deployment, and the cloud-based DataStage for IBM Cloud Pak® for Data offers automated integration capabilities in a hybrid or multicloud environment.
N/A
Pricing
dbt
IBM DataStage
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
dbt
IBM DataStage
Free Trial
Yes
Yes
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
dbt
IBM DataStage
Features
dbt
IBM DataStage
Data Transformations
Comparison of Data Transformations features of Product A and Product B
dbt
9.5
Ratings
15% above category average
IBM DataStage
8.0
Ratings
2% below category average
Simple transformations
10.00 Ratings
8.00 Ratings
Complex transformations
9.00 Ratings
8.00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
dbt
9.0
Ratings
12% above category average
IBM DataStage
6.3
Ratings
23% below category average
Data model creation
9.50 Ratings
5.00 Ratings
Metadata management
8.50 Ratings
5.00 Ratings
Business rules and workflow
9.00 Ratings
6.00 Ratings
Collaboration
10.00 Ratings
6.00 Ratings
Testing and debugging
8.00 Ratings
6.00 Ratings
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
dbt
-
Ratings
IBM DataStage
9.5
Ratings
12% above category average
Connect to traditional data sources
00 Ratings
10.00 Ratings
Connecto to Big Data and NoSQL
00 Ratings
9.00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
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.
Excellent Cloud data mapping tool and easy creating multiple project data analytics in real-time and the report distribution are excellent via this IBM product. Easy tool to provide data visualization and the integration is effective and helpful to migrating huge amounts of data across other platforms and different websites insights gathering.
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
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.
Because it is a flexible tool that can manage many flows and create a strong solution with a interesting use of variables. Easy to scale up as you can copy jobs arleady build and modify them. SQL queries allow to be fast in development and have the pushdown feature, but you loose a little of user friendly look. Metadata management is not strong as a visual feature, but can be determine by job codes.
It could load thousands of records in seconds. But in the Parallel version, you need to understand how to particionate the data. If you use the algorithms erroneously, or the functionalities that it gives for the parsing of data, the performance can fall drastically, even with few records. It is necessary to have people with experience to be able to determine which algorithm to use and understand why.
IBM offers different levels of support but in my experience being and IBM shop helps to get direct support from more knowledgeable technicians from IBM. Not sure on the cost of having this kind of support, but I know there's also general support and community blogs and websites on the Internet make it easy to troubleshoot issues whenever there's need for that.
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.
No, it wasn’t my decision to use such an ETL product. I’m just the administrator at this point. I’ve heard there are other products there that are even on cloud support. That is much easier to use, more agile, and user-friendly. That doesn’t have that barrier from user to administrator to the developer standpoint.
Not directly related to ROI or cost figures. Only comment here is that IBM tools tend to be more costly than average ETL tools, but it depends on if the company is an IBM shop.
One positive aspect is the company has had not a need to switch ETL tool for years.
Upgrading to newer versions of the tool brings flexibility in the tool and up-to-date features in relation to other applications.
