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
Talend Open Studio
Score 9.0 out of 10
N/A
Talend Open Studio is an open source integration software, used to build basic data pipelines or execute simple ETL and data integration tasks, get graphical profiles of data, and manage files from a locally installed, open-source environment.
N/A
Pricing
dbt
Talend Open Studio
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
dbt
Talend Open Studio
Free Trial
Yes
No
Free/Freemium Version
Yes
Yes
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
dbt
Talend Open Studio
Features
dbt
Talend Open Studio
Data Transformations
Comparison of Data Transformations features of Product A and Product B
dbt
9.5
Ratings
15% above category average
Talend Open Studio
7.0
Ratings
15% below category average
Simple transformations
10.00 Ratings
6.00 Ratings
Complex transformations
9.00 Ratings
7.90 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
dbt
9.0
Ratings
12% above category average
Talend Open Studio
7.5
Ratings
6% below category average
Data model creation
9.50 Ratings
6.90 Ratings
Metadata management
8.50 Ratings
7.90 Ratings
Business rules and workflow
9.00 Ratings
6.90 Ratings
Collaboration
10.00 Ratings
7.00 Ratings
Testing and debugging
8.00 Ratings
8.90 Ratings
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
dbt
-
Ratings
Talend Open Studio
7.5
Ratings
11% below category average
Connect to traditional data sources
00 Ratings
7.00 Ratings
Connecto to Big Data and NoSQL
00 Ratings
7.90 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.
It is certainly suitable for agile and innovative projects. For developments that require particular steps and with a simple debug. On the other hand, it is not very suitable for producing flows that move large amounts of data and that require a lot of resources and great stability.
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
The community is not that up to date and forum is not that great in response. Probably we should make people aware of the tool more on how to use and its implementations.
Talend crashes when transforming a lot of data (millions of rows).
Proper training documentation is a must for talend which is currently lagging. This will help users to learn more about Talend and use it effectively.
There is no licence requirement for Talend Open Studio. So, this is not relevant question. However, if you are asking whether we will use Talend in future. Yes. We will continue to use it. It's very powerful free tool which caters to all our extra, transform, load capabilities. We just love Talend for it's great functionality and ease of use.
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.
Talend Open Studio is based on Eclipse and is full of redundant procedures to do one thing, like when installing libraries. Sometimes I cannot manually download the libraries that it can't find.
Many times, Talend freezes. When you give a cancel command, it takes several minutes to stop. It also takes a great toll on our PC with 16 GB of ram and I7 CPU, even in idle status. If you are downloading Maven Jar/Libraries, you cannot do anything and have to wait until the task is finished.
There is only one support staff on a forum created by Talend, which hides behind a nickname and does not show his name. They only ask base questions like: -Talend version - Are you in a proxy? -Do you have all the libraries installed? -It is a Jar missing? (how could I know?) -Follow this link on our site or "please ask your administrators" They then wash their hands of my issues.
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.
Informatica has a limited number of components that you can use. This places a heavy limitation on the capabilities of Informatica. On the other hand, Talend allows you to create your own custom components using Java. For businesses that need to perform a wide variety of data operations, it can be quite useful to have the option of creating your own custom components to satisfy business needs.
