How to create a JDBC connection to a relational database

Owned by DevPortal Editor (Unlicensed)
Last updated: 09/03/23 by Onesait Platform

To create a new JDBC connection to a RTDB the user has to be an administrator rol.

It is the only rol with access to create RTDB data sources.

To do so, we need to navigate to the option Development -> JDBC Connections Managements (for newer versions this option has been renamed to "Database Connection Management" and it is located in "Dev Tools"):

The JDBC list will show and we will click on create 



We will need to fill the form with the information of the connection.


  • The endpoint to the connection
  • Type of the RTDB
    • Oracle
    • MySQL
    • MariaDB
    • SQLServer
    • Hive
    • Impala
    • PostgreSQL
  • Credentials
  • Public access if needed to other users.
  • Number of simultaneous connections.
  • Maximum number of records queried

We can check the connection works fine with the button created to do so. If the connection has success the next message will appear.



Once created, you can view it on the list. You can also make it public to other users to create an ontology from this RTDB.

Creating an ontology from a relational database and showing it in a dashboard