Secured & Safest ETL and Reporting tool
I used Pentaho as an ETL tool to extract data from different data sources and created data marts for reporting and descriptive analytics …
Pentaho
Pentaho
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 moreRecent Reviews
Popular Features
View all 28 features- Multi-User Support (named login) (21)9.191%
- Role-Based Security Model (20)8.888%
- Formatting capabilities (20)8.484%
- Publish to PDF (20)7.777%
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!
Pricing
View all pricingN/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…
Features
Return to navigation
Product Details
- About
- Integrations
- Tech Details
- FAQs
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 Systems | Unspecified |
|---|---|
| Mobile Application | No |
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).
Comparisons
View all alternativesCompare with
Reviews and Ratings
 (131)
Attribute Ratings
Reviews
(1-25 of 32)- Popular Filters
Companies can't remove reviews or game the system. Here's why
June 28, 2022
Secured & Safest ETL and Reporting tool
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.
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.
April 12, 2022
Best for Reporting and Dashboard
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.
February 04, 2022
Data integration made easy
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.
May 07, 2021
Using the Pentaho tools to solve ETL challenges
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.
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.
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.‌
March 02, 2020
My Experience with Pentaho data integrator
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.
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.
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.
March 19, 2018
Pentaho for your business
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.
February 23, 2018
Pentaho can be a great solution for a company
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.
June 30, 2017
Pentaho was just OK as an OEM solution
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?
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.
November 03, 2016
Pentaho: A great DW/BI soultion
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.
November 02, 2016
Rookie Pentaho review from an ETL veteran
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.
June 27, 2016
Pentaho - Enhancing our ETL Capabilities
Pentaho is used for scheduled ETL between Remedy and other platforms to help centralize and enrich data.
March 01, 2016
A powerful ETL tool which is open source
Pentaho is used as main ETL tool in the data analytics team. It solves the problem of processing and populating financial and ads related data.
February 26, 2016
Pentaho- An adequate BI solution for users on a budget!
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.
February 24, 2016
Pentaho for Quality Assurance
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.
February 23, 2016
Pentaho powerful backend BI tooling, hit-and-miss data visualization
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.
February 23, 2016
An implementor view on Pentaho tools.
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.
February 16, 2016
One of the best BI solutions for start up companies or those looking for a highly customizable tool.
It's been used across the whole organization .
Automated reports and dashboards are some of our core usages .
August 19, 2015
Pentaho - Fast and Furious Data Integration
Pentaho Data Integration is used to move data into our data warehouse solution, used for various projects.
June 03, 2015
B.I. made simple. Pentaho rocks!
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.
March 16, 2015
Pentaho - Jumping On The Band Wagon
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.