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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pdia-try-pdia/jdbc-drivers-reference.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.