Link Search Menu Expand Document
Start for Free

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
Trino trino-jdbc-417.jar included with Stardog, no download required