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
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!
0 komentar:
Post a Comment