Once you have Set up native (JDBC) or OCI data connections for the Pentaho Server, there are configuration and maintenance tasks that you need to perform.
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 Components Reference 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/
- PDI client: data-integration/lib
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\
|Use the sqljdbc_auth.dll file here:
|64-bit JVM on a x64 processor
|64-bit JVM on an Itanium processor