JDBC drivers reference

Company URL:

http://aws.amazon.com/redshift/

Driver URL:

https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC4.jar

JDBC URL Syntax by Type:

Default Port:

5439

JDBC Class:

com.amazon.redshift.jdbc4.Driver

JDBC JAR File Name:

RedshiftJDBC4.jar

Comments:

Download and use only the RedshiftJDBC4.jar.

Company URL:

http://www.ibm.com

Driver URL:

http://db.apache.org/derby/derby_downloads.html

JDBC URL Syntax by Type:

• Server

  jdbc:derby://<server>[:<port>]/<databaseName>[;<URL attribute>=>value>]

• Embedded

  jdbc:derby:<databaseName>[;create=true]

Default Port:

1527

JDBC Class:

org.apache.derby.jdbc.ClientDriver

org.apache.derby.jdbc.EmbeddedDriver

JDBC JAR File Name:

derby.jar

Shipped with Pentaho products:

Pentaho Data Integration

Comments:

Open source database.

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

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:

Comments:

Open source database highly optimized for Web applications.

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.

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:

JDBC Class:

com.ibm.as400.access.AS400JDBCDriver

JDBC JAR File Name:

jt400.jar

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

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

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:

JDBC Class:

com.frontbase.jdbc.FBJDriver

JDBC JAR File Name:

frontbasejdbc.jar

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://cloud.google.com/bigquery/providers/simba-drivers

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.

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.

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 PDI Hadoop Configurations for more information.

Hive does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.

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 PDI Hadoop Configurations for more information.

Hive2 does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.

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

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 PDI Hadoop Configurations for more information.

Hive does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.

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>

1533

JDBC Class:

com.informix.jdbc.IfxDriver

JDBC JAR File Name:

ifxjdbc.jar

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.

Company URL:

http://edn.embarcadero.com

Driver URL:

N/A

JDBC URL Syntax by Type:

• Server

  jdbc:interbase://<server>/<full_db_path>

Default Port:

JDBC Class

interbase.interclient.Driver

JDBC JAR File Name:

interclient.jar

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

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

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.

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.

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

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-5.x.xx-bin.jar

Comments: Version 5.1.x is the most recent version supported.

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:

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:

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:

JDBC Class:

com.openbase.jdbc.ObDriver

JDBC JAR File Name:

OpenBaseJDBC.jar

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.

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:

Shipped with Pentaho products:

• Pentaho Data Integration
• Pentaho Report Designer

Comments:

The data source is the ODBC DSN.

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

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.

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:

JDBC Class:

com.sap.dbtech.jdbc.DriverSapDB

JDBC JAR File Name:

sapdbc-x.x.x.jar

Shipped with Pentaho products:

Comments:

FREE Enterprise Open Source Database.

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'.

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:

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.

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:

JDBC Class:

smallsql.database.SSDriver

JDBC JAR File Name:

smallsql.jar

Comments

Java desktop SQL database engine.

Company URL:

http://snowflake.com

Driver URL:

https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc

JDBC URL Syntax by Type:

• Embedded

  jdbc:snowflake://<account_name>.snowflakecomputing.com/?<connection_params>

Default Port:

JDBC Class:

net.snowflake.client.jdbc.SnowflakeDriver

JDBC JAR File Name:

snowflake-jdbc-3.6.28.jar

Comments: Version 3.6.28 is the minimum version supported. If timeout errors occur, see Snowflake timeout errors to troubleshoot.

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:

JDBC Class:

org.sqlite.JDBC

JDBC JAR File Name:

sqlite-jdbc-x.x.x.jar

Shipped with Pentaho products:

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.

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:

JDBC Class:

com.teradata.jdbc.TeraDriver

JDBC JAR File Name:

terajdbc4.jar

tdgssconfig.jar

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: