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 location pointed to by the STARDOG_EXT environment variable 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, only the listed drivers are supported. When using unsupported drivers, you may set the sql.dialect virtual graph option to control how Stardog translates SPARQL queries to SQL.
| 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: - avro-1.11.1.jar - GoogleBigQueryJDBC42.jar - google-api-services-bigquery-v2-rev20220730-2.0.0.jar - google-cloud-bigquerystorage-2.19.0.jar - grpc-google-cloud-bigquerystorage-v1-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-12.8.1.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 |
Listing Installed Drivers
The list of installed drivers can be found using the Stardog Designer application. To do so, add a new Project Resource and click “Proceed” on the Virtual Graph panel. A new page will be displayed with one panel for each detected driver.