JDBC drivers reference
This reference can change. Report issues using the Support Portal.
JDBC driver download links
AWS Aurora
Amazon
Aurora is MySQL- and PostgreSQL-compatible. Use the MySQL or PostgreSQL driver.
Neoview1
HP
Contact your local HP representative for information on this product.
1 Deprecated beginning in version 11.0.
Driver details by database
Amazon Redshift
Recommended Native Driver
Amazon Web Services
Company URL:
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
Recommended Native Driver
Amazon Web Services
Company URL:
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.
Recommended Native Driver
InterSystems
Company URL:
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
Recommended Native Driver
CUBRID
Company URL:
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
Recommended Native Driver
Daffodil Software
Company URL:
Driver URL:
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
Recommended Native Driver
IBM
Company URL:
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
Recommended Native Driver
IBM
Company URL:
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
Recommended Native Driver
Firebird Foundation
Company URL:
Driver URL:
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
Recommended Native Driver
FrontBase
Company URL:
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
Recommended Native Driver
Google BigQuery
For installation instructions, see Google BigQuery.
Company URL:
Default Port:
443
Greenplum
Recommended Native Driver
Greenplum
Company URL:
Driver URL:
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
Recommended Native Driver
H2
Company URL:
Driver URL:
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.
Recommended Native Driver
Apache
Company URL:
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
Recommended Native Driver
Apache
Company URL:
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
Recommended Native Driver
HyperSQL
Company URL:
Driver URL:
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
Recommended Native Driver
Cloudera
Company URL:
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
Recommended Native Driver
IBM
Company URL:
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.
Recommended Native Driver
Actian
Company URL:
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.
Recommended Native Driver
Embarcadero
Company URL:
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.
Recommended Native Driver
jTDS
Company URL:
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
Recommended Native Driver
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
Recommended Native Driver
SAP
Company URL:
Driver URL:
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
Recommended Native Driver
Mckoi
Company URL:
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
Recommended Native Driver
Mimer Information Technology
Company URL:
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
Recommended Native Driver
Oracle
Company URL:
Driver URL:
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)
Neoview
Note: Deprecated beginning in version 11.0.
Recommended Native Driver
HP
Company URL:
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
Recommended Native Driver