Pentaho

Pentaho

Score 8.1 out of 10
Pentaho

Overview

What is Pentaho?

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.
Read more

Recent Reviews

Read all reviews

Popular Features

View all 28 features
  • Multi-User Support (named login) (21)
    9.1
    91%
  • Role-Based Security Model (20)
    8.8
    88%
  • Formatting capabilities (20)
    8.4
    84%
  • Publish to PDF (20)
    7.7
    77%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Pentaho, and make your voice heard!

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Pentaho?

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

47 people want pricing too

Alternatives Pricing

What is Microsoft Power BI?

Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

What is SAP Analytics Cloud?

The SAP Analytics Cloud solution brings together analytics and planning with integration to SAP applications and access to heterogenous data sources. As the analytics and planning solution within SAP Business Technology Platform, SAP Analytics Cloud supports trusted insights and integrated planning…

Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

8.6Avg 8.1

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

8.7Avg 8.0

Report Output and Scheduling

Ability to schedule and manager report output.

8.8Avg 8.3

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for pattern and outliers and the ability to represent the data visually.

8.4Avg 8.1

Access Control and Security

Access control means being able to determine who has access to which data.

8.8Avg 8.5

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

8.6Avg 7.9

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

8.6Avg 7.9
Return to navigation

Product Details

What is Pentaho?

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Pentaho Integrations

Pentaho Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Reviewers rate Responsive Design for Web Access highest, with a score of 9.6.

The most common users of Pentaho are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

(1-25 of 32)
Companies can't remove reviews or game the system. Here's why
Harsh Gangwar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I used Pentaho as an ETL tool to extract data from different data sources and created data marts for reporting and descriptive analytics on top of the historical data. We created Pentaho jobs, managed them, and also provided support over time, It helped businesses to identify the performance of different airports' lounges and passengers' credibility. Based on historical trends from the data, we offered a few attractive discounts to access lounge at the several airports.
Score 9 out of 10
Vetted Review
Verified User
We use Pentaho to store, collaborate & present data in a more modular form, which in turn helps us in making better business decisions & also allows end-users to navigate through complex data tables in a comfortable & easy manner. Pentaho not only helps in loading up the required data quickly, but it also helps in making sure the data is well structured & presented in a simple way.
Score 10 out of 10
Vetted Review
Verified User
I use Pentaho for reporting and dashboard development. We develop the reports and integrate them with different database sources. It really helps us to achieve our business goals. I would suggest Pentaho for everyone who is looking to utilize one of the best BI tools for enhancing features with satisfying business requirements. I really love it.
Rafael Grandizoli | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Pentaho is used in my organization, mainly by the IT team, creating processes and routines focused on data ingestion from many sources. We also use Pentaho to create complex ETL jobs and prepare data to be used in our data warehouse and reporting platforms that are used by other departments in the company.
Score 10 out of 10
Vetted Review
Verified User
Before working for Hitachi Vantara, I had experience using the Pentaho Tools for personal projects mainly. I had the chance to work directly with the teams that supported the Pentaho tools, and I can tell with much objectivity that the Pentaho tools are by far one of the best options in the market when it comes to all the ETL processes. Data science requires extracting data from different sources, organizing it, and transforming it according to each necessity. Machine learning is built on top of these concepts, and with the Pentaho tools, you can accomplish most of it. Since I supported the Pentaho tools while working for Hitachi Vantara, my perspective is kind of unique; I can tell that the tools were used to solve internal problems such as integrations with our release tools and some of our agile tools, so the tools were used to enhance the newer versions.

Solving problems such as extracting metadata from thousands of files, organizing this information, and filtering it to create release files, determining how to create meta information files is just an example of the ETL cycle that can be performed with the Pentaho tools.
Ali Kazempour | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Information is our company fuel, The information and this software are used in all parts of our company, marketing, and sales, as well as development and research we make better decisions. Pentaho is now part of Hitachi Vantara and now is more better and professional than before. Lumada DataOps Suite is built with Pentaho, for end-to-end data integration and analytics at an enterprise scale. the more databases and information we have about customers, the target market, marketing, the type of goods, the consumer market, and the demand, It is better to decide on the presentation and save money. Pentaho Enterprise Edition is great for end-to-end data integration and analytics at enterprise scale. The complexities of doing business with this platform are simplified and all information is intelligently categorized and usable.‌
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
I use the Pentaho Data Integration ETL tool in our enterprise business intelligence projects. I often use the Pentaho tool for data manipulation and data transport. Pentaho plays an important role in our business processes because we work on the database in the department where I work. I use the PentahoETL tool when designing ETL processes, transporting data to the database and designing the data warehouse.
Score 6 out of 10
Vetted Review
Verified User
Pentaho is used as our organizational-wide reporting and BI platform. It is bringing together data from multiple enterprise applications including ERPs, HRM, EAM and PLMs. We are using it to create both prepackaged PDF reports as well as interactive analysis reports where users can compose their on add-how reports.
Score 6 out of 10
Vetted Review
Verified User
We rolled out Pentaho within one of our business units as a way to get at trapped data from an old home-grown CRM system that had been recently updated to .net. Pentaho quickly got us access to the data and the built-in ETL tools were easy and quick to use and learn. It enabled a team of two to provide enough data, reporting and analytical dashboards to support over $1.5B in sales.
Ilham AB | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Currently, Pentaho was using it for our internal IT Department. We are using Pentaho to address more specific needs to integrate and analyze the company data that resides on all systems. It is necessary to have a secondary system that runs for the same purpose to run small and simpler modeling tools for Data Warehouses and Business Intelligence. It also acts as a comparison system to build simple jobs and transformations.
Mihaela Olariu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
We are currently using this application for all the companies. We have managed to develop a lot of reports and dashboards and also bursting reports. Until now we have been able to meet the requirements of reporting in the company in all departments. Pentaho is a good BI solution to also provide the option of creating many operational reports if you don't have a good option in your ERP.
Score 5 out of 10
Vetted Review
Verified User
We made a decision to use Pentaho to OEM into the analytics feature of our software and the developers had a much harder time getting it integrated than we were expecting. The Mondrian code was hard to learn and the number of qualified applicants who already knew how to use it was limited.

November 04, 2016

Pentaho - Yay or Nay?

Score 6 out of 10
Vetted Review
Verified User
I worked in a small-size private consulting firm that used Pentaho for analytics and reporting firm-wide. It catered to clients in a broad range of industries ranging from hospitality to the public sector. The software is easy to learn and has an impressive amount of functionality incorporated. The ETL (Kettle) module is great for generating visualizations and I highly recommend this software to a beginner interested in BI.
Nikhil Karkare | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Pentaho is the primary source for the Business Intelligence in my company. We have many Pentaho users across the whole organization that are making a good use of Pentaho Analyzer to create the reports. At the report side, it helps the business users to evaluate all the work that has been done by the different teams across the organizations. By seeing the reports they can check, for example, how many issues are open, how many bugs have been fixed in a specific duration, how many builds failed in which phase etc.
Score 6 out of 10
Vetted Review
Verified User
In my organization, we use Pentaho as our go-to ETL tool. It is used by our engineering department in order to create our data warehouse environment, which is used by several customers. It allows us to create our data warehouse, which ultimately enables our end users to utilize analytics for their environments.
Ivan Miller | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Pentaho's BI stack is being used by our entire company. We use their tooling for ETL, delivering reports, and as a sort of end-point for a custom web app that we've built. The end point uses xaction and Mondrian to deliver data to our front end. We also make use of the community edition of the BI server--this houses several reports that our analyst team has built as well as resources necessary to support our custom app. In the near future we'll also be using the tool's big data plugins to ingest data into our data warehouse from hive/hadoop.
Score 8 out of 10
Vetted Review
Verified User
At our organization we are building a data ware house for data migration and analytics. After researching several options we went for the Pentaho community edition which is an open source tool. Pentaho played big role in the implementation of ETL jobs and QA testing. The features available in Pentaho covered all of our scenarios, plus it allowed us to plug in external jars to use for any unsupported activity.
Jordan Squire | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
We utilize the Community Edition of Pentaho across our organization for business intelligence. We use Pentaho Data Integration (PDI) to gather data from disparate data sources and perform ETL to populate our data warehouse. We also use PDI to deliver custom reports to various internal and external clients. We use Mondrian as a data engine behind our customer-facing website to process MDX queries from our customer reporting portal. We use Pentaho Report Designer to author pixel-perfect reports for internal and external audiences. We also use the Pentaho User Console for our business analysts to slice-and-dice the data for various departments. In summary, Pentaho is used to allow our internal and external clients to benchmark the performance of our products and services and gain visibility into customer behavior and activity.
Score 7 out of 10
Vetted Review
Verified User
We used the Pentaho Data Integration tool to pre-process some data and fill thr production database. It was used in the department where I worked. Being a software developer I made a decision to use PDI instead of writing scripts on Python. The main advantage of PDI was supporting scaling out of the box, and the ability to run on multiple machines. When you need something less than a Hadoop cluster but bigger than self-made quick scripts it fits well.
Sandro Frattura | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
We use it for what you would expect. ETL for process and aggregate data, and then building data cubes and reports for viewing that data. We also use the ETL tool to auto-process files (CSV, XML etc) from that we receive from a few of our vendors daily.
Stephanie Dozier | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Pentaho is currently being used for several functions within my department. The Data Integration is used as our primary ETL tool. The software does a great job with data cleansing and standardizing from multiple sources. The tool is easy enough to learn using videos out on You Tube or using the Pentaho Kettle Solutions book. We also use the Schema Editor for creating the semantic layer in the User Console reporting tool. Having defined objects available in the User consoles makes it easy for a data analyst to quickly log in and quickly get a report together. We are in the healthcare industry so much of what is being asked is counts of patients, encounters by diagnosis, practice or time period. All these items can quickly be answered very quickly via the user console.
Return to navigation