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"

Step 2 :

Connection wizard will pop up.
Select database type as Oracle and access type as JDBC.
Click Next.


Step 3 :

Setup Oracle JDBC Settings.
Provide database server host name, port and database sid.
Click Next.

Step 4 :

Provide user name and password to test the connection ( if needed ).
Click Test database connection.

Step 5 :

Connection report will pop up.
Click Finish to create the connection.