The Pentaho BI Suite is open source

Open source

The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...

 Business Intelligence

Business intelligence

Business intelligence mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes....

 suite with integrated report

Report

A report is a textual work made with the specific intention of relaying information or recounting certain events in a widely presentable form....

ing, dashboard, data mining

Data mining

Data mining , a relatively young and interdisciplinary field of computer science is the process of discovering new patterns from large data sets involving methods at the intersection of artificial intelligence, machine learning, statistics and database systems...

, workflow

Workflow

A workflow consists of a sequence of connected steps. It is a depiction of a sequence of operations, declared as work of a person, a group of persons, an organization of staff, or one or more simple or complex mechanisms. Workflow may be seen as any abstraction of real work...

 and ETL

Extract, transform, load

Extract, transform and load is a process in database usage and especially in data warehousing that involves:* Extracting data from outside sources* Transforming it to fit operational needs...

 capabilities. Pentaho is headquartered in Orlando, USA.

Overview

The Pentaho suite is made up of several products described below:

Product	Description
Pentaho Data Integration	Pentaho Data Integration, codenamed Kettle, consists of a core data integration (ETL) engine, and GUI Gui Gui or guee is a generic term to refer to grilled dishes in Korean cuisine. These most commonly have meat or fish as their primary ingredient, but may in some cases also comprise grilled vegetables or other vegetarian ingredients. The term derives from the verb, "gupda" in Korean, which literally...  applications that allow the user to define data integration jobs and transformations. It supports deployment on single node computers as well as on a cloud, or cluster.
Pentaho Analysis Services	Pentaho Analysis Services, codenamed Mondrian OLAP server Mondrian OLAP server Mondrian is an open source OLAP server,written in Java.It supports the MDX query languageand the XML for Analysis and interface specifications.It reads from SQL and other data sources... , is an open source Open source The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...  OLAP (online analytical processing) server Server (computing) In the context of client-server architecture, a server is a computer program running to serve the requests of other programs, the "clients". Thus, the "server" performs some computational task on behalf of "clients"... , written in Java Java (programming language) Java is a programming language originally developed by James Gosling at Sun Microsystems and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities... . It supports the MDX Multidimensional Expressions Multidimensional Expressions is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas.-Background:...  (multidimensional expressions) query language and the XML for Analysis XML for Analysis XML for Analysis is an industry standard for data access in analytical systems, such as OLAP and data mining. XMLA is based on other industry standards such as XML, SOAP and HTTP...  and olap4j interface specifications. It reads from SQL SQL SQL is a programming language designed for managing data in relational database management systems ....  and other data sources and aggregates data in a memory cache.
Pentaho Reporting	Pentaho Reporting consists of a core reporting engine, capable of programmatic generating reports based on an XML XML Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....  definition file. Many tools have been developed surrounding the reporting engine, including GUI Gui Gui or guee is a generic term to refer to grilled dishes in Korean cuisine. These most commonly have meat or fish as their primary ingredient, but may in some cases also comprise grilled vegetables or other vegetarian ingredients. The term derives from the verb, "gupda" in Korean, which literally...  designers and ad-hoc wizards that guide the user through a step-by-step process of creating a report, using solely graphical tools without the need to write any code. A notable use is the Sun Report Builder for OpenOffice.org Base OpenOffice.org Base OpenOffice.org Base , a database module, initially appeared with OpenOffice.org version 2.0. As of 2010, it builds on the HSQLDB database engine written in Java....  / StarOffice Base.
Pentaho Data Mining	Pentaho Data Mining, codenamed Weka Weka (machine learning) Weka is a popular suite of machine learning software written in Java, developed at the University of Waikato, New Zealand... , is a comprehensive set of tools for machine learning and data mining. Its broad suite of classification, regression, association rules, and clustering algorithms can be used to help an analyst understand the business better and to improve future performance through predictive analytics.
Pentaho DashBoard	Conceptually Pentaho Dashboard is an Integrated platform to provide insight into your data, where you can view all kind of Interactive reports, charts and cubes created using Pentaho tools such as Pentaho Report Designer. It is a dashboard-style interface which provides a centralized view over your Business Data Movements, letting you monitor them and make decisions.
Pentaho for Apache Hadoop	Pentaho for Hadoop Hadoop Apache Hadoop is a software framework that supports data-intensive distributed applications under a free license. It enables applications to work with thousands of nodes and petabytes of data...  lowers Big Data onramp with easy-to-use, affordable ETL and analytics offering. Pentaho Data Integration for Hadoop and the Pentaho BI Suite for Hadoop address the biggest challenges experienced by users of Hadoop – steep technical learning curve, a lack of qualified technical staff and the lack of availability of development and deployment applications for performing data integration and business intelligence with Hadoop.

Licensing

Pentaho uses a subscription

Subscription business model

The subscription business model is a business model where a customer must pay a subscription price to have access to the product/service. The model was pioneered by magazines and newspapers, but is now used by many businesses and websites....

 model, eliminating software license fees. Pentaho, under subscription model, provides support, services, and product enhancements via annual subscription. As a commercial open source company, Pentaho "leads and sponsors" the open source projects that are core to its suite, giving it direct influence over software development.

Pentaho community version is licensed under Mozilla Public License

Mozilla Public License

The Mozilla Public License is a free and open source software license. Version 1.0 was developed by Mitchell Baker when she worked as a lawyer at Netscape Communications Corporation and version 1.1 at the Mozilla Foundation...

 version 1.1. Pentaho Enterprise versions are available under a commercial license. There are three variants of enterprise versions: Basic, Professional and Enterprise.

Accolades and Awards

• Red Herring
  Red Herring (magazine)
  Red Herring was a technology business magazine, which flourished during the dot com boom, with global distribution and bureaus in Bangalore, Beijing, and Paris. It also sponsored conferences designed to bring venture capitalists, entrepreneurs, and technologists together. But the magazine went into...
  
  100 Award
• InfoWorld Bossie Award 2008, 2009, 2010
• Ventana Research Leadership Award 2009 for Centro
• Ventana Research Leadership Award 2010 for StoneGate Senior Care
• CRN Emerging Technology Vendor 2010
• More awards on Pentaho's Awards Page

External links

• Pentaho website
• Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho
• Introduction to OLAP4J Programming introduction on Dr. Dobb's
• BI, Data warehousing, ETL examples using Pentaho
• Data Warehousing
• Pentaho Reporting 3.5 for Java Developers
• Ogrs 2009
• Data Warehouse
• Startup Of The Week: Pentaho Offers Opens Source BI Alternative