How to connect PENTAHO with Oracle Database (12c/11g)

Step 1: Set JAVA environment for PENTAHO

My Computer --> Properties( Click right mouse My Computer) --> Advanced system settings --> Environment Variables --> User Variables --> New

PENTAHO_JAVA=C:\Program Files\Java\jdk1.7.0_79\jre\bin\java.exe

PENTAHO_JAVA_HOME=C:\Program Files\Java\jdk1.7.0_79\jre

Step 2: Download OJDBC 11g and 12c for Oracle Database 11g/12c

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

Example:

12c:

I download JDBC Driver for Oracle Database 12.1.0.2 from  http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html

I choose          ojdbc7.jar (3,698,857 bytes) - (SHA1 Checksum: 7c9b5984b2c1e32e7c8cf3331df77f31e89e24c2)

Certified with JDK7 and JDK 8; It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.

11g:

I download JDBC Driver for Oracle Database 11.2.0.4 from http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

I choose          ojdbc6.jar (2,739,670 bytes) - (SHA1 Checksum: a483a046eee2f404d864a6ff5b09dc0e1be3fe6c)

Certified with JDK 8, JDK 7 and JDK 6: It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.

Step 3: Copy ojdbc6.jar and ojdbc7.jar to directory PENTAHO_HOME/data-integration/lib

 

Step 4: Check your connection

Good luck!

Share this

Vtgdb