Introducing G2.ai, the future of software buying.Try now
Compare Dremio and Pentaho Data Integration 
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.
Starburst
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
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.
Kpow for Apache Kafka®
Visit Website
At a Glance
Market Segments
Enterprise (47.6% of reviews)
Mid-Market (41.2% of reviews)
Entry-Level Pricing
No pricing available
No pricing available
Dremio
Star Rating
(69)4.6 out of 5
Market Segments
Enterprise (47.6% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about DremioPentaho 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 IntegrationSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Dremio excels in data lake integration, with a score of 9.1, allowing seamless access to various data sources, while Pentaho Data Integration, with a score of 8.6, offers solid integration capabilities but may require more manual setup for complex data lakes.
- Reviewers mention that Dremio's real-time data querying feature, rated at 9.2, significantly enhances performance for analytics, whereas Pentaho's real-time analytics capabilities, rated at 7.0, may not meet the needs of users requiring immediate insights.
- G2 users highlight Dremio's ease of use, scoring 9.1, which simplifies the onboarding process for new users, while Pentaho Data Integration, with a score of 8.6, is noted for its steeper learning curve, particularly in data transformation tasks.
- Users on G2 appreciate Dremio's built-in data analytics features, rated at 7.6, which streamline the analytics process, while Pentaho's data quality management, scoring 8.2, is praised for its robust data cleansing capabilities but lacks the same level of integrated analytics.
- Reviewers say that Dremio's cloud processing capabilities, rated at 9.3, provide excellent scalability for growing data needs, while Pentaho's cloud deployment, with a score of 8.5, is effective but may not scale as efficiently under heavy workloads.
- Users report that Dremio's user, role, and access management features are robust, enhancing security and governance, while Pentaho's data governance, rated at 8.1, is effective but may require additional configuration to achieve similar levels of security and compliance.
Pricing
Entry-Level Pricing
Dremio
No pricing availablePentaho Data Integration
No pricing availableFree Trial
Dremio
Free Trial is available
Pentaho Data Integration
No trial information availableRatings
Meets Requirements
8.7
52
8.7
15
Ease of Use
9.2
53
8.6
15
Ease of Setup
8.4
47
8.0
9
Ease of Admin
7.8
29
8.6
7
Quality of Support
8.5
50
7.2
12
Has the product been a good partner in doing business?
9.1
28
8.6
6
Product Direction (% positive)
9.7
46
9.2
14
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
Management
Not enough data
8.7
5
Not enough data
9.0
5
Functionality
Not enough data
9.7
5
Not enough data
9.7
5
Not enough data
9.3
5
Not enough data
8.3
5
Not enough data
8.7
5
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
8.6
23
Not enough data
8.5
20
Not enough data
8.3
12
Not enough data
7.7
20
Not enough data
Feature Not Available
Not enough data
8.9
23
Not enough data
Integration
Feature Not Available
Not enough data
8.8
21
Not enough data
9.0
22
Not enough data
Deployment
8.7
15
Not enough data
8.5
19
Not enough data
Performance
8.3
21
Not enough data
Security
8.2
20
Not enough data
Feature Not Available
Not enough data
Generative AI
6.9
12
Not enough data
Not enough data
Not enough data
Data Management
8.6
11
Not enough data
8.8
11
Not enough data
Feature Not Available
Not enough data
Data as a Service
7.6
11
Not enough data
8.2
11
Not enough data
Architecture
8.2
11
Not enough data
8.6
11
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
Feature Not Available
Not enough data
Feature Not Available
Not enough data
Feature Not Available
Not enough data
Integrations
9.0
18
Not enough data
7.9
13
Not enough data
Platform
9.1
20
Not enough data
8.7
13
Not enough data
7.9
13
Not enough data
Processing
9.1
18
Not enough data
8.6
13
Not enough data
Data Transformation
Feature Not Available
Not enough data
9.2
24
Not enough data
Connectivity
8.6
22
Not enough data
Feature Not Available
Not enough data
8.9
23
Not enough data
8.9
25
Not enough data
Operations
7.2
25
Not enough data
7.1
25
Not enough data
7.8
27
Not enough data
7.7
21
Not enough data
7.0
21
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
Categories
Categories
Shared Categories
Dremio and Pentaho Data Integration are categorized as Big Data Processing and Distribution
Unique Categories
Dremio is categorized as Big Data Analytics, Data Warehouse, Data as a Service (DaaS), and Semantic Layer Tools
Pentaho Data Integration is categorized as Cloud Migration, Big Data Integration Platforms, ETL Tools, On-Premise Data Integration, and Data Mapping
Reviews
Reviewers' Company Size
Dremio
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Pentaho Data Integration
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
Financial Services
23.8%
Information Technology and Services
11.1%
Computer Software
7.9%
Marketing and Advertising
4.8%
Automotive
4.8%
Other
47.6%
Information Technology and Services
35.3%
Telecommunications
11.8%
Banking
11.8%
Internet
5.9%
Information Services
5.9%
Other
29.4%
Alternatives
Discussions
What is a Dremio reflection?
1 Comment
Official Response from Dremio
A reflection is an optimized materialization of source data or a query, similar to a materialized view, that is derived from an existing table or view. A...Read more
Dremio has no more discussions with answers
Pentaho Data Integration has no discussions with answers
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.
