JDBC drivers reference

This reference will be removed from the product. For JDBC driver questions, contact your database vendor or the Support Portal.

This reference can change. Report issues using the Support Portal.

JDBC driver download links

Database	Vendor	URL
Amazon Redshift	Amazon	http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html
AWS Aurora	Amazon	Aurora is MySQL- and PostgreSQL-compatible. Use the MySQL or PostgreSQL driver.
AWS Athena	Amazon Web Services	https://docs.aws.amazon.com/athena/latest/ug/jdbc-v3-driver.html
Caché1	InterSystems	http://www.cachemonitor.de/intersystems-documentation/cache-jdbc-driver
CUBRID	CUBRID	http://www.cubrid.org/?mid=downloads&item=jdbc_driver
Daffodil DB	Daffodil Software	http://sourceforge.net/projects/daffodildb/
DB2 AS/400	IBM	https://www-03.ibm.com/systems/power/software/i/toolbox/downloads.html
DB2 Universal Database	IBM	http://www-01.ibm.com/support/docview.wss?uid=swg21363866
Firebird	Firebird Foundation	http://www.firebirdsql.org/en/jdbc-driver/
FrontBase	FrontBase	http://www.frontbase.com/cgi-bin/WebObjects/FBWebSite
Google BigQuery	Google BigQuery	https://cloud.google.com/bigquery
Greenplum	EMC2	http://jdbc.postgresql.org/download.html
H2 Database	H2	http://www.h2database.com
Hive1	Apache	http://hive.apache.org/
Hive2	Apache	http://hive.apache.org/
HSQLDB	HyperSQL	http://sourceforge.net/projects/hsqldb/
Impala	Cloudera	https://www.cloudera.com/documentation.html
Informix	IBM	https://www-01.ibm.com/software/data/informix/
Ingres1	Actian	http://esd.actian.com/product/drivers/JDBC/java
InterBase1	Embarcadero	http://edn.embarcadero.com
jTDS Free MS SQL Sybase1	jTDS	http://jtds.sourceforge.net/
MariaDB	MariaDB	https://downloads.mariadb.org/connector-java/
MaxDB	SAP	http://maxdb.sap.com
Mckoi SQL Database	Mckoi SQL Database	http://www.mckoi.com/originalmckoisql/index.html
Mimer	Mimer Information Technology	http://www.mimer.com
MySQL	Oracle	https://dev.mysql.com/downloads/connector/j/
Neoview1	HP	Contact your local HP representative for information on this product.
Netezza	IBM	http://www.netezza.com
OpenBase SQL	OpenBase International	http://www.openbase.com/index.php/products/downloads
Oracle	Oracle	http://www.oracle.com/technetwork/database/features/jdbc/index.html
Pervasive	Pervasive	http://www.pervasivedb.com/download/Pages/PDBDownloads.aspx
PostgreSQL	PostgreSQL Global Development Group	http://jdbc.postgresql.org/
SAP ASE (formerly Sybase ASE)1	SAP	https://support.sap.com/swdc
SAP DB	SAP MaxDB	https://support.sap.com/software.html
SAP HANA	SAP	http://help.sap.com/hana
SAP SQL Anywhere	SAP	https://support.sap.com/software.html
SmallSQL	SmallSQL	http://www.smallsql.de/download.html
Snowflake	Snowflake	https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc
SQLite	Xerial	http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC
SQL Server	Microsoft	http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
Teradata	Teradata	http://downloads.teradata.com/download/connectivity/jdbc-driver
Vertica1	HP	http://www.vertica.com

¹ Deprecated beginning in version 11.0.

Driver details by database

Amazon Redshift

Vendor Name	Details
Recommended Native Driver
Amazon Web Services	Company URL: http://aws.amazon.com/redshift/
Driver URL: https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC4.jar
JDBC URL Syntax by Type: jdbc:redshift://<endpoint>:<port>/<database>?tcpKeepAlive=true	Default Port: 5439
JDBC Class: com.amazon.redshift.jdbc4.Driver	JDBC JAR File Name: RedshiftJDBC4.jar
Comments: Download and use only the RedshiftJDBC4.jar.

AWS Athena

Vendor Name	Details
Recommended Native Driver
Amazon Web Services	Company URL: https://aws.amazon.com/athena/
Driver URL: https://docs.aws.amazon.com/athena/latest/ug/jdbc-v3-driver.html
JDBC URL Syntax by Type: jdbc:athena://WorkGroup=<workgroup>;Region=<region>;Catalog=<catalog>;Database=<database>;OutputLocation=<outputlocation>;CredentialsProvider=<credentialsprovider>	Default Port: N/A
JDBC Class: com.amazon.athena.jdbc.AthenaDriver	JDBC JAR File Name: athena-jdbc-3.2.0-with-dependencies.jar
Comments: Download the athena-jdbc-3.2.0-with-dependencies.jar file from https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/3.2.0/athena-jdbc-3.2.0-with-dependencies.jar. See https://docs.aws.amazon.com/sdk-for-java/v1/developer-guide/credentials.html#credentials-default regarding credentials.

Cache (Caché)

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
InterSystems	Company URL: http://www.cachemonitor.de
Driver URL: http://www.cachemonitor.de/intersystems-documentation/cache-jdbc-driver
JDBC URL Syntax by Type: Server jdbc:Cache://<server>[:<port>]/<namespace>	Default Port: 1972
JDBC Class: com.intersys.jdbc.CacheDriver	JDBC JAR File Name: cachedb.jar

CUBRID

Vendor Name	Details
Recommended Native Driver
CUBRID	Company URL: http://www.cubrid.org
Driver URL: http://www.cubrid.org/?mid=downloads&item=jdbc_driver
JDBC URL Syntax by Type: Server jdbc:cubrid:<server>:<port>: <databaseName>:<username>: <password> :[?<URL attribute>=<value> [&<URL attribute>=<value>] … ]	Default Port: 33000
JDBC Class: cubrid.jdbc.driver.CUBRIDDriver	JDBC JAR File Name: N/A
Comments: Open source database highly optimized for Web applications.

Daffodil DB

Vendor Name	Details
Recommended Native Driver
Daffodil Software	Company URL: http://db.daffodilsw.com
Driver URL: http://sourceforge.net/projects/daffodildb/
JDBC URL Syntax by Type: Server jdbc:daffodilDB://<server>[:<port>]/<databaseName> Embedded jdbc:daffodilDB_embedded:<databaseName>	Default Port: 3456 N/A
JDBC Class: in.co.daffodil.db.rmi.RmiDaffodilDBDriver in.co.daffodil.db.jdbc.DaffodilDBDriver	JDBC JAR File Name: DaffodilDB_client.jar DaffodilDB_Embedded.jar, DaffodilDB_Common.jar
Comments: Open source database.

DB2 AS/400

Vendor Name	Details
Recommended Native Driver
IBM	Company URL: http://www.ibm.com
Driver URL: http://www-01.ibm.com/support/docview.wss?uid=swg21363866 http://www-03.ibm.com/systems/power/software/i/toolbox/downloads.html
JDBC URL Syntax by Type: Server jdbc:as400://<server>naming=sql;errors=full	Default Port: N/A
JDBC Class: com.ibm.as400.access.AS400JDBCDriver	JDBC JAR File Name: jt400.jar

DB2 Universal Database

Vendor Name	Details
Recommended Native Driver
IBM	Company URL: http://www.ibm.com
Driver URL: http://www-01.ibm.com/support/docview.wss?uid=swg21363866
JDBC URL Syntax by Type: Server jdbc:db2://<server>[:<port>]/<databaseName>[:<URL attribute>=<value>;<URL attribute>=<value>]	Default Port: 50000
JDBC Class: com.ibm.db2.jcc.DB2Driver	JDBC JAR File Name: db2jcc4.jar

Firebird

Vendor Name	Details
Recommended Native Driver
Firebird Foundation	Company URL: http://www.firebirdsql.org
Driver URL: http://www.firebirdsql.org/en/jdbc-driver/
JDBC URL Syntax by Type: Server jdbc:firebirdsql:<server>[/<port>]:/<database-file> (JDBC Type 4, official format) Server jdbc:firebirdsql://<server>[:<port>]/<database-file> (JDBC Type 4, compatibility format) Server jdbc:firebirdsql:native//<server>[/<port>]:/<database-file> (JDBC Type 2, compatibility format) Server jdbc:firebirdsql:native://<server>[:<port>]/<database-file> JDBC Type 2, compatibility format. Requires libraries) Embedded jdbc:firebirdsql:embedded:/<local-database-file> (JDBC Type 2, compatibility format. Requires libraries)	Default Port: 3050 3050 3050 3050 N/A
JDBC Class: org.firebirdsql.jdbc.FBDriver	JDBC JAR File Name: jaybird-full-xxx.jar
Shipped with Pentaho products: Pentaho Data Integration

FrontBase

Vendor Name	Details
Recommended Native Driver
FrontBase	Company URL: http://www.frontbase.com
Driver URL: http://www.frontbase.com/cgi-bin/WebObjects/FBWebSite
JDBC URL Syntax by Type: Server jdbc:FrontBase://<host>[:<port>]/<databaseName>	Default Port: N/A
JDBC Class: com.frontbase.jdbc.FBJDriver	JDBC JAR File Name: frontbasejdbc.jar

Google BigQuery

Vendor Name	Details
Recommended Native Driver
Google BigQuery	For installation instructions, see Google BigQuery.
Company URL: https://cloud.google.com/bigquery
Driver URL: https://cloud.google.com/bigquery/partners/simba-drivers/
Host URL: https://bigquery.googleapis.com/discovery/v1/apis/bigquery/v2/rest
Default Port: 443
Simba JDBC Driver URL: https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.25.1029.zip

Greenplum

Vendor Name	Details
Recommended Native Driver
Greenplum	Company URL: http://greenplum.org/
Driver URL: http://jdbc.postgresql.org/download.html
JDBC URL Syntax by Type: Server jdbc:postgresql://<server>[:<port>]/<databaseName>	Default Port: 5342
JDBC Class: org.postgresql.Driver	JDBC JAR File Name: postgresql-8.x-xxx.jdbc4.jar
Comments: Greenplum uses the Postgresql JDBC driver.

H2 Database

Vendor Name	Details
Recommended Native Driver
H2	Company URL: http://www.h2database.com
Driver URL: http://www.h2database.com
JDBC URL Syntax by Type: Server jdbc:h2:tcp://server[:port]/file-path Embedded jdbc:h2:file-name	Default Port: 9092 N/A
JDBC Class: jdbc:h2:tcp://server[:port]/file-path org.h2.Driver	JDBC JAR File Name: h2-x.x.xxx.jar
Shipped with Pentaho products: Pentaho Server Pentaho Data Integration Pentaho Metadata Editor Pentaho Report Designer
Comments: Open source Java SQL database.

Hive

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
Apache	Company URL: http://hive.apache.org/
Driver URL: https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html or https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc
JDBC URL Syntax by Type: Server jdbc:hive://<server>[:<port>]/default	Default Port: 10000
JDBC Class: org.apache.hadoop.hive.jdbc. HiveDriver	JDBC JAR File Name: pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar
Shipped with Pentaho products: Pentaho Server Pentaho Data Integration Pentaho Metadata Editor Pentaho Report Designer
Comments: The pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar library includes a proxy driver. The actual Hive JDBC implementation for the specific distribution and version of Hadoop is located in the Pentaho driver for that distro. See the Install Pentaho Data Integration and Analytics document for more information. Hive does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.

Hive2

Vendor Name	Details
Recommended Native Driver
Apache	Company URL: http://hive.apache.org/
Driver URL: https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html or https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc
JDBC URL Syntax by Type: Server jdbc:hive2://<server>[:<port>]/<db>	Default Port: 10000
JDBC Class: org.apache.hive.jdbc. HiveDriver	JDBC JAR File Name: pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar
Shipped with Pentaho products: Pentaho Server Pentaho Data Integration Pentaho Metadata Editor Pentaho Report Designer
Comments: The pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar library includes a proxy driver. The actual Hive JDBC implementation for the specific distribution and version of Hadoop is located in the Pentaho driver for that distro. See the Install Pentaho Data Integration and Analytics document for more information. Hive2 does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.

HSQLDB

Vendor Name	Details
Recommended Native Driver
HyperSQL	Company URL: http://www.hsqldb.org
Driver URL: http://sourceforge.net/projects/hsqldb/
JDBC URL Syntax by Type: Server jdbc:hsqldb:hsql://<server>[:<port>]/<databaseName> Embedded Memory jdbc:hsqldb:mem:<databaseName> Embedded File jdbc:hsqldb:file:<database-file>	Default Port: 9001 N/A N/A
JDBC Class: org.hsqldb.jdbcDriver	JDBC JAR File Name: hsqldb.jar
Shipped with Pentaho products: Pentaho User Console Pentaho Server Pentaho Aggregation Designer Pentaho Data Integration Pentaho Metadata Editor Pentaho Report Designer

Impala

Vendor Name	Details
Recommended Native Driver
Cloudera	Company URL: http://cloudera.com
Driver URL: Built in
JDBC URL Syntax by Type: jdbc:hive2://<server>[<port>]/;auth=noSasl	Default Port: 21050
JDBC Class: org.apache.hadoop.hive.jdbc. HiveDriver	JDBC JAR File Name: pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar
Shipped with Pentaho products: Pentaho Server Pentaho Data Integration Pentaho Metadata Editor Pentaho Report Designer
Comments: The pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar library isncludesa proxy driver. The actual Hive JDBC implementation for the specific distribution and version of Hadoop is located in the Pentaho driver for that distro. See the Install Pentaho Data Integration and Analytics document for more information. Hive does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.

Informix

Vendor Name	Details
Recommended Native Driver
IBM	Company URL: http://www.ibm.com
Driver URL: http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc
JDBC URL Syntax by Type: Server jdbc:informix-sqli://<server>[:<port>]/<databaseName>:informixserver= <dbservername>	Default Port:1533
JDBC Class: com.informix.jdbc.IfxDriver	JDBC JAR File Name: ifxjdbc.jar

Ingres

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
Actian	Company URL: http://www.actian.com/
Driver URL: http://esd.actian.com/product/drivers/JDBC/java
JDBC URL Syntax by Type: Server jdbc:ingres://<server>[:<port>]/<databaseName>	Default Port: 21071
JDBC Class: com.ingres.jdbc.IngresDriver	JDBC JAR File Name: iijdbc.jar
Comments: Open source relational database management system.

InterBase

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
Embarcadero	Company URL: http://edn.embarcadero.com
Driver URL: N/A
JDBC URL Syntax by Type: Server jdbc:interbase://<server>/<full_db_path>	Default Port: N/A
JDBC Class interbase.interclient.Driver	JDBC JAR File Name: interclient.jar

jTDS Free MS SQL Sybase

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
jTDS	Company URL: http://jtds.sourceforge.net/
Driver URL: N/A
JDBC URL Syntax by Type: SQL Server jdbc:jtds:<server_type>//<server>[:<port>][/<database>][;<property>=<value>[;...]]] Sybase jdbc:jtds:<server_type>://<server>[:<port>][/<database>]	Default Port: 1433 7100
JDBC Class: interbase.interclient.Driver	JDBC JAR File Name: jtds-x.x.x.jar
Shipped with Pentaho products: Pentaho User Console Pentaho Server Pentaho Aggregation Designer Pentaho Data Integration Pentaho Metadata Editor Pentaho Report Designer

MariaDB

Vendor Name	Details
Recommended Native Driver
MariaDB	Company URL: http://mariadb.org
Driver URL: https://downloads.mariadb.org/connector-java/
JDBC URL Syntax by Type: Server jdbc:mariadb://<hostname>[,<failoverhost>][:<port>] /<dbname>[?<URL attribute>=<value>[&<URL attribute>=<value>] ... ]	Default Port: 3306
	JDBC Class: org.mariadb.jdbc.Driver	JDBC JAR File Name: mariadb-java-client-2.1.2.jar

MaxDB

Vendor Name	Details
Recommended Native Driver
SAP	Company URL: http://www.sap.com
Driver URL: http://maxdb.sap.com
JDBC URL Syntax by Type: Server jdbc:sapdb://<server>[:<port>]/<databaseName>	Default Port: 7210
JDBC Class: com.sap.dbtech.jdbc.DriverSapDB	JDBC JAR File Name: sapdbc.jar
Comments: Database management system developed and supported by SAP AG.

Mckoi SQL Database

Vendor Name	Details
Recommended Native Driver
Mckoi	Company URL: http://www.mckoi.com
Driver URL: http://www.mckoi.com/originalmckoisql/index.html
JDBC URL Syntax by Type: Server jdbc:mckoi://<server>[:<port>][/<schema>]/	Default Port: 9157
JDBC Class: com.mckoi.JDBCDriver	DBC JAR File Name: mckoidb.jar
Comments: Open source SQL database written in Java.

Mimer

Vendor Name	Details
Recommended Native Driver
Mimer Information Technology	Company URL: http://www.mimer.com
Driver URL: N/A
JDBC URL Syntax by Type: Server jdbc:mimer:<protocol>://<server>[:<port>]/<database>	Default Port: 1360
JDBC Class: com.mimer.jdbc.Driver	JDBC JAR File Name: mimer.jar

MySQL

Vendor Name	Details
Recommended Native Driver
Oracle	Company URL: http://www.mysql.com
Driver URL: https://dev.mysql.com/downloads/connector/j/
JDBC URL Syntax by Type: Server jdbc:mysql://<hostname>[,<failoverhost>][:<port>] /<dbname>[?<URL attribute>=<value>[&<URL attribute>=<value>] ... ]	Default Port: 3306
JDBC Class: com.mysql.jdbc.Driver (official class name) org.gjt.mm.mysql.Driver (older class name)	JDBC JAR File Name: mysql-connector-java-8.0.26 (official JAR filename) mysql-connector-java-5.x.xx-bin.jar (older JAR filename)
Comments: Version 8.026 is certified, version 5.7 is supported.

Neoview

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
HP	Company URL: http://www.hp.com
Driver URL: http://storiedigitali.live/hp-neoview-jdbc-63.html
JDBC URL Syntax by Type: Server jdbc:hpt4jdbc://<system>[:<port>]/[:][<URL attribute>=<value>[;<URL attribute>=<value> …]	Default Port: 18650
JDBC Class: com.hp.t4jdbc.HPT4Driver	JDBC JAR File Name: N/A

Netezza

Vendor Name	Details
Recommended Native Driver
IBM	Company URL: http://www.netezza.com
Driver URL: N/A
JDBC URL Syntax by Type: jdbc:netezza://<server>[:<port>]/<database>	Default Port: 5480
JDBC Class: org.netezza.Driver	JDBC JAR File Name: N/A

OpenBase SQL

Vendor Name	Details
Recommended Native Driver
OpenBase International	Company URL: http://www.openbase.com
Driver URL: http://www.openbase.com/index.php/products/downloads
JDBC URL Syntax by Type: Server jdbc:openbase://<server>/<databaseName>	Default Port: N/A
JDBC Class: com.openbase.jdbc.ObDriver	JDBC JAR File Name: OpenBaseJDBC.jar

Oracle

Vendor Name	Details
Recommended Native Driver
Oracle	Company URL: http://www.oracle.com
Driver URL: http://www.oracle.com/technetwork/database/features/jdbc/index.html
JDBC URL Syntax by Type: Thin Server jdbc:oracle:thin:@<server>[:<port>]: <sid> OCI Server jdbc:oracle:oci:@<server>[:<port>]: <sid>	Default Port: 1521
JDBC Class: oracle.jdbc.driver.OracleDriver oracle.jdbc.OracleDriver	JDBC JAR File Name: ojdbcx.jar orai18n.jar
Comments: The OCI server requires OCI libraries.

Pervasive

Vendor Name	Details
Recommended Native Driver
Pervasive	Company URL: http://www.pervasivedb.com/Pages/default.aspx
Driver URL: http://www.pervasivedb.com/download/Pages/PDBDownloads.aspx
JDBC URL Syntax by Type: Server jdbc:pervasive://<server>[:<port>]/<datasource>	Default Port: 1583
JDBC Class: com.pervasive.jdbc.v2.Driver	JDBC JAR File Name: N/A
Shipped with Pentaho products: Pentaho Data Integration Pentaho Report Designer
Comments: The data source is the ODBC DSN.

PostgreSQL

Vendor Name	Details
Recommended Native Driver
PostgreSQL Global Development Group	Company URL: http://www.postgresql.org/
Driver URL: http://jdbc.postgresql.org/
JDBC URL Syntax by Type: Server jdbc:postgresql://<server>[:<port>]/<databaseName>	Default Port: 5342
JDBC Class: org.postgresql.Driver	JDBC JAR File Name: postgresql-9.x-xxx.jdbc4.2.jar
Shipped with Pentaho products: Pentaho Data Integration Pentaho Report Designer

SAP ASE (formerly Sybase ASE)

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
SAP	Company URL: https://www.sap.com/products/sybase-ase.html
Driver URL: The jConnect JDBC driver can only be installed from the SAP Adaptive Server Enterprise Installer. See the SAP website for more information.
JDBC URL Syntax by Type: Server jdbc:sybase:Tds:<server>[:<port>]/<databaseName>	Default Port: 5000
JDBC Class: com.sybase.jdbc4.jdbc.SybDriver	JDBC JAR File Name: N/A
Comments: The open source jTDS driver works with SAP ASE (formerly Sybase) as well. Note that although you can use jTDS open source JDBC driver, we recommend that you use the SAP-supplied JDBC driver instead. Connections might not work reliably if you use the jTDS JDBC driver.

SAP DB

Vendor Name	Details
Recommended Native Driver
SAP DB	Company URL: N/A
Driver URL: http://www.sapdb.org/sap_db_jdbc.htm
JDBC URL Syntax by Type: Server jdbc:sapdb://<server>/<database_name>	Default Port: N/A
JDBC Class: com.sap.dbtech.jdbc.DriverSapDB	JDBC JAR File Name: sapdbc-x.x.x.jar
Shipped with Pentaho products: Pentaho Data Integration
Comments: FREE Enterprise Open Source Database.

SAP HANA

Vendor Name	Details
Recommended Native Driver
SAP HANA	Company URL: http://hana.sap.com
Driver URL: For SAP customers, the driver is part of your client tools. Contact your SAP representative for more information.
JDBC URL Syntax by Type: Server jdbc:sap://<server>:<port>/?autocommit=false	Default Port: 30015
JDBC Class: com.sap.db.jdbc.Driver	JDBC JAR File Name: ngdbc.jar
Comments: Note that the default port number is '30015' where '00' is the instance of the machine you are connecting to. For example, you can connect to the same machine using '30015', '30115', or '31015'.

SAP SQL Anywhere

Vendor Name	Details
Recommended Native Driver
SAP	Company URL: https://www.sap.com/products/sql-anywhere.html
Driver URL: The jConnect JDBC driver can only be installed from the SAP Adaptive Server Enterprise Installer. Visit the SAP website for more information.
JDBC URL Syntax by Type: Server jdbc:sybase:Tds:<server>[:<port>]/<databaseName>	Default Port: 2638
JDBC Class: com.sybase.jdbc4.jdbc.SybDriver	JDBC JAR File Name: N/A
Comments: This open source jTDS driver works with SAP ASE (formerly Sybase) as well. Note that although you can use jTDS open source JDBC driver, we recommend that you use the SAP-supplied JDBC driver instead. Connections might not work reliably if you use the jTDS JDBC driver.

SmallSQL

Vendor Name	Details
Recommended Native Driver
SmallSQL	Company URL: http://www.smallsql.de/
Driver URL: http://www.smallsql.de/download.html
JDBC URL Syntax by Type: Embedded jdbc:smallsql:databaseName[?URL attribute=value[URLattribute=value]…]	Default Port: N/A
JDBC Class: smallsql.database.SSDriver	JDBC JAR File Name: smallsql.jar
Comments Java desktop SQL database engine.

Snowflake

Vendor Name	Details
Recommended Native Driver
Snowflake	Company URL: http://snowflake.com
Driver URL: https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc
JDBC URL Syntax by Type: Embedded jdbc❄️//<account_name>.snowflakecomputing.com/?<connection_params>	Default Port: 443
JDBC Class: net.snowflake.client.jdbc.SnowflakeDriver	JDBC JAR File Name: snowflake-jdbc-3.6.28.jar
Comments: Version 3.13.10 is the minimum version supported. Version 3.13.30 is certified. If timeout errors occur, see Pentaho Data Integration to troubleshoot.

SQLite

Vendor Name	Details
Recommended Native Driver
Xerial	Company URL: N/A
Driver URL: http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC
JDBC URL Syntax by Type: Server jdbc:sqlite:<filename.db>	Default Port: N/A
JDBC Class: org.sqlite.JDBC	JDBC JAR File Name: sqlite-jdbc-x.x.x.jar
Shipped with Pentaho products: Pentaho Data Integration

SQL Server

Vendor Name	Details
Recommended Native Driver
Microsoft	Company URL: http://www.microsoft.com
Driver URL: http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
JDBC URL Syntax by Type: Server jdbc:sqlserver://<server>[:<port>];DatabaseName= <databaseName>	Default Port: 1433
JDBC Class: com.microsoft.sqlserver.jdbc. SQLServerDriver	JDBC JAR File Name: sqljdbc4.jar
Comments: The open source jtds driver also works with MSSQL.

Teradata

Vendor Name	Details
Please see the Teradata JDBC Driver Reference for information about required drivers.
Teradata	Company URL: http://www.teradata.com
Driver URL: http://downloads.teradata.com/download/connectivity/jdbc-driver
JDBC URL Syntax by Type: Server jdbc:teradata://<dbshost>[/<URL attribute>[;<URL attribute>]…]	Default Port: N/A
JDBC Class: com.teradata.jdbc.TeraDriver	JDBC JAR File Name: terajdbc4.jar tdgssconfig.jar

Vertica

Note: Deprecated beginning in version 11.0.

Vendor Name	Details
Recommended Native Driver
HP	Company URL: http://www.vertica.com
Driver URL: http://www.vertica.com/support/myvertica/
JDBC URL Syntax by Type: Server jdbc:vertica://<server>[:<port>]/<databaseName>	Default Port: 5433
JDBC Class: com.vertica.Driver	JDBC JAR File Name: N/A

Install drivers with the JDBC distribution tool

To connect to a database, including the Pentaho Repository database, download and install the JDBC driver:

• In the appropriate Pentaho component directories.

• In the web application server that hosts Pentaho Server.

Due to licensing restrictions, Pentaho cannot redistribute some third-party database drivers. You must download and install those drivers yourself.

1. Download the JDBC driver JAR from your database vendor or a third-party driver developer.

2. Copy the JDBC driver JAR to pentaho/jdbc-distribution.

3. Open a command prompt or shell, then run one of these commands:

   • Windows: distribute-files.bat <jdbc-driver-jar>

   • Linux: ./distribute-files.sh <jdbc-driver-jar>

4. If you ran this utility during installation, continue with your install steps.

5. If you ran this utility to connect to a new repository:

   • Restart Pentaho Server and the design tools.

   • Try the connection again.

   • If the connection still fails, verify driver locations below.

Product	JDBC driver location
Pentaho Server	pentaho/server/pentaho-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