Pentaho
 | This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages)
(May 2011)No issues specified. Please specify issues, or remove this template. |
 | This article may be too technical for most readers to understand. (May 2011) |
| Developer(s) | The Pentaho BI Project |
|---|---|
| Stable release | 4.2.0 GA
/ 10.10.2011 |
| Operating system | Windows, Linux, Mac OS X |
| Type | Business intelligence |
| License | Mozilla Public License 1.1 for community version and Pentaho Commercial License for enterprise editions |
| Website | www.pentaho.com |
The Pentaho BI Suite is open source Business Intelligence suite with integrated reporting, dashboard, data mining, workflow and ETL 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 engine, and GUI 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, is an open source OLAP (online analytical processing) server, written in Java.
It supports the MDX (multidimensional expressions) query language and the XML for Analysis and olap4j interface specifications. It reads from SQL 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 definition file. Many tools have been developed surrounding the reporting engine, including GUI 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 / StarOffice Base.[1] |
| Pentaho Data Mining | Pentaho Data Mining, codenamed Weka, 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 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 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 version 1.1. Pentaho Enterprise versions are available under a commercial license. There are three variants of enterprise versions: Basic, Professional and Enterprise[2].
Accolades and Awards
- Red Herring 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
References
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