Try our new research platform with insights from 80,000+ expert users

Dremio vs Pentaho Business Analytics comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.7
Dremio reduces costs and saves time by minimizing personnel needs and simplifying data management across multiple sources.
Sentiment score
5.4
Pentaho Business Analytics mixed ROI perceptions highlight efficiency gains but unclear returns compared to competitors like QlikView and Tableau.
Dremio surely saves time, reduces costs, and all those things because we don't have to worry so much about the infrastructure to make the different tools communicate.
 

Customer Service

Sentiment score
5.2
Dremio offers responsive customer service, with professional services for complex issues, yet growth raises staffing level concerns.
Sentiment score
6.5
Pentaho Business Analytics receives mixed reviews for customer support, with users relying heavily on forums and community assistance.
We have had to reach out for customer support many times, and they respond, so they are pretty supportive about some long-term issues.
 

Scalability Issues

Sentiment score
7.3
Dremio is highly scalable, commendably handling extensive data and user growth, with integrations like Docker and Kubernetes.
Sentiment score
7.0
Pentaho Business Analytics is scalable with good performance but occasionally needs professional help for complex data handling.
Dremio's scalability can handle growing data and user demands easily.
Internally, if it's on Docker or Kubernetes, scalability will be built into the system.
 

Stability Issues

Sentiment score
7.1
Dremio is generally stable with occasional issues; users praise its core functionality but recommend regular monitoring for optimal performance.
Sentiment score
6.5
Pentaho Business Analytics is stable but may face Java caching issues, impacting performance and requiring careful cache management.
I rate Dremio a nine in terms of stability.
It can handle large datasets.
 

Room For Improvement

Dremio suffers from poor SQL tools, documentation, and support, with limited connectors and expensive licensing adding to user concerns.
Pentaho Business Analytics lacks an intuitive interface, robust integration, self-service features, and requires technical expertise, limiting usability.
Starburst comes with around 50 connectors now.
I see that many times the new versions of Dremio have not fixed old bugs, and in some new versions, old problems that were previously fixed come back again, so I think the upgrade part could use improvement.
It should be easier to get Arctic or an open-source version of Arctic onto the software version so that development teams can experiment with it.
Pentaho Business Analytics is hard to learn and not suited for initial users as it requires knowledge of operating systems, Java, and other technical skills.
 

Setup Cost

Enterprise users find Dremio costly at $200,000 monthly, with high licensing expenses when scaling beyond the community version.
Enterprise buyers find the free Pentaho Community Edition cost-effective, while the Enterprise Edition offers value with support and features.
Pentaho Business Analytics is priced similarly to other competitors such as QlikView and Tableau.
 

Valuable Features

Dremio excels at managing large datasets with VDS, data lineage, role-based access, and seamless API integrations for enhanced scalability.
Pentaho Business Analytics provides easy data integration, customizable dashboards, extensive connectivity, and supports efficient data transformation and delivery.
Having everything under one system and an easier-to-work-with interface, along with having API integrations, adds significant value to working with Dremio.
You just get the source, connect the data, get visualization, get connected, and do whatever you want.
The first feature that stands out for me in Dremio is the federated type of query, which allows the possibility to use multiple endpoints without worrying about writing custom SQL that runs only for SQL Server or for Postgres and Redshift.
It is a stable product, and it can handle large datasets.
 

Categories and Ranking

Dremio
Average Rating
8.4
Reviews Sentiment
6.8
Number of Reviews
10
Ranking in other categories
Cloud Data Warehouse (6th), Data Science Platforms (11th)
Pentaho Business Analytics
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
45
Ranking in other categories
BI (Business Intelligence) Tools (20th), Cloud Operations Analytics (2nd), Reporting (12th)
 

Mindshare comparison

While both are Business Intelligence solutions, they serve different purposes. Dremio is designed for Data Science Platforms and holds a mindshare of 2.9%, down 4.1% compared to last year.
Pentaho Business Analytics, on the other hand, focuses on BI (Business Intelligence) Tools, holds 0.5% mindshare, down 0.6% since last year.
Data Science Platforms Market Share Distribution
ProductMarket Share (%)
Dremio2.9%
Databricks12.3%
KNIME Business Hub11.2%
Other73.6%
Data Science Platforms
BI (Business Intelligence) Tools Market Share Distribution
ProductMarket Share (%)
Pentaho Business Analytics0.5%
Microsoft Power BI12.7%
Tableau Enterprise9.2%
Other77.6%
BI (Business Intelligence) Tools
 

Featured Reviews

Corrr Moray - PeerSpot reviewer
Has simplified complex data integration workflows and supported consistent reporting across multiple sources
We also have a close relationship with the team that does the Dremio maintenance for the database, like upgrading the versions and they know about some specific problems we had in the past, such as a memory leak. We had a memory leak on some versions, which sometimes stopped the service. Since we are using Dremio installed like a server, not a SaaS solution, many times we need to stop and restart the service to clear all the cache and all that, and this is the thing I should add. I see that many times the new versions of Dremio have not fixed old bugs, and in some new versions, old problems that were previously fixed come back again, so I think the upgrade part could use improvement. I remember using some features in the past, like pivot tables, which proved to be really difficult, but I know this is a fault also for other vendors. Pivoting, transposing, and unpivoting are often not so good. CTEs also many times prove to be not so good, so I think these two main items could be improved significantly if they standardize them.
Mir Gulzar Ahmed - PeerSpot reviewer
Excels in handling unstructured data, helping organizations navigate through different storage systems
Pentaho can help organizations by providing them an insight of their unstructured data using one platform(Pentaho Business Analytics). The features are almost identical to other BIS platforms but to me, customers can benefit as it has a community version with most of its Enterprise features. It also has a free limited-period trial version. The other feature that I would like to share here is, that users have access to a complete spectrum of data from different sources with the system’s adaptive big data layer, which takes the source of the data into account. The software is built on an open architecture and can be integrated with multiple systems. However, Pentaho Data Integration and Analytics has been acquired by HDS which offers an Enterprise edition for organizations that also need to meet product compliance.
report
Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
873,085 professionals have used our research since 2012.
 

Comparison Review

it_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

Top Industries

By visitors reading reviews
Financial Services Firm
28%
Computer Software Company
9%
Manufacturing Company
6%
Healthcare Company
5%
Financial Services Firm
13%
Computer Software Company
10%
Manufacturing Company
7%
Educational Organization
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business1
Midsize Enterprise5
Large Enterprise5
By reviewers
Company SizeCount
Small Business22
Midsize Enterprise7
Large Enterprise15
 

Questions from the Community

What do you like most about Dremio?
Dremio allows querying the files I have on my block storage or object storage.
What is your experience regarding pricing and costs for Dremio?
The licensing is very expensive. We need a license to scale as we are currently using the community version.
What needs improvement with Dremio?
Dremio could be improved by making it easier for data cataloging, especially when working with open table formats, as you have to choose a data format and then go into it. With the Dremio software ...
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
Pentaho Business Analytics offers the best value for money. While improvements can be made in some areas, particularly with more cloud-based solutions, it is not in their domain because they do not...
What needs improvement with Pentaho Business Analytics?
From an integration perspective, Pentaho Business Analytics is not the best tool on the market. There are things done by Apache that are better, though I am not the one implementing them, so this i...
 

Also Known As

No data available
Pentaho, Kettle, Hitachi Pentaho Business Analytics
 

Overview

 

Sample Customers

UBS, TransUnion, Quantium, Daimler, OVH
Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Find out what your peers are saying about Databricks, Amazon Web Services (AWS), Knime and others in Data Science Platforms. Updated: October 2025.
873,085 professionals have used our research since 2012.