Supported Client Drivers
This page covers the supported client drivers for each supported Data Source type.
Page Contents
To connect to your data sources, Stardog requires you to supply it with the appropriate Client Driver. You need to manually copy the JAR file containing the driver to the <stardog_installation_directory>/server/dbms/ directory (or to the location pointed to by the STARDOG_EXT environment variable if you have set one) so that it will be available to the Stardog server.
Stardog is tested against all supported databases using the following drivers. Stardog requires a JDBC 4.2 compatible client driver. While other drivers may work, your mileage may vary. For best results, set the sql.dialect virtual graph option when using unsupported drivers.
| Database | Driver |
|---|---|
| Apache Hive | jdbc/hive-jdbc-3.1.2-standalone.jar |
| Apache/Cloudera Impala | https://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-42.html |
| AWS Athena | AthenaJDBC42.jar version 2.0.30.1001 |
| AWS Aurora | https://dev.mysql.com/downloads/connector/j/5.1.html |
| AWS Redshift | RedshiftJDBC42-no-awssdk-1.2.20.1043.jar |
| Cassandra | cassandra-driver-core-3.6.0-shaded.jar |
| Databricks SQL | DatabricksJDBC42.jar version 2.6.25, included with Stardog (version 8.1.0 onward) as databricks-jdbc-2.6.25.jar, no download required |
| Derby | https://db.apache.org/derby/releases/release-10.14.2.0.cgi |
| Elasticsearch | Three jars are required: - elasticsearch-rest-client-6.7.1.jar - httpasyncclient-4.1.2.jar - httpcore-nio-4.4.5.jar |
| Google BigQuery | The following jars from here - GoogleBigQueryJDBC42.jar - google-api-services-bigquery-v2-rev20220730-2.0.0.jar - google-cloud-bigquerystorage-2.19.0.jar - proto-google-cloud-bigquerystorage-v1-2.19.0.jar |
| H2 | h2-1.4.196.jar |
| IBM DB2 | 10.x |
| Microsoft SQL Server | mssql-jdbc-11.2.2.jre11.jar included with Stardog, no download required |
| Microsoft Synapse | Driver and support jars are included with Stardog, no download required |
| MongoDB | mongo-java-driver-3.8.2.jar |
| MySQL & MariaDB | mysql-connector-java-8.0.26.jar |
| Oracle | https://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html |
| PostgreSQL | postgresql-42.2.5.jar |
| SAP HANA | ngdbc-2.3.56.jar |
| Snowflake | snowflake-jdbc-3.13.5.jar |
| Spark SQL | SparkJDBC42.jar version 2.6.22 (File is named SparkJDBC42.jar, included in SimbaSparkJDBC42-2.6.22.1040.zip) |
| Sybase ASE | Sybase ASE 16.0 |
| Teradata | version 16.20 |