Pentaho

Hi I'm using Pentaho tool for the ETL Process. Currently we are using JDBC Connection. Instead of JDBC we need to use ODBC Connectivity.  

I setup the ODBC connection in the system level, its working fine.  When I tried to call the Service name in the Pentaho tool facing issue, saying like some driver is missing,

driver class 'sun.jdbc.odbc.jdbcodbcdriver' could not be found. 

Kindly suggest. Also always default port is taking like 1521. 

Hello,
To use ODBC connection definitions with Pentaho (which is a Java program), you'll either need the JDBC/ODBC bridge (which is the class it is reporting it cannot find--and I don't know if it's even available anymore), or you'll need a driver JAR file that looks like JDBC to Pentaho, but can use an ODBC connection definition. I found a number of sites mentioning it with a web search for "jdbc odbc bridge in java"

Personally, I don't think you'd want the performance penalty and other issues related to using the bridge. See this link in particular for information about it:

download.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdk14doc/docs/guide/jdbc/getstart/bridge.doc.html

Note that the recommendation against using it is repeated multiple times.

Hope that's some help,

John