Wednesday, December 25, 2013

Pentaho Data Integration - Configure Oracle JDBC Connection

Stepwise illustration on how to configure native JDBC Oracle database connections for Pentaho Data Integration. JDBC connections are the easiest and most commonly used access protocol. Connections can be configured using Spoon and managed by DI server.

Step 1 :
Open Spoon.
Go to "Database Connection >> New Connection Wizard"

Pentaho Common Errors : Driver class 'oracle.jdbc.driver.OracleDriver' could not be found

Error Message

Error connecting to database [ORA_TEST_JDBC] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed.

Tuesday, December 24, 2013

Pentaho Business Analytics Enterprise Edition 5.0.2 - Installation for Windows 64 bit

Step 1 :
 Download latest Pentaho Business Analytics version ( 5.0.2 )  from
Step 2 :
Save and execute file pentaho-business-analytics-5.0.2-x64.exe.
Installation wizard will pop up. Click Next.