# JDBC drivers reference

This reference can change.\
Report issues using the [Support Portal](https://support.pentaho.com).

## 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é<sup>1</sup>                         | 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](http://www.h2database.com/)                          |
| Hive<sup>1</sup>                          | 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/>                                 |
| Ingres<sup>1</sup>                        | Actian                              | <http://esd.actian.com/product/drivers/JDBC/java>                                |
| InterBase<sup>1</sup>                     | Embarcadero                         | [http://edn.embarcadero.com](http://edn.embarcadero.com/)                        |
| jTDS Free MS SQL Sybase<sup>1</sup>       | jTDS                                | <http://jtds.sourceforge.net/>                                                   |
| MariaDB                                   | MariaDB                             | <https://downloads.mariadb.org/connector-java/>                                  |
| MaxDB                                     | SAP                                 | [http://maxdb.sap.com](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](http://www.mimer.com/)                                    |
| MySQL                                     | Oracle                              | <https://dev.mysql.com/downloads/connector/j/>                                   |
| Neoview<sup>1</sup>                       | HP                                  | Contact your local HP representative for information on this product.            |
| Netezza                                   | IBM                                 | [http://www.netezza.com](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)<sup>1</sup> | 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>                |
| Vertica<sup>1</sup>                       | HP                                  | [http://www.vertica.com](http://www.vertica.com/)                                |

<sup>1</sup> Deprecated beginning in version 11.0.

## Driver details by database

### Amazon Redshift

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

### AWS Athena

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

### Cache (Caché)

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

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

### CUBRID

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

### Daffodil DB

| Vendor Name                                                                                                                                                                                                                                                | Details                                                                                                                                                     |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                  |                                                                                                                                                             |
| Daffodil Software                                                                                                                                                                                                                                          | <p>Company URL:</p><p><a href="http://db.daffodilsw.com/"><http://db.daffodilsw.com></a></p>                                                                |
| <p>Driver URL:</p><p><a href="http://sourceforge.net/projects/daffodildb/"><http://sourceforge.net/projects/daffodildb/></a></p>                                                                                                                           |                                                                                                                                                             |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:daffodilDB://\<server>\[:\<port>]/\<databaseName></code></p><ul><li><strong>Embedded</strong></li></ul><p><code>jdbc:daffodilDB\_embedded:\<databaseName></code></p> | <p>Default Port:</p><p>3456</p><p>N/A</p>                                                                                                                   |
| <p>JDBC Class:</p><p><code>in.co.daffodil.db.rmi.RmiDaffodilDBDriver</code></p><p><code>in.co.daffodil.db.jdbc.DaffodilDBDriver</code></p>                                                                                                                 | <p>JDBC JAR File Name:</p><p><code>DaffodilDB\_client.jar</code></p><p><code>DaffodilDB\_Embedded.jar</code>,</p><p><code>DaffodilDB\_Common.jar</code></p> |
| <p>Comments:</p><p>Open source database.</p>                                                                                                                                                                                                               |                                                                                                                                                             |

### DB2 AS/400

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

### DB2 Universal Database

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

### Firebird

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

### FrontBase

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

### Google BigQuery

| Vendor Name                                                                                                                                                                                                                                                         | Details                                                                                                                                                                                 |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                           |                                                                                                                                                                                         |
| Google BigQuery                                                                                                                                                                                                                                                     | For installation instructions, see [Google BigQuery](https://github.com/pentaho/documentation/blob/main/PDIA/11.0/Get%20Started/JDBC%20drivers%20reference/broken-reference/README.md). |
| <p>Company URL:</p><p><a href="https://cloud.google.com/bigquery"><https://cloud.google.com/bigquery></a></p>                                                                                                                                                       |                                                                                                                                                                                         |
| <p>Driver URL:</p><p><a href="https://cloud.google.com/bigquery/partners/simba-drivers/"><https://cloud.google.com/bigquery/partners/simba-drivers/></a></p>                                                                                                        |                                                                                                                                                                                         |
| <p>Host URL:</p><p><a href="https://bigquery.googleapis.com/discovery/v1/apis/bigquery/v2/rest"><https://bigquery.googleapis.com/discovery/v1/apis/bigquery/v2/rest></a></p>                                                                                        |                                                                                                                                                                                         |
| <p>Default Port:</p><p>443</p>                                                                                                                                                                                                                                      |                                                                                                                                                                                         |
| <p>Simba JDBC Driver URL:</p><p><a href="https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.25.1029.zip"><https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.25.1029.zip></a></p> |                                                                                                                                                                                         |

### Greenplum

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

### H2 Database

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

### Hive

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

| Vendor Name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Details                                                                                         |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                 |
| Apache                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | <p>Company URL:</p><p><a href="http://hive.apache.org/"><http://hive.apache.org/></a></p>       |
| <p>Driver URL:</p><p><a href="https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html"><https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html></a></p><p>or</p><p><a href="https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc"><https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc></a></p>                                                                                                                                                         |                                                                                                 |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:hive://\<server>\[:\<port>]/default</code></p>                                                                                                                                                                                                                                                                                                                                                              | <p>Default Port:</p><p>10000</p>                                                                |
| <p>JDBC Class:</p><p><code>org.apache.hadoop.hive.jdbc. HiveDriver</code></p>                                                                                                                                                                                                                                                                                                                                                                                                                     | <p>JDBC JAR File Name:</p><p><code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code></p> |
| <p>Shipped with Pentaho products:</p><ul><li>Pentaho Server</li><li>Pentaho Data Integration</li><li>Pentaho Metadata Editor</li><li>Pentaho Report Designer</li></ul>                                                                                                                                                                                                                                                                                                                            |                                                                                                 |
| <p>Comments:</p><p>The <code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code> 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 <strong>Install Pentaho Data Integration and Analytics</strong> document for more information.</p><p>Hive does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.</p> |                                                                                                 |

### Hive2

| Vendor Name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Details                                                                                         |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                 |
| Apache                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | <p>Company URL:</p><p><a href="http://hive.apache.org/"><http://hive.apache.org/></a></p>       |
| <p>Driver URL:</p><p><a href="https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html"><https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html></a></p><p>or</p><p><a href="https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc"><https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc></a></p>                                                                                                                                                          |                                                                                                 |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:hive2://\<server>\[:\<port>]/\<db></code></p>                                                                                                                                                                                                                                                                                                                                                                | <p>Default Port:</p><p>10000</p>                                                                |
| <p>JDBC Class:</p><p><code>org.apache.hive.jdbc. HiveDriver</code></p>                                                                                                                                                                                                                                                                                                                                                                                                                             | <p>JDBC JAR File Name:</p><p><code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code></p> |
| <p>Shipped with Pentaho products:</p><ul><li>Pentaho Server</li><li>Pentaho Data Integration</li><li>Pentaho Metadata Editor</li><li>Pentaho Report Designer</li></ul>                                                                                                                                                                                                                                                                                                                             |                                                                                                 |
| <p>Comments:</p><p>The <code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code> 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 <strong>Install Pentaho Data Integration and Analytics</strong> document for more information.</p><p>Hive2 does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.</p> |                                                                                                 |

### HSQLDB

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

### Impala

| Vendor Name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Details                                                                                         |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                 |
| Cloudera                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | <p>Company URL:</p><p><a href="http://cloudera.com/"><http://cloudera.com></a></p>              |
| <p>Driver URL:</p><p>Built in</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                 |
| <p>JDBC URL Syntax by Type:</p><p><code>jdbc:hive2://\<server>\[\<port>]/;auth=noSasl</code></p>                                                                                                                                                                                                                                                                                                                                                                                                  | <p>Default Port:</p><p>21050</p>                                                                |
| <p>JDBC Class:</p><p><code>org.apache.hadoop.hive.jdbc. HiveDriver</code></p>                                                                                                                                                                                                                                                                                                                                                                                                                     | <p>JDBC JAR File Name:</p><p><code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code></p> |
| <p>Shipped with Pentaho products:</p><ul><li>Pentaho Server</li><li>Pentaho Data Integration</li><li>Pentaho Metadata Editor</li><li>Pentaho Report Designer</li></ul>                                                                                                                                                                                                                                                                                                                            |                                                                                                 |
| <p>Comments:</p><p>The <code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code> 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 <strong>Install Pentaho Data Integration and Analytics</strong> document for more information.</p><p>Hive does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.</p> |                                                                                                 |

### Informix

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

### Ingres

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

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

### InterBase

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

| Vendor Name                                                                                                                              | Details                                                                                          |
| ---------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------ |
| Recommended Native Driver                                                                                                                |                                                                                                  |
| Embarcadero                                                                                                                              | <p>Company URL:</p><p><a href="http://edn.embarcadero.com/"><http://edn.embarcadero.com></a></p> |
| <p>Driver URL:</p><p>N/A</p>                                                                                                             |                                                                                                  |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:interbase://\<server>/\<full\_db\_path></code></p> | <p>Default Port:</p><p>N/A</p>                                                                   |
| <p>JDBC Class</p><p><code>interbase.interclient.Driver</code></p>                                                                        | <p>JDBC JAR File Name:</p><p><code>interclient.jar</code></p>                                    |

### jTDS Free MS SQL Sybase

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

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

### MariaDB

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

### MaxDB

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

### Mckoi SQL Database

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

### Mimer

| Vendor Name                                                                                                                                           | Details                                                                              |
| ----------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| Recommended Native Driver                                                                                                                             |                                                                                      |
| Mimer Information Technology                                                                                                                          | <p>Company URL:</p><p><a href="http://www.mimer.com/"><http://www.mimer.com></a></p> |
| <p>Driver URL:</p><p>N/A</p>                                                                                                                          |                                                                                      |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:mimer:\<protocol>://\<server>\[:\<port>]/\<database></code></p> | <p>Default Port:</p><p>1360</p>                                                      |
| <p>JDBC Class:</p><p><code>com.mimer.jdbc.Driver</code></p>                                                                                           | <p>JDBC JAR File Name:</p><p><code>mimer.jar</code></p>                              |

### MySQL

| Vendor Name                                                                                                                                                                                                                  | Details                                                                                                                                                                       |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                    |                                                                                                                                                                               |
| Oracle                                                                                                                                                                                                                       | <p>Company URL:</p><p><a href="http://www.mysql.com/"><http://www.mysql.com></a></p>                                                                                          |
| <p>Driver URL:</p><p><a href="https://dev.mysql.com/downloads/connector/j/"><https://dev.mysql.com/downloads/connector/j/></a></p>                                                                                           |                                                                                                                                                                               |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:mysql://\<hostname>\[,\<failoverhost>]\[:\<port>] /\<dbname>\[?\<URL attribute>=\<value>\[&\<URL attribute>=\<value>] ... ]</code></p> | <p>Default Port:</p><p>3306</p>                                                                                                                                               |
| <p>JDBC Class:</p><p><code>com.mysql.jdbc.Driver</code> (official class name)</p><p><code>org.gjt.mm.mysql.Driver</code> (older class name)</p>                                                                              | <p>JDBC JAR File Name:</p><p><code>mysql-connector-java-8.0.26</code> (official JAR filename)</p><p><code>mysql-connector-java-5.x.xx-bin.jar</code> (older JAR filename)</p> |

### Neoview

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

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

### Netezza

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

### OpenBase SQL

| Vendor Name                                                                                                                                        | Details                                                                                    |
| -------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------ |
| Recommended Native Driver                                                                                                                          |                                                                                            |
| OpenBase International                                                                                                                             | <p>Company URL:</p><p><a href="http://www.openbase.com/"><http://www.openbase.com></a></p> |
| <p>Driver URL:</p><p><a href="http://www.openbase.com/index.php/products/downloads"><http://www.openbase.com/index.php/products/downloads></a></p> |                                                                                            |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:openbase://\<server>/\<databaseName></code></p>              | <p>Default Port:</p><p>N/A</p>                                                             |
| <p>JDBC Class:</p><p><code>com.openbase.jdbc.ObDriver</code></p>                                                                                   | <p>JDBC JAR File Name:</p><p><code>OpenBaseJDBC.jar</code></p>                             |

### Oracle

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

### Pervasive

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

### PostgreSQL

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

### SAP ASE (formerly Sybase ASE)

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

| Vendor Name                                                                                                                                                                                                                                                                                        | Details                                                                                                                             |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                                                          |                                                                                                                                     |
| SAP                                                                                                                                                                                                                                                                                                | <p>Company URL:</p><p><a href="https://www.sap.com/products/sybase-ase.html"><https://www.sap.com/products/sybase-ase.html></a></p> |
| <p>Driver URL:</p><p>The jConnect JDBC driver can only be installed from the SAP Adaptive Server Enterprise Installer. See the SAP website for more information.</p>                                                                                                                               |                                                                                                                                     |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:sybase:Tds:\<server>\[:\<port>]/\<databaseName></code></p>                                                                                                                                                   | <p>Default Port:</p><p>5000</p>                                                                                                     |
| <p>JDBC Class:</p><p><code>com.sybase.jdbc4.jdbc.SybDriver</code></p>                                                                                                                                                                                                                              | <p>JDBC JAR File Name:</p><p>N/A</p>                                                                                                |
| <p>Comments:</p><p>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.</p> |                                                                                                                                     |

### SAP DB

| Vendor Name                                                                                                                          | Details                                                        |
| ------------------------------------------------------------------------------------------------------------------------------------ | -------------------------------------------------------------- |
| Recommended Native Driver                                                                                                            |                                                                |
| SAP DB                                                                                                                               | <p>Company URL:</p><p>N/A</p>                                  |
| <p>Driver URL:</p><p><a href="http://www.sapdb.org/sap_db_jdbc.htm"><http://www.sapdb.org/sap_db_jdbc.htm></a></p>                   |                                                                |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:sapdb://\<server>/\<database\_name></code></p> | <p>Default Port:</p><p>N/A</p>                                 |
| <p>JDBC Class:</p><p><code>com.sap.dbtech.jdbc.DriverSapDB</code></p>                                                                | <p>JDBC JAR File Name:</p><p><code>sapdbc-x.x.x.jar</code></p> |
| <p>Shipped with Pentaho products:</p><p>Pentaho Data Integration</p>                                                                 |                                                                |
| <p>Comments:</p><p>FREE Enterprise Open Source Database.</p>                                                                         |                                                                |

### SAP HANA

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

### SAP SQL Anywhere

| Vendor Name                                                                                                                                                                                                                                                                                         | Details                                                                                                                                 |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                                                           |                                                                                                                                         |
| SAP                                                                                                                                                                                                                                                                                                 | <p>Company URL:</p><p><a href="https://www.sap.com/products/sql-anywhere.html"><https://www.sap.com/products/sql-anywhere.html></a></p> |
| <p>Driver URL:</p><p>The jConnect JDBC driver can only be installed from the SAP Adaptive Server Enterprise Installer. Visit the SAP website for more information.</p>                                                                                                                              |                                                                                                                                         |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:sybase:Tds:\<server>\[:\<port>]/\<databaseName></code></p>                                                                                                                                                    | <p>Default Port:</p><p>2638</p>                                                                                                         |
| <p>JDBC Class:</p><p><code>com.sybase.jdbc4.jdbc.SybDriver</code></p>                                                                                                                                                                                                                               | <p>JDBC JAR File Name:</p><p><code>N/A</code></p>                                                                                       |
| <p>Comments:</p><p>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.</p> |                                                                                                                                         |

### SmallSQL

| Vendor Name                                                                                                                                                           | Details                                                                                   |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                             |                                                                                           |
| SmallSQL                                                                                                                                                              | <p>Company URL:</p><p><a href="http://www.smallsql.de/"><http://www.smallsql.de/></a></p> |
| <p>Driver URL:</p><p><a href="http://www.smallsql.de/download.html"><http://www.smallsql.de/download.html></a></p>                                                    |                                                                                           |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Embedded</strong></li></ul><p><code>jdbc:smallsql:databaseName\[?URL attribute=value\[URLattribute=value]…]</code></p> | <p>Default Port:</p><p>N/A</p>                                                            |
| <p>JDBC Class:</p><p><code>smallsql.database.SSDriver</code></p>                                                                                                      | <p>JDBC JAR File Name:</p><p><code>smallsql.jar</code></p>                                |
| <p>Comments</p><p>Java desktop SQL database engine.</p>                                                                                                               |                                                                                           |

### Snowflake

| Vendor Name                                                                                                                                                                                                                                            | Details                                                                                   |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                              |                                                                                           |
| Snowflake                                                                                                                                                                                                                                              | <p>Company URL:</p><p><a href="https://www.snowflake.com/"><http://snowflake.com></a></p> |
| <p>Driver URL:</p><p><a href="https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc"><https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc></a></p>                                                                                       |                                                                                           |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Embedded</strong></li></ul><p><code>jdbc</code><span data-gb-custom-inline data-tag="emoji" data-code="2744">❄️</span><code>//\<account\_name>.snowflakecomputing.com/?\<connection\_params></code></p> | <p>Default Port:</p><p>443</p>                                                            |
| <p>JDBC Class:</p><p><code>net.snowflake.client.jdbc.SnowflakeDriver</code></p>                                                                                                                                                                        | <p>JDBC JAR File Name:</p><p><code>snowflake-jdbc-3.6.28.jar</code></p>                   |

### SQLite

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

### SQL Server

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

### Teradata

| Vendor Name                                                                                                                                                              | Details                                                                                        |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------- |
| Please see the [Teradata JDBC Driver Reference](http://developer.teradata.com/connectivity/reference/jdbc-driver) for information about required drivers.                |                                                                                                |
| Teradata                                                                                                                                                                 | <p>Company URL:</p><p><a href="http://www.teradata.com/"><http://www.teradata.com></a></p>     |
| <p>Driver URL:</p><p><a href="http://downloads.teradata.com/download/connectivity/jdbc-driver"><http://downloads.teradata.com/download/connectivity/jdbc-driver></a></p> |                                                                                                |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:teradata://\<dbshost>\[/\<URL attribute>\[;\<URL attribute>]…]</code></p>          | <p>Default Port:</p><p>N/A</p>                                                                 |
| <p>JDBC Class:</p><p><code>com.teradata.jdbc.TeraDriver</code></p>                                                                                                       | <p>JDBC JAR File Name:</p><p><code>terajdbc4.jar</code></p><p><code>tdgssconfig.jar</code></p> |

### Vertica

{% hint style="info" %}
**Note:** Deprecated beginning in version 11.0.
{% endhint %}

| Vendor Name                                                                                                                                     | Details                                                                                  |
| ----------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                       |                                                                                          |
| HP                                                                                                                                              | <p>Company URL:</p><p><a href="http://www.vertica.com/"><http://www.vertica.com></a></p> |
| <p>Driver URL:</p><p><a href="http://www.vertica.com/support/myvertica/"><http://www.vertica.com/support/myvertica/></a></p>                    |                                                                                          |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:vertica://\<server>\[:\<port>]/\<databaseName></code></p> | <p>Default Port:</p><p>5433</p>                                                          |
| <p>JDBC Class:</p><p><code>com.vertica.Driver</code></p>                                                                                        | <p>JDBC JAR File Name:</p><p><code>N/A</code></p>                                        |

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

{% hint style="info" %}
Due to licensing restrictions, Pentaho cannot redistribute some third-party database drivers.\
You must download and install those drivers yourself.
{% endhint %}

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`  |