Pentaho
Pentaho is a business intelligence BI software that provides data integration, OLAP services, reporting, information dashboards, data mining and extract, transform, load ETL capabilities. It is headquartered in Orlando, Florida. Pentaho was acquired by Hitachi Data Systems in 2015. On September 19, 2017, Pentaho became part of Hitachi Vantara, a new company that unifies the operations of Pentaho, Hitachi Data Systems and Hitachi Insight Group.
Overview
Pentaho offers an enterprise and community edition of the software. 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
Pentaho Enterprise Edition EE and Pentaho Community Edition CE.
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. Mondrian can be run separately from the Pentaho BI Platform, but is always bundled with the platform itself in both EE and CE versions.
All of these plug-ins function with Pentaho Enterprise Edition EE and Pentaho Community Edition CE.
CDC stands for Community Distributed Cache and allows for high-performance, scalable and distributed memory clustering cache based on Hazelcast for both CDA and Mondrian. CDC is a Pentaho plug-in that provides the following features:
Pentaho plug-in that allows the user to export CCC/CDE charts as images, enabling the inclusion of CDE charts inside Pentaho Report Designer reports. In short, this plug-in is able to render server-side exactly the same chart that is rendered on the browser by CDE/CDF. Main characteristics:
A RESTful server connects to existing OLAP systems, which then powers user-friendly, intuitive analytics via a lightweight frontend.
Licensing
Pentaho follows an open core 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. The enterprise edition is available under a commercial license. Enterprise license goes with 3 levels of Pentaho Enterprise Support: Enterprise, Premium and Standard. The community edition is a free open source product licensed under the GNU General Public License version 2.0 GPLv2, GNU Lesser General Public License version 2.0 LGPLv2, and Mozilla Public License 1.1 MPL 1.1.