JDBC stands for Java Database Connectivity - it's a standard Java protocol for connecting to databases. UI Bakery allows you to connect to data sources that don't have native support on the platform but have a JDBC driver.
The Cloud self-service plans of UI Bakery currently only support the following data sources: Exasol, Presto, and SAP Hana. Connecting to other data sources is available on the On-premise or Cloud Enterprise plans.
In order for a custom JDBC driver to work, it needs to be available in the datasource container. The easiest way to do this is to copy the driver to a VM where your datasource container is running and mount it to the container using the docker-compose.yml file:
After that, you need to add the following environment variable to your .env file and restart the instance:
You can also add several drivers, if necessary, separating them by commas.
On the Data sources page, click Connect, and select JDBC in the Data sources list.
Specify the JDBC connection string, for example:
Next, specify Driver name, your username & password and test the connection.
Click Connect Datasource to complete the setup.
Currently, UI Bakery only supports the action step when working with JDBC data sources.
datasource:
container_name: datasource
image: cruibakeryonprem.azurecr.io/cloud/datasource:latest
restart: always
env_file: .env
volumes:
- ~/jdbc-driver-location-host:~/jdbc-driver-location-containerUI_BAKERY_DATASOURCE_JDBC_DRIVER_PATH=~/jdbc-driver-location-container/driver.jarjdbc:<driver type>:<host>:<port>