Download and install your JDBC drivers to your Pentaho servers.
Download Drivers and Install with the JDBC Distribution Tool
To connect to a database, including the Pentaho Repository database, you will need to download and install a JDBC driver to the appropriate places for Pentaho components as well as on the the web application server that contains the Pentaho Server(s). Fortunately, the JDBC Distribution Tool makes this process easy.
Due to licensing restrictions, Pentaho cannot redistribute some third-party database drivers. This is why you have to download the file yourself and install it yourself.
- Download a JDBC driver JAR from your database vendor or a third-party driver developer.
- Copy the JDBC driver JAR you just downloaded to the pentaho/jdbc-distribution directory.
- Open a cmd prompt or shell tool, navigate to the pentaho/jdbc-distribution directory and enter one of the following:
distribute-files.bat <name of JDBC driver JAR>
- If you have run this utility as part of the installation process, you are done. Go to the next step of the installation instructions.
- If you have run this utility so that you can connect to a new repository, restart the BA or DI Server and Design tools, then try to connect to the new repository. If you cannot connect, verify that the drivers are installed as shown in this table. Restart your Pentaho Server(s) and Client tools.
|Server or Design Tool||Directory|
|Business Analytics (BA) Server||pentaho/server/biserver-ee/tomcat/lib|
|Data Integration (DI) Server||pentaho/server/data-integration-server/tomcat/lib|
|Pentaho Data Integration (Spoon)||pentaho/design-tools/data-integration/lib|
|Pentaho Report Designer (PRD)||pentaho/design-tools/report-designer/lib/jdbc|
|Pentaho Aggregation Designer (PAD)||pentaho/design-tools/aggregation-designer/drivers|
|Pentaho Schema Workbench (PSW)||pentaho/design-tools/schema-workbench/drivers|
|Pentaho Metadata Editor (PME)||pentaho/design-tools/metadata-editor/libext/JDBC|