Install pentaho in Oracle 10g environment

1. Start to install and configure Java. If Java is not installed on your computer, you can download the Java installation file from Sun Developer Network.

(1) install 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) sets JAVA_HOME and CATALINA_OPTS environment variables C:/> echo % JAVA_HOME % C:/Program Files/Java/jdk1.6.0 _ 13

(2) Deploy the Pentaho Platform [// download Pentaho]. apache-Tomcat is not pre-installed with winrar or 7-Zip unzip pentaho-ce-3.5.x.stable.zip C:/| -- pentaho | -- adminstration-console | -- biserver-ceb. pre-installed Apache-Tomcat

(3) install the Oracle JDBC thin client driver to visit the Oracle website and download ojdbc14.jarhttp: // copy ojdbc14.jar to the % PENTAHO_HOME/tomcat/common/lib and administration-console/jdbc folders.

(4) download an SQL script package pentaho_3.5.0_oracle_ SQL _pack.zip http://docs.google.com/uc? Id = Hangzhou & export = download & hl = zh_CN

2. Configure the Oracle 10g/11g Database to decompress the downloaded SQL script:

1_create_repository_oracle. SQL create a Hibernate Database

2_create_quartz_oracle. SQL create Quartz database 3_load_sample_users_oracle. SQL create all demonstration users and roles of Hibernate database edit SQL scripts (refer to the original article) load SQL scripts (refer to the original article)

3. Configure JDBC Security edit $ PENTAHO_HOME/pentaho-solutions/system/applicationContext-spring-security-jdbc.xml

Note: 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 wowould 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.

Edit $ 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

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

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

4. Configure Hibernate and Quartz

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

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

5. Configure the Apache-Tomcat Service

Edit $ PENTAHO_HOME/tomcat/webapps/pentaho/WEB_INF/web. xml. solution-path C:/pentaho-solutions B. base-url http://www.prashantraju.com: 8080/pentaho/or http: // 192.168.1.100: 8080/pentaho/c. trustedIpAddrs 127.0.0.1, [your_ip_address] d. other Parameters. modify the default language and country in xml

6. Configure the SMTP Mail Server

Edit $ pentaho_home/pentaho-Solutions/system/smtp-email.xml the following are some common configuration parameters: 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. here is a Gmail smtp-email.xml configuration example smtp.gmail.com 587 smtps true false pentahoadmin@gmail.com Password

7. Release Configuration

Edit $ PENTAHO_HOME/pentaho-solutions/publisher_config.xml publishthis

8. Start Pentaho platform $ PENTAHO_HOME/biserver-ce/start-pentaho.bat access: http: // localhost: 8080/pentaho

9. Start Pentaho console $ PENTAHO_HOME/adminstration-console/start-pac.bat access: http: // localhost: 8099