JDBC driver installation and compatibility
The JDBC driver for your remote datasource and its dependencies must be copied to the jdbc-drivers
subdirectory inside the configuration directory of JDBC nodes (for example elasticsearch/config/jdbc-drivers
).
It is neither required, nor recommended, to copy these drivers to nodes that are not enabled to execute queries.
Name | JDBC class | Notes | Support |
---|---|---|---|
PostgreSQL | org.postgresql.Driver | Download the latest JDBC 4.2 driver from https://jdbc.postgresql.org/download.html and copy the |
|
MySQL | com.mysql.jdbc.Driver | Download the latest GA release from https://dev.mysql.com/downloads/connector/j/, extract it, then copy When writing the JDBC connection string, set the |
|
Microsoft SQL Server 2014 or greater | com.microsoft.sqlserver.jdbc.SQLServerDriver | Download |
|
Sybase ASE 15.7+ | com.sybase.jdbc4.jdbc.SybDriver OR net.sourceforge.jtds.jdbc.Driver | To use the FreeTDS driver, download the latest version from https://sourceforge.net/projects/jtds/files/, extract it, then copy To use the jConnect driver, copy |
|
Oracle 12c+ | oracle.jdbc.OracleDriver | Download the latest |
|
Presto | com.facebook.presto.jdbc.PrestoDriver | Download the latest JDBC driver from https://prestodb.io/docs/current/installation/jdbc.html and copy it to the |
|
Spark SQL 2.2+ | com.simba.spark.jdbc41.Driver | The Magnitude JDBC driver for Spark can be purchased at https://www.simba.com/product/spark-drivers-with-sql-connector/; once downloaded, extract the bundle, then extract the JDBC 4.1 archive and copy the following jars to the
In addition, copy your license file to the |
|
Dremio | com.dremio.jdbc.Driver | Download the jar at https://download.siren.io/dremio-jdbc-driver-1.4.4-201801230630490666-6d69d32.jar and copy it to the |
|
Impala | com.cloudera.impala.jdbc41.Driver | Download the latest JDBC bundle from https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-4.html, extract the bundle, then extract the JDBC 4.1 archive and copy the following jars to the
|
|
Neo4J | org.neo4j.jdbc.http.HttpDriver | Download the following JDBC jar files and place them in the https://search.maven.org/artifact/org.neo4j/neo4j-jdbc-http/3.4.0/jar https://search.maven.org/artifact/org.neo4j/neo4j-jdbc/3.4.0/jar | Reflection only |
Restart the JDBC node after copying the drivers.