Pentaho is

business intelligence Business intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis and management of business information. Common functions of business intelligence technologies include reporting, online analytical p ...

(BI) software that provides

data integration Data integration involves combining data residing in different sources and providing users with a unified view of them. This process becomes significant in a variety of situations, which include both commercial (such as when two similar companies ...

, OLAP services,

report A report is a document that presents information in an organized format for a specific audience and purpose. Although summaries of reports may be delivered orally, complete reports are almost always in the form of written documents. Usage In ...

ing, information dashboards, data mining and

extract, transform, load In computing, extract, transform, load (ETL) is a three-phase process where data is extracted, transformed (cleaned, sanitized, scrubbed) and loaded into an output data container. The data can be collated from one or more sources and it can also ...

(ETL) capabilities. Its headquarters are in

Orlando Orlando () is a city in the U.S. state of Florida and is the county seat of Orange County. In Central Florida, it is the center of the Orlando metropolitan area, which had a population of 2,509,831, according to U.S. Census Bureau figures re ...

Florida Florida is a state located in the Southeastern region of the United States. Florida is bordered to the west by the Gulf of Mexico, to the northwest by Alabama, to the north by Georgia, to the east by the Bahamas and Atlantic Ocean, and to ...

. Pentaho was acquired by

Hitachi Data Systems Hitachi Data Systems (HDS) was a provider of modular mid-range and high-end computer data storage systems, software and services. Its operations are now a part of Hitachi Vantara. It was a wholly owned subsidiary of Hitachi Ltd. and part of ...

in 2015 and in 2017 became part of Hitachi Vantara.

Overview

Pentaho is a Java framework to create Business Intelligence solutions. Although most known for its Business Analysis Server (formerly known as Business Intelligence Server), the Pentaho software is indeed a couple of Java classes with specific functionality. On top of those Java classes one can build any BI solution. The only exception to this model is the ETL tool Pentaho Data Integration - PDI (formerly known as Kettle.) PDI is a set of softwares used to design data flows that can be run either in a server or standalone processes. PDI encompasses Kitchen, a job and transformation runner, and Spoon, a graphical user interface to design such jobs and transformations. Features such as reporting and OLAP are achieved by integrating subprojects into the Pentaho framework, like Mondrian OLAP engine and jFree Report. For some time by now those projects have been brought into Pentaho's curating. Some of those subprojects even have standalone clients like Pentaho Report Designer, a front-end for jFree Reports, and Pentaho Schema Workbench, a GUI to write XMLs used by Mondrian to serve OLAP cubes. Pentaho offers enterprise and community editions of those softwares. The enterprise software is obtained through an annual subscription and contains extra features and support not found in the community edition. Pentaho's core offering is frequently enhanced by add-on products, usually in the form of plug-ins, from the company and the broader community of users.

Products

Server applications

Pentaho Enterprise Edition (EE) and Pentaho Community Edition (CE).

Desktop/client applications

Community driven, open-source Pentaho server plug-ins

All of these plug-ins function with Pentaho Enterprise Edition (EE) and Pentaho Community Edition (CE).

Licensing

Pentaho follows an

open core The open-core model is a business model for the monetization of commercially produced open-source software. Coined by Andrew Lampitt in 2008, the open-core model primarily involves offering a "core" or feature-limited version of a software pro ...

business model. It provides two different editions of Pentaho Business Analytics: a community edition and an enterprise edition. The enterprise edition needs to be purchased on a subscription model. The subscription model includes support, services, and product enhancements via annual subscription.Torben Pedersen and Mukesh Mohania.
Data Warehousing and Knowledge Discovery
" Heidelberg, Germany: Springer Science and Business Media, 2009. . p.296-298. Retrieved April 6, 2012. The enterprise edition is available under a commercial license. Enterprise license goes with 3 levels o

Enterprise, Premium and Standard. The community edition is a free open source product licensed under the

GNU General Public License The GNU General Public License (GNU GPL or simply GPL) is a series of widely used free software licenses that guarantee end users the four freedoms to run, study, share, and modify the software. The license was the first copyleft for general ...

version 2.0 (GPLv2),

GNU Lesser General Public License The GNU Lesser General Public License (LGPL) is a free-software license published by the Free Software Foundation (FSF). The license allows developers and companies to use and integrate a software component released under the LGPL into their own ...

version 2.0 (LGPLv2), and

Mozilla Public License The Mozilla Public License (MPL) is a free and open-source weak copyleft license for most Mozilla Foundation software such as Firefox and Thunderbird The MPL license is developed and maintained by Mozilla, which seeks to balance the concerns ...

1.1 (MPL 1.1).

Recognition

* InfoWorld Bossie Award 2008, 2009, 2010, 2011, 2012 * Ventana Research Leadership Award 2010 for StoneGate Senior Care * CRN Emerging Technology Vendor 201

* ROI Awards 2012 - Nucleus ResearchNucleus Research
/ref>

References

External links

* {{Authority control Business intelligence companies Free business software Free reporting software Extract, transform, load tools