Pentaho Introduces Web-Based Ad Hoc Query and Reporting.World's Most Popular Open Source BI Suite Adds Metadata-Driven Self Service Reporting ORLANDO, Fla. -- Pentaho Corp., creator of the world's most popular open source business intelligence (BI) suite, today announced new web-based ad hoc query A non-standard inquiry. An ad hoc query is created to obtain information as the need arises. Contrast with a query that is predefined and routinely performed. See query and ad hoc. 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 See abstraction layer. 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 For other uses of "CWM", see CWM (disambiguation). The Common Warehouse Metamodel (CWM) is a specification for modeling metadata for relational, non-relational, multi-dimensional, and most other objects found in a data warehousing environment. (CWM) standard created by the Object Management Group (OMG (1) See Object Management Group. (2) "Oh my God!" See digispeak. OMG - Object Management Group ) designed to allow for interoperability with existing metadata stores as well as third-party databases, metadata repositories, and ETL (Extract, Transform, Load) The functions performed when pulling data out of one database and placing it into another of a different type. ETL is used to migrate data, often from relational databases into decision support systems. tools. Pentaho's metadata-driven query engine uses JDBC (Java DataBase Connectivity) A programming interface that lets Java applications access a database via the SQL language. Since Java interpreters (Java Virtual Machines) are available for all major client platforms, this allows a platform-independent database and ANSI (American National Standards Institute, New York, www.ansi.org) A membership organization founded in 1918 that coordinates the development of U.S. voluntary national standards in both the private and public sectors. It is the U.S. member body to ISO and IEC. standard SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. to allow for the broadest possible choice of proprietary and open source databases including Oracle, IBM DB2, Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. , 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 See IDE. integrated development environment - interactive 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 (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. 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 Mozilla Public License - open source license at www.pentaho.org/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.org. |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion