Introducing G2.ai, the future of software buying.Try now
Compare Pentaho Data Integration and dbt 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
QuerySurge
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Astro by Astronomer
Visit Website
At a Glance
Market Segments
Mid-Market (41.2% of reviews)
Mid-Market (58.5% of reviews)
Entry-Level Pricing
No pricing available
No pricing available
Pentaho Data Integration
Star Rating
(17)4.3 out of 5
Market Segments
Mid-Market (41.2% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Pentaho Data Integrationdbt
Star Rating
(191)4.7 out of 5
Market Segments
Mid-Market (58.5% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Free Trial is available
Learn more about dbtSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Pentaho Data Integration excels in its breadth of data sources, scoring 8.7, which allows for seamless connectivity to various databases and applications. In contrast, dbt, while strong in data transformation, does not emphasize data source variety as much, leading to a more limited integration experience.
- Reviewers mention that dbt shines in its transformation capabilities, achieving a score of 9.4, which is significantly higher than Pentaho's 9.0. Users appreciate dbt's focus on SQL-based transformations, making it easier for data analysts to work with.
- G2 users highlight that Pentaho Data Integration offers robust automation features, scoring 9.4, which allows for efficient workflow management. Users report that this feature is particularly beneficial for organizations looking to streamline their ETL processes.
- Reviewers say that dbt's documentation management is highly rated at 8.7, making it easier for teams to collaborate and understand the data models. In comparison, Pentaho's documentation features are perceived as less user-friendly, which can hinder onboarding and usage.
- Users on G2 note that Pentaho Data Integration has a strong focus on data quality and cleansing, scoring 9.4, which is crucial for maintaining accurate datasets. dbt, while effective in transformation, does not emphasize data quality features to the same extent, leading to potential issues in data integrity.
- Reviewers mention that dbt's cloud migration capabilities are rated highly at 9.2, making it a preferred choice for organizations looking to transition to cloud-based data solutions. Pentaho, while offering hybrid cloud support, does not match dbt's ease of cloud integration, which can be a deciding factor for cloud-first companies.
Pricing
Entry-Level Pricing
Pentaho Data Integration
No pricing availabledbt
No pricing availableFree Trial
Pentaho Data Integration
No trial information availabledbt
Free Trial is available
Ratings
Meets Requirements
8.7
15
9.2
139
Ease of Use
8.6
15
9.0
141
Ease of Setup
8.0
9
8.6
80
Ease of Admin
8.6
7
8.5
58
Quality of Support
7.2
12
8.9
112
Has the product been a good partner in doing business?
8.6
6
8.8
52
Product Direction (% positive)
9.2
14
9.7
126
Features by Category
Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Self Service
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Analytics
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Data Source Access
Not enough data
8.8
48
Not enough data
9.2
50
Not enough data
8.6
41
Data Interaction
Not enough data
8.3
41
Not enough data
8.5
44
Not enough data
9.1
49
Not enough data
9.1
47
Not enough data
9.1
42
Not enough data
9.4
48
Not enough data
8.6
44
Not enough data
8.6
44
Data Exporting
Not enough data
8.5
42
Not enough data
8.6
43
Not enough data
9.1
45
Generative AI
Not enough data
6.5
27
Management
8.7
5
Feature Not Available
9.0
5
8.2
36
Functionality
9.7
5
Feature Not Available
9.7
5
9.2
41
9.3
5
Feature Not Available
8.3
5
9.4
38
8.7
5
9.2
36
Functionality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Agentic AI - Cloud Migration
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Functionality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Data Management
Not enough data
9.2
49
Not enough data
9.1
51
Not enough data
9.1
49
Not enough data
9.3
50
Agentic AI - DataOps Platforms
Not enough data
7.6
9
Not enough data
7.7
8
Not enough data
8.3
10
Not enough data
8.0
9
Not enough data
8.5
9
Analytics
Not enough data
8.7
47
Not enough data
7.3
35
Monitoring and Management
Not enough data
8.7
43
Not enough data
8.9
50
Cloud Deployment
Not enough data
8.7
37
Not enough data
8.8
30
Generative AI
Not enough data
5.9
13
Not enough data
6.3
13
Automation
Not enough data
8.8
34
Not enough data
8.3
32
Not enough data
8.6
35
Not enough data
Feature Not Available
Functionality
Not enough data
8.6
34
Not enough data
8.6
33
Not enough data
8.4
33
Administration
Not enough data
8.4
36
Not enough data
8.9
34
Not enough data
9.1
34
Agentic AI - Data Warehouse Automation
Not enough data
Not enough data
Deployment & Integration - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Connectivity & Federation - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Modeling & Metrics - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Performance Optimization - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Governance - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Intelligence - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Agentic AI Enablement - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Integrations
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Processing
Not enough data
Not enough data
Not enough data
Not enough data
Data Transformation
Not enough data
8.5
32
Not enough data
9.4
38
Connectivity
Not enough data
8.5
27
Not enough data
8.6
28
Not enough data
8.5
34
Not enough data
9.0
31
Operations
Not enough data
Feature Not Available
Not enough data
9.4
37
Not enough data
8.6
31
Not enough data
8.6
30
Not enough data
8.5
29
Functionality
Not enough data
8.7
38
Not enough data
8.4
36
Not enough data
8.6
38
Not enough data
8.2
38
Not enough data
8.4
36
Management
Not enough data
8.4
38
Not enough data
9.2
42
Not enough data
8.9
37
Not enough data
8.2
39
Not enough data
8.3
41
Generative AI
Not enough data
6.3
20
Not enough data
6.7
20
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Pentaho Data Integration and dbt are categorized as Big Data Integration Platforms and ETL Tools
Unique Categories
Pentaho Data Integration is categorized as Cloud Migration, On-Premise Data Integration, Data Mapping, and Big Data Processing and Distribution
dbt is categorized as Big Data Analytics, Data Preparation, Data Quality, Data Warehouse Automation, DataOps Platforms, and Semantic Layer Tools
Reviews
Reviewers' Company Size
Pentaho Data Integration
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
dbt
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
35.3%
Telecommunications
11.8%
Banking
11.8%
Internet
5.9%
Information Services
5.9%
Other
29.4%
Information Technology and Services
19.7%
Computer Software
16.5%
Financial Services
10.6%
Retail
4.8%
Marketing and Advertising
4.8%
Other
43.6%
Alternatives
Discussions
Pentaho Data Integration has no discussions with answers
What is DBT tool used for?
2 Comments
WW
SQL data transformations.Read more
What is DBT data Modelling?
2 Comments
TH
dbt data modeling is not a thing. Dbt is a transformation tool that makes it easier to implement data modeling techniques like snowflake, data vault etc. Read more
What is DBT database tool?
1 Comment
SY
DBT (DataBase Transformations) uses SQL select statements, with some added magic from Jinja templating language, to model and transform data. It's a highly...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
