This page covers the supported client drivers for each supported Data Source type.
<details open markdown="block"> <summary> Page Contents </summary> 1. TOC </details>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/Spark SQL | hive-jdbc-4.0.1-standalone.jar |
| Apache/Cloudera Impala | https://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-42.html |
| AWS Athena 3.x (Amazon) | athena-jdbc-3.6.0-with-dependencies.jar |
| AWS Athena 2.x (Simba) | AthenaJDBC42-2.2.2.1000.jar |
| AWS Aurora | https://dev.mysql.com/downloads/connector/j/5.1.html |
| AWS Redshift | redshift-jdbc42-2.1.0.28.jar |
| Cassandra | cassandra-driver-core-3.6.0-shaded.jar |
| Databricks SQL | DatabricksJDBC42.jar version 2.6.40, included with Stardog as databricks-jdbc-2.6.40.jar, no download required |
| Derby | https://db.apache.org/derby/releases/release-10.14.2.0.cgi |
| Elasticsearch | Three jars are required: <br> - elasticsearch-rest-client-6.7.1.jar <br> - httpasyncclient-4.1.2.jar <br> - httpcore-nio-4.4.5.jar |
| Google BigQuery | The following jars from here: <br> - GoogleBigQueryJDBC42.jar <br> - google-api-services-bigquery-v2-rev20240919-2.0.0.jar <br> - google-cloud-bigquerystorage-3.15.0.jar <br> - grpc-google-cloud-bigquerystorage-v1-3.15.0.jar <br> - proto-google-cloud-bigquerystorage-v1-3.15.0.jar |
| H2 | h2-1.4.196.jar |
| IBM DB2 | 10.x |
| IOMETE | hive-jdbc-4.0.1-standalone.jar |
| 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-j-9.5.0.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.26.1.jar included with Stardog, no download required |
| Spark SQL | Use Apache Hive driver (Databricks has dropped support for the Simba SparkJDBC42.jar) |
| Teradata | version 16.20 |
| Trino | trino-jdbc-417.jar included with Stardog, no download required |
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.