JDBC drivers

The optimal way for Pentaho to access data is via JDBC.

Most of the Pentaho products come with JDBC drivers for some of the most popular databases. Some (Schema Workbench and Aggregation Designer) are not shipped with drivers, or may not have the driver that you require. Installing a new driver is generally a case of copying the JAR file into the drivers directory, and (re)starting the application.

ProductIncludes drivers by default?Drivers directory
BI ServerYestomcat/common/lib/
Enterprise ConsoleYesenterprise-console/jdbc
Data IntegrationYeslibext/JDBC/
Metadata EditorYeslibext/JDBC/
Report DesignerYeslib/jdbc/
Schema WorkbenchNodrivers/
Aggregation DesignerNodrivers/

Drivers can be acquired through several different means. The easiest is to copy the drivers across from one Pentaho tool to another (e.g. Data Integration to Schema Workbench).

Sun maintains a repository of JDBC drivers, but the sheer volume available can be confusing. Here are some direct links to the drivers we use most often:

  • MySQL
  • PostgreSQL
  • jTDS (for Microsoft SQL Server make sure you get version 1.2.2 which is available on the share drive /share/Software/JDBC Driver Connections/ and Sybase)
  • Oracle (Oracle's FAQ) (FAQ)
Creator: sd on 2009/12/09 12:19
XWiki Enterprise 1.7.2.16857 - Documentation