Pentaho

2009年9月23日 (三) 03:51的版本

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

Product Overview

Pentaho Architecture

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
Pentaho Reporting - Open Source Reporting
Kettle - Open Source Data Integration (ETL)
Pentaho - Comprehensive Open Source BI Suite
Weka - Open Source Data Mining
Pentaho Metadata Editor

集成产品

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 服务描述语言

Pentaho BI 3.x

Administration Console

http://localhost:8099/
admin/password

Pentaho BI 3.5.0

BI Server

http://localhost:8080

安装

获得 http://internap.dl.sourceforge.net/sourceforge/pentaho/pentaho-1.6.0GA-windows-opensource-installer.exe

选择组件

Open BI Server
Design Studio
Report Designer
Metadata Editor

你选择默认，将安装所有四个组件，根据向导完成后续安装

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

hibernate
quartz
sampledata

可能要用到的一些信息：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_1.6.0.GA.650.zip

导入 Pentaho Solutions

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

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

Spring

Pentaho Reporting and Spring

GlassFish

在 GlassFish 上部署Pentaho

Installing Pentaho & Liferay in Glassfish

Liferay

集成 Liferay, 提供了基于 Liferay 的商务智能门户方案

PostgreSQL

Configuring for PostgreSQL

Metadata Editor

Publishing Models

After defining your Metadata domain (including Connection, Model(s), and Business View), test publishing the model to the Pentaho Server (File menu)

1. User/Password are your Pentaho username and password - i.e. joe/password
2. Publish password is the publishing password defined in ..\pentaho-demo\pentaho-solutions\system\publisher_config.xml
3. Server URL - i.e. http://localhost:8080/pentaho
4. Solution - i.e. /samples/analysis

Analysis

Dashboards

Data Integration

Data Mining

BI Platform

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.

@@ 第94行： / 第94行： @@
 The data source is a Mondrian OLAP cube: samples/reporting/SampleData.mondrian.xml
+==Spring==
+*[http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+and+Spring Pentaho Reporting and Spring]
 ==GlassFish==
 在 [[GlassFish]] 上部署Pentaho