Pentaho Data Integration - Connection - Oracle 11g R2 RAC (#017)

To run Pentaho you need to install Java first. Required Java version can be found in the run batch or shell script. Both files, Spoon.bat and spoon.sh, are located in the main Pentaho folder.

The next step is selecting of a proper JDBC driver which is associated with the Oracle and Java version.

 

 

 

JDBC drivers can be found on the Oracle's website:

http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

 

 

 

 

Download the driver, i.e.: ojdbc6.jar and place it in the following directory:

\data-integration\libext\JDBC

 

Naming convention:

o - Oracle

jdbc - Java database connectivity

6 - Java 6 (1.6)

 

 

 

Information about the connection string can be found on the Penaho's wiki website:

http://wiki.pentaho.com/display/EAI/Oracle

 

 

 

Use one of the examples or copy a section from the tnsnames.ora file:

 

 

 

Place the connection string in the "Database Name" field, the "Port Number" can be omitted or set to "-1".

 

 

Press the "Test" button.