Pentaho Introduces Web-based Ad Hoc Query and Reporting

World's Most Popular Open Source BI Suite Adds Metadata-driven Self Service Reporting

Orlando FL. - Nov. 21, 2006 - Pentaho Corp., creator of the world's most popular open source business intelligence (BI) suite, today announced new web-based ad hoc query and reporting capabilities for the Pentaho Reporting module of Pentaho's BI suite. The new functionality utilizes an innovative new open source metadata layer that facilitates self-service query and reporting by shielding end users from the complexities of underlying databases and thereby lowering the technical barriers to customized report creation.

With Pentaho's new open source metadata capabilities, administrators can define a layer of abstraction that presents database information to business users in familiar business terms. Administrators identify relationships between tables in the database, create business-language definitions for complex or cryptic database tables and columns, set security parameters to limit data access to appropriate users, specify default formatting for data fields, and provide additional translations for business terms for multi-lingual deployments. Business users can then use Pentaho's new ad hoc query capabilities to choose the specific elements they would like to include in a given report, such as order quantities and total spending by customer grouped by region.

The new web-based query interface uses AJAX technology to provide a highly interactive, easy to use, scalable front end. The application's metadata layer was built using the Common Warehouse Metamodel (CWM) standard created by the Object Management Group (OMG) designed to allow for interoperability with existing metadata stores as well as third-party databases, metadata repositories, and ETL tools. Pentaho's metadata-driven query engine uses JDBC and ANSI standard SQL to allow for the broadest possible choice of proprietary and open source databases including Oracle, IBM DB2, Microsoft SQL Server, MySQL, PostgreSQL and others. Pentaho's metadata will also be accessible in the near future from Pentaho's open source graphical report designer, and the Pentaho Design Studio.

Pentaho now provides tailored reporting capabilities for application developers, power users, and business users alike within a common architecture and report format. In the first half of this year, Pentaho delivered report authoring capabilities for developers via tight integration with the popular Eclipse integrated development environment (IDE), as well as a graphical Report Designer that gave power users a drag-and-drop report authoring environment. This latest capability now makes Pentaho Reporting more accessible to casual and business users who want self-service reporting via the web.

"Bringing web-based ad hoc query and reporting to the Pentaho suite has been one of our top priorities," said Richard Daley, CEO of Pentaho. "Our new metadata functionality is a major step in expanding the market for open source BI and equipping organizations of all sizes with the tools they need to understand their business performance and opportunities quickly, flexibly and cost-effectively."

Availability

The first milestone build of Pentaho's new metadata layer and metadata editor are available immediately under the Mozilla Public License at www.pentaho.com/download/latest . A recorded demonstration of Pentaho's new web-based ad hoc query and reporting capabilities for Pentaho Reporting is available at www.pentaho.com/products/demos/ .

About Pentaho

Pentaho provides a full spectrum of business intelligence (BI) capabilities including reporting, analysis, dashboards, data mining, data integration, and a BI platform that have made it the world's most popular open source BI suite. Formed by a highly experienced team of industry veterans, Pentaho's mission is to bring innovative, high quality technology and professional support to the BI market. Pentaho uses a revolutionary approach to development, distribution and support made possible by a professional open source business model. Pentaho is the primary sponsor and owner of popular open source projects including JFreeReport, Kettle, Mondrian, and Weka. Pentaho's technologies support a wide range of business initiatives from sales and profitability analysis, customer analysis, HR reporting, financial reporting, KPI dashboards, supply chain analytics, and operational reporting. For more information, visit www.pentaho.com.