Ontopic Docs

# Data sources

# Supported data sources

  • AWS Athena
  • AWS Redshift
  • Databricks
  • Denodo
  • Dremio
  • Google BigQuery
  • H2
  • MariaDB
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • Presto
  • Snowflake
  • Trino

# JDBC drivers

JDBC drivers are required for Ontopic Suite to establish connections with the supported data sources.

# Docker-compose

Before running Ontopic Suite, 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 Suite (v2025.1.0) are:

Data source JDBC driver file
Dremio dremio-jdbc-driver-26.0.0-202504290223270716-afdd6663.jar
SQL Server mssql-jdbc-13.2.0.jre11.jar
PostgreSQL postgresql-42.7.7.jar
Snowflake snowflake-jdbc-3.26.0.jar
Databricks DatabricksJDBC42.jar (2.7.3)
H2 h2-2.3.232.jar
MariaDB mariadb-java-client-3.5.5.jar
Oracle ojdbc11.jar (23.9.0.25.07)
Athena AthenaJDBC42-2.1.3.1002.jar
Redshift redshift-jdbc42-2.1.0.34.jar
Presto presto-jdbc-0.293.jar
Trino trino-jdbc-476.jar

The MySQL JDBC Driver is supported but is not included in this distribution due to licensing restrictions. The MySQL JDBC Driver is licensed under the GNU General Public License (GPL) v2. Similarly, the Denodo JDBC Driver is not included in this distribution as it is proprietary.

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 Suite 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 Suite

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 OntopicSuite folder.

# Add a new JDBC driver

Add it to the existing JDBC drivers directory at %localappdata%\OntopicSuite\resources\app.asar.unpacked\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 or create a .env file in %AppData%/OntopicSuite.
Update the environment variable JDBC_ROOT_DIR with the full path of the JDBC driver folder of your choice.

Example:

JDBC_ROOT_DIR=C:\OntopicSuite\jdbc

# AWS Marketplace

  1. Connect on SSH, go to the folder /etc/ontopic-suite/jdbc.
  2. Add your JDBC jar file (e.g. using scp) and remove any conflicting driver, if present.
  3. Restart Ontopic Suite with the command systemctl restart ontopic-suite.service.

← Upgrade →