Skip to main content

Pentaho+ documentation is moving!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

JDBC drivers reference

AttentionThis reference article will eventually be removed from the product. If you have questions regarding JDBC drivers, contact your vendor or the Support Portal.

This reference is subject to change. You can report any issues with this page to the Support Portal.

DatabaseVendorURL
Amazon RedshiftAmazonhttp://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html
Apache DerbyApachehttp://db.apache.org/derby/derby_downloads.html
CachéInterSystemshttp://www.cachemonitor.de/intersystems-documentation/cache-jdbc-driver
CUBRIDCUBRIDhttp://www.cubrid.org/?mid=downloadsitem=jdbc_driver
Daffodil DBDaffodil Softwarehttp://sourceforge.net/projects/daffodildb/
DB2 AS/400IBMhttps://www-03.ibm.com/systems/power/software/i/toolbox/downloads.html
DB2 Universal DatabaseIBMhttp://www-01.ibm.com/support/docview.wss?uid=swg21363866
FirebirdFirebird Foundationhttp://www.firebirdsql.org/en/jdbc-driver/
FrontBaseFrontBasehttp://www.frontbase.com/cgi-bin/WebObjects/FBWebSite
Google BigQueryGoogle BigQueryhttps://cloud.google.com/bigquery
GreenplumEMC2http://jdbc.postgresql.org/download.html
H2 DatabaseH2http://www.h2database.com
HiveApachehttp://hive.apache.org/
Hive2Apachehttp://hive.apache.org/
HSQLDBHyperSQLhttp://sourceforge.net/projects/hsqldb/
ImpalaClouderahttps://www.cloudera.com/documentation.html
InformixIBMhttps://www-01.ibm.com/software/data/informix/
IngresActianhttp://esd.actian.com/product/drivers/JDBC/java
InterBaseEmbarcaderohttp://edn.embarcadero.com
jTDS Free MS SQL SybasejTDShttp://jtds.sourceforge.net/
MariaDBMariaDB https://downloads.mariadb.org/connector-java/
MaxDBSAPhttp://maxdb.sap.com
Mckoi SQL DatabaseMckoi SQL Databasehttp://www.mckoi.com/originalmckoisql/index.html
MimerMimer Information Technologyhttp://www.mimer.com
MySQLOraclehttps://dev.mysql.com/downloads/connector/j/
NeoviewHPContact your local HP representative for information on this product.
NetezzaIBMhttp://www.netezza.com
OpenBase SQLOpenBase Internationalhttp://www.openbase.com/index.php/products/downloads
OracleOraclehttp://www.oracle.com/technetwork/database/features/jdbc/index.html
PervasivePervasivehttp://www.pervasivedb.com/download/Pages/PDBDownloads. aspx
PostgreSQLPostgreSQL Global Development Grouphttp://jdbc.postgresql.org/
SAP ASE (formerly Sybase ASE)SAPhttps://support.sap.com/swdc
SAP DBSAP MaxDBhttps://support.sap.com/software.html
SAP HANASAPhttp://help.sap.com/hana
SAP SQL AnywhereSAPhttps://support.sap.com/software.html
SmallSQLSmallSQLhttp://www.smallsql.de/download.html
SnowflakeSnowflakehttps://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc
SQLiteXerialhttp://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC
SQL ServerMicrosofthttp://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
TeradataTeradatahttp://downloads.teradata.com/download/connectivity/jdbc-driver
VerticaHPhttp://www.vertica.com

Amazon Redshift

Vendor NameDetails
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.

Apache Derby

Vendor NameDetails
Recommended Native Driver
IBM

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.

Caché

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

Greenplum

Vendor NameDetails
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 NameDetails
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

Vendor NameDetails
Recommended Native Driver
Apache

Company URL:

http://hive.apache.org/

Driver URL:

Built in

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.

Hive2

Vendor NameDetails
Recommended Native Driver
Apache

Company URL:

http://hive.apache.org/

Driver URL:

Built in

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.

HSQLDB

Vendor NameDetails
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 NameDetails
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 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.

Informix

Vendor NameDetails
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

Vendor NameDetails
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

Vendor NameDetails
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

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

Comments: Version 5.7 is supported, .8.026 is certified.

Neoview

Vendor NameDetails
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 NameDetails
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 NameDetails
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 NameDetails
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 NameDetails
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 NameDetails
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)

Vendor NameDetails
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 NameDetails
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 NameDetails
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 NameDetails
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 NameDetails
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 NameDetails
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:snowflake://<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.6.28 is the minimum version supported. If timeout errors occur, see Snowflake timeout errors to troubleshoot.

SQLite

Vendor NameDetails
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 NameDetails
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 NameDetails
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

Vendor NameDetails
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