欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
Pentaho
第34行: | 第34行: | ||
* WSBPEL – Oasis 的 Web 服务业务流 | * WSBPEL – Oasis 的 Web 服务业务流 | ||
* WSDL - W3C 的 Web 服务描述语言 | * WSDL - W3C 的 Web 服务描述语言 | ||
− | ==Pentaho | + | ==Pentaho BI== |
− | http://localhost: | + | http://localhost:8080/ |
− | + | ||
==安装== | ==安装== | ||
获得 http://internap.dl.sourceforge.net/sourceforge/pentaho/pentaho-1.6.0GA-windows-opensource-installer.exe | 获得 http://internap.dl.sourceforge.net/sourceforge/pentaho/pentaho-1.6.0GA-windows-opensource-installer.exe |
2009年9月5日 (六) 05:43的版本
Pentaho: 商业智能项目提供企业级报表制作,分析,数据挖掘与工作流的功能.这个软件提供灵活 的部署选项以使它可作为嵌入式组件来使用,或作为定制BI应用程序. Pentaho包括Eclipse BIRT,JasperReports,Mondrian,JPivot,调度(scheduling),web服务,商业规则。
目录 |
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
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
PentahoDesignStudio.exe File > New > Project > General 创建 Pentaho Solutions 的项目 并定位目录: pentaho-demo/pentaho-solutions/, 这时将 pentaho-solutions导入 Eclipse
MDX Query of an OLAP Datasource
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
GlassFish
在 GlassFish 上部署Pentaho
Installing Pentaho & Liferay in Glassfish
Liferay
集成 Liferay, 提供了基于 Liferay 的商务智能门户方案
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.