Pentaho

Pentaho: 商业智能项目提供企业级报表制作,分析,数据挖掘与工作流的功能.这个软件提供灵活 的部署选项以使它可作为嵌入式组件来使用,或作为定制BI应用程序. Pentaho包括Eclipse BIRT,JasperReports,Mondrian,JPivot,调度(scheduling),web服务,商业规则。

Product Overview

http://www.pentaho.org

Pentaho Projects

Pentaho is the sponsor and owner of other open source projects. These projects provide components and functionality integrated with the Pentaho BI Platform.

• Mondrian - Open Source OLAP Server
• JFreeReport - Open Source Reporting
• Kettle - Open Source Data Integration (ETL)
• Pentaho - Comprehensive Open Source BI Suite
• Weka - Open Source Data Mining

集成产品

Pentaho BI 平台集成和增强了现有的流行的第三方开放源码组件：

• Mondrian OLAP 服务器和 jPivot Analysis Front-End
• Firebird RDBMS
• Enhydra ETL，Shark 和 JaWE 工作流
• Kettle EII and ETL
• JBoss 应用程序服务器，Hibernate 和 Portal
• Weka 数据挖掘
• Eclipse 工作台和 BIRT 报表组件
• JOSSO 单点登录和 LDAP 集成
• Mozilla Rhino Javascript Processor

支持标准

BI 平台支持开放标准和协议有：

• XML – W3C 的可扩展标记语言
• JSR-94 – Java规则引擎
• JSR-168 – Java Portlet
• SVG – W3C 的可扩展适量图形
• XPDL – WFMC 的 XML 流程定义语言
• XForms – W3C 的 Web Forms
• MDX – Microsoft 的 OLAP 查询语言
• WSBPEL – Oasis 的 Web 服务业务流
• WSDL - W3C 的 Web 服务描述语言

安装

wget http://download.huihoo.com/pentaho/pentaho_demo-1.2.1.625-GA.tar.gz
tar zxvf  pentaho_demo-1.2.1.625-GA.tar.gz
./start-pentaho.sh
http://localhost:8080/pentaho/

或者

获得 http://download.huihoo.com/pentaho/pentaho-1.2.1-linux-opensource-installer.bin
chmod a+x pentaho-1.2.1-linux-opensource-installer.bin
./pentaho-1.2.1-linux-opensource-installer.bin 根据向导完成安装

安装成功后, 会在 MySQL 中创建如下库:

• hibernate
• quartz
• sampledata
• shark

可能要用到的一些信息：system/simple-jndi/jdbc.mysql.properties

SampleData/type=javax.sql.DataSource
SampleData/driver=com.mysql.jdbc.Driver
SampleData/url=jdbc:mysql://localhost:3306/sampledata
SampleData/user=pentaho_user
SampleData/password=password
Hibernate/type=javax.sql.DataSource
Hibernate/driver=com.mysql.jdbc.Driver
Hibernate/url=jdbc:mysql://localhost:3306/hibernate
Hibernate/user=hibuser
Hibernate/password=password
Quartz/type=javax.sql.DataSource
Quartz/driver=com.mysql.jdbc.Driver
Quartz/url=jdbc:mysql://localhost:3306/quartz
Quartz/user=pentaho_user
Quartz/password=password
Shark/type=javax.sql.DataSource
Shark/driver=com.mysql.jdbc.Driver
Shark/url=jdbc:mysql://localhost:3306/shark
Shark/user=sa
Shark/password=

启动系统

./start-pentaho.sh
http://localhost:8080/pentaho // 成功进入 :) 初步浏览了一下，功能十分强大
http://localhost:8080/portal/portal/pentaho/ // 也提供了基于 JBoss Portal 的商务智能门户方案

安装 Pentaho Design Studio, 让其与 Pentaho Solutions 结合使用

wget http://download.huihoo.com/pentaho/pentaho-design-studio-linux_1.5.5.548-0.tar.gz

导入 Pentaho Solutions

./PentahoDesignStudio 
File > New > Project > General 
创建 Pentaho Solutions 的项目 
并定位目录: pentaho-demo/pentaho-solutions/, 这时将 pentaho-solutions导入 Eclipse 

MDX Query of an OLAP Datasource

MDX Query of an OLAP Datasource

MDX Query Result

This rule uses an MDX multidimensional query to return Actual and Budget for all Regions.

The data source is a Mondrian OLAP cube: samples/reporting/SampleData.mondrian.xml

Reporting

All organizations use reporting in one form or another. As a result, reporting is considered a core Business Intelligence (BI) need and is frequently the first BI application deployed. Pentaho Reporting allows organizations to easily access, format, and distribute information to employees, customers, and partners.