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.
oracle.jdbc.driver.OracleDriver

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 http://pentaho.com/download

 

 

Step 2 :

 

Save and execute file pentaho-business-analytics-5.0.2-x64.exe.

Installation wizard will pop up. Click Next.

Pentaho Data Integration - Configure DI Server for Windows

Step 1 :

Go To "Start > Pentaho Enterprise Edition > Server Management"
Start DI and Tomcat servers using icon "Start Data Integration Server"

Pentaho Data Integration - PDI 5.0.2 Installation for Windows 64 bit

Step 1 : 

Download latest PDI version ( 5.0.2 )  from http://pentaho.com/download