Old Tech Tip: Setting Up Pentaho BI on Windows Box

I found it in one of my backup, I figure I will repost on new blog.

I took these steps to set up Pentaho BI on Windows Box.

  1. Download Pentaho BI Pre-Configured Installation from http://www.pentaho.org/download/ga.php
  2. Install JDK5.
  3. Open C:\pentaho-demo\pentaho-solutions\system\publisher_config.xml. Add a password for publishing reports between password
  4. Delete all folders expect reporting under C:\pentaho-demo\pentaho-solutions\samples.
  5. Delete all .xaction and .properties files under reporting.
  6. Copy JDBC driver for your database under C:\pentaho-demo\jboss\server\default\lib. I used Oracle 10g driver, it is called ojdbc.jar.
  7. Edit .jsp file to change the look of default Pentaho website under C:\pentaho-demo\jboss\server\default\deploy\pentaho.war\jsp\.
  8. Add path to your JDK directory in start-pentaho.bat located under C:\pentaho-demo. For example: set JAVA_HOME=C:\Program Files\Java\jdk1.5.0_11
  9. Double click on start-pentaho.bat.
  10. Go back to C:\pentaho-demo\jboss\server\default\deploy\pentaho.war\WEB-INFââ?¬Â and open web.xml. Search for base-url and add your server’s ip. For example,

base-url

http://0.0.0.0:8080/pentaho/

  1. Now you should be able to publish reports to Pentaho using Report Wizard or Report Designer.
  2. Once you publish report, you will need to go to C:\pentaho-demo\jboss\server\default\deploy and open newly created data source file named something like ???????-ds.xml.
  3. If your database is Oracle you will need to change driver class property to <driver-class>oracle.jdbc.driver.OracleDriver
  4. And your newly published report should be accessible via Pentaho now.
  5. Good Luck!

Related posts:

  1. Windows XP Backup script
  2. Quick Tech Tip: How to find large directories on AIX

Leave a Reply