Oracle 10g 環境下安裝 Pentaho

1、開始安裝和配置 Java如果你的電腦上還沒有安裝 Java，則可以到 Sun Developer Network 下載 Java 安裝檔案

(1)安裝 JavaC:/>java -versionjava version "1.6.0_13"Java(TM) SE Runtime Environment (build 1.6.0_13-b03)Java HotSpot(TM) Client VM (build 11.3-b02, mixed mode, sharing)設定 JAVA_HOME 和 CATALINA_OPTS 環境變數C:/>echo %JAVA_HOME%C:/Program Files/Java/jdk1.6.0_13

(2) 部署 Pentaho 平台[//下載 Pentaho]a. 沒有預裝 Apache-Tomcat使用 winrar 或 7-Zip 解壓 pentaho-ce-3.5.x.stable.zip C:/|-- pentaho| |-- adminstration-console| |-- biserver-ceb. 預裝 Apache-Tomcat參見原文

(3) 安裝 Oracle JDBC 瘦用戶端驅動訪問 Oracle 網站，下載ojdbc14.jarhttp://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html將 ojdbc14.jar 複製到 %PENTAHO_HOME/tomcat/common/lib 和 administration-console/jdbc 檔案夾

(4) 下載 SQL 指令碼包Pentaho_3.5.0_Oracle_SQL_Pack.ziphttp://docs.google.com/uc?id=0B9Jmocc0fj_EM2JmNDkyMGItMzUzYS00MWQxLTgwYTMtMjM5NTUyNDYzOTQz&export=download&hl=zh_CN

2、配置 Oracle 10g/11g 資料庫將下載的 SQL 指令碼解壓：

1_create_repository_oracle.sql 建立 Hibernate 資料庫 

2_create_quartz_oracle.sql 建立 Quartz 資料庫 3_load_sample_users_oracle.sql 建立 Hibernate 資料庫的所有示範使用者和角色編輯 SQL 指令碼(參考原文)裝載 SQL 指令碼(參考原文)

3、配置 JDBC 安全性編輯 $PENTAHO_HOME/pentaho-solutions/system/applicationContext-spring-security-jdbc.xml

注意：Here is a brief description of the url value property: jdbc:oracle:thin:[host]:[port]:[sid] In this example I have used an IP address of my Oracle 10g database for my host, you would most likely have a host setup in your tns.ora file already. The port which your Oracle 10g database runs on. The SID of your Oracle 10g database, in this example it is ORCL.

編輯 $PENTAHO_HOME/pentaho-solutions/system/applicationContext-spring-security-hibernate.properties jdbc.driver=oracle.jdbc.driver.OracleDriver jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:ORCL jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

編輯 $PENTAHO_HOME/pentaho-solutions/system/hibernate/hibernate-settings.xml system/hibernate/oracle10g.hibernate.cfg.xml

編輯 $PENTAHO_HOME/pentaho-solutions/system/hibernate/oracle10g.hibernate.cfg.xml jdbc:oracle:thin:@127.0.0.1:1521:ORCL

4、配置 Hibernate 和 Quartz

編輯 $PENTAHO_HOME/tomcat/webapps/pentaho/META-INF/context.xml

編輯 $PENTAHO_HOME/pentaho-solutions/system/quartz.properties org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.OracleDelegate

5、配置 Apache-Tomcat 服務

編輯 $PENTAHO_HOME/tomcat/webapps/pentaho/WEB_INF/web.xml a. solution-path solution-path C:/pentaho/pentaho-solutions b. base-url http://www.prashantraju.com:8080/pentaho/ 或 http://192.168.1.100:8080/pentaho/ c. TrustedIpAddrs TrustedIpAddrs 127.0.0.1,[your_ip_address] d. Other Parameters 你可以在 web.xml 修改預設的語言和國家

6、配置 SMTP 郵件伺服器

編輯 $PENTAHO_HOME/pentaho-solutions/system/smtp-email.xml以下是一些常用的配置參數: mail.smtp.host This is the address of your SMTP email server for sending email e.g. smtp.gmail.com mail.smtp.port This is the port of your SMTP email server e.g. for GMail this is 587 mail.transport.protocol The transport for accessing the email server. Usually this is smtp e.g. for GMail this is smtps mail.smtp.starttls.enable If you SMTP server uses TTLS authentication set this to true e.g. for GMail this is true mail.smtp.auth Set to true if the email server requires the sender to authenticate mail.smtp.ssl This is true if the email server requires an SSL connection e.g. for GMail this is true mail.debug Output debug information from the JavaMail API mail.pop3 Not being used. mail.from.default The from address that emails from the Pentaho BI Platform e.g. prashantraju@gmail.com mail.userid The userid that is used when authenticating with the SMTP server, mail.smtp.auth must be set to true. mail.password The password that is used when authenticating with the SMTP server, mail.smtp.auth must be set to true.這裡有一個 GMail 的 smtp-email.xml 配置例子 smtp.gmail.com 587 smtps true true true false pentahoadmin@gmail.com pentahoadmin@gmail.com password

7、配置發布

編輯 $PENTAHO_HOME/pentaho-solutions/publisher_config.xml publishthis

8、啟動 Pentaho 平台$PENTAHO_HOME/biserver-ce/start-pentaho.bat訪問: http://localhost:8080/pentaho

9、啟動 Pentaho 管理主控台$PENTAHO_HOME/adminstration-console/start-pac.bat訪問: http://localhost:8099