# JDBC drivers
JDBC drivers need to be included in Ontopic Studio.
# Docker-compose
Before running the studio, you can include the JDBC drivers in the folder jdbc or you can edit the location of your folder in the .env file adding a variable as:
JDBC_ROOT_DIR=./jdbc
JDBC drivers included in Ontopic Studio (v2024.1.4) are:
| Data source | JDBC driver file |
|---|---|
| Dremio | dremio-jdbc-driver-24.3.2-202401241821100032-d2d8a497.jar |
| Mssql | mssql-jdbc-12.6.0.jre11.jar |
| Postgresql | postgresql-42.7.2.jar |
| Snowflake | snowflake-jdbc-3.15.0.jar |
| Databricks | DatabricksJDBC42.jar (2.6.36) |
| H2 | h2-2.2.224.jar |
| MariaDB | mariadb-java-client-3.3.3.jar |
| MySQL | mysql-connector-j-8.3.0.jar |
| Oracle | ojdbc11.jar (23.3.0.23.09) |
| Athena | AthenaJDBC42-2.1.3.1002.jar |
| Redshift | redshift-jdbc42-2.1.0.26.jar |
| Presto | presto-jdbc-0.285.1jar |
| Trino | trino-jdbc-439.jar |
BigQuery is also supported, but conflicting with the Dremio driver. To use BigQuery you should add the drivers in the folder jdbc and remove the conflicting Dremio JDBC driver.
Restart Ontopic Studio if it is already running.
# Windows Desktop
Update of the JDBC drivers should be done when the application is not running.
# How to access the local folder of Ontopic Studio
The AppData local folder contains app-specific settings and downloaded software updates.
To access the AppData Local folder press Windows + R buttons to open the Run App.
In the run app text box, enter %localappdata% and click OK. Windows will directly open up the Local folder.
You can now access the OntopicStudio folder.
# Add a new JDBC driver
Add it to the existing JDBC drivers directory at %localappdata%\OntopicStudio\app-2024.1.3\resources\app\src\electron\app\process-server\app\jdbc.
# Use a different directory for JDBC drivers
If you want to use your own directory for JDBC drivers edit the .env.electron file at
%localappdata%\Local\OntopicStudio\app-2024.1.3\resources\app\src\electron.
Update the environment variable JDBC_ROOT_DIR with the full path of the JDBC driver folder of your choice.
Example:
JDBC_ROOT_DIR=C:\OntopicStudio\jdbc
# AWS Marketplace
- Connect on SSH, go to the folder
/etc/ontopic-studio/jdbc. - Add your JDBC jar file (e.g. using
scp) and remove any conflicting driver, if present. - Restart Ontopic studio with the command
systemctl restart ontopic-studio.service.