Skip to main content
Version Pentaho
Hitachi Vantara Lumada and Pentaho Documentation

Set Up Native (JDBC) or OCI Data Connections for the Pentaho Server

  1. Last updated
  2. Save as PDF

Once you have chosen to use either the Native (JDBC) or OCI access protocol, there are configuration and maintenance tasks that you need to perform.

Add Drivers

The Pentaho Server needs the appropriate driver to connect to the database that stores your data. Your database administrator, Chief Intelligence Officer, or IT manager should be able to provide the appropriate driver. If not, you can download drivers from your database vendor's website. The Supported Technologies section contains a list of drivers.

Once you have the correct driver, copy it to the following directories:

  • Pentaho Server: /pentaho/server/pentaho-server/tomcat/lib/
  • Spoon: data-integration/lib 

You must restart Spoon for the driver to take effect.

There should be only one driver for your database in the directory. Ensure that there are no other versions of the same vendor's driver in this directory. If there are, back up the old driver files and remove them to avoid version conflicts. This is a concern when you are adding a driver for the same database type as your Pentaho Repository. If you have any concerns about how to proceed, contact Pentaho Support.

When the driver files are in place, restart the server.

Driver for Microsoft SQL Server

If you are using a Microsoft SQL Server (MSSQL), you might need to use an alternative, non-vendor-supported driver called JTDS. Contact Pentaho Support to ensure that you are adding the correct driver.

For Microsoft Windows, most JDBC drivers support Type 2 integrated authentication through the integratedSecurity connection string property. To use integrated authentication, copy the sqljdbc_auth.dll file to all machines and directories to which you copied the JDBC driver. You can find this file in the following location:

<installation directory>\sqljdbc_<version>\<language>\auth\
If running: Use the sqljdbc_auth.dll file here:
64-bit JVM on a x64 processor x64 folder
64-bit JVM on an Itanium processor IA64 folder