Hitachi Vantara Pentaho Community Wiki
Child pages
  • Why you should avoid ODBC?
Skip to end of metadata
Go to start of metadata

It is our recommendation to use JDBC drivers over ODBC drivers with Pentaho software. You should only use ODBC, when there is no JDBC driver available for the desired data source.

ODBC connections use the JDBC-ODBC bridge that is bundled with Java, and has performance impacts and can lead to unexpected behaviors with certain data types or drivers. Additionally, deploying ODBC connections require additional configuration in the Operating System, where JDBC settings are stored natively in Pentaho.

The JDBC-ODBC bridge driver was removed in Java 8, preventing ODBC drivers from being usable in newer versions of Pentaho or other Java-based applications.

Please contact your Database Administrator or Database Vendor for the correct JDBC driver for your database.

  • No labels

3 Comments

  1. I was using JDBC but had to move to a solution with ODBC because I have to user Windows Authentication. When using ODBC I'm getting a lot of errors due to black spaces that appear in the several variable fields (connection name, table name, etc.)

    Is it possible to use JDBC and Windows Authentication ?

  2. With MS SQL Server and jTDS you can use NTLM, see http://wiki.pentaho.com/display/EAI/MS+SQL+Server

  3. Is it possible to get a connection to Cobol C-ISAM data files using ODBC?