Exasol is a high-performant in-memory SQL database designed for analytics. With UI Bakery you can build applications on top of your Exasol database in just a couple of minutes.
When you are on your Exasol databases list page, expand the cluster you want to connect to and click Connect via Tools:
Connecting UI Bakery to Exasol via tools
If you are using UI Bakery cloud, enter
220.127.116.11as the whitelisted IP. For a self-hosted instance, enter the IP of your instance.
Whitelisting UI Bakery IP in Exasol
Click Next, and skip the next
Download driverscreen by clicking Next.
On the next screen, click
Generate Personal Access Tokenand store your new Exasol connection credentials:
Exasol connection credentials
Go to the data sources page, click Connect button, and select Exasol from the list of data sources.
UI Bakery connects to Exasol using JDBC. This means that you will need to create the following JDBC connection string
jdbc:exa:<Connection string from credentials>:<Port from credentials>. For instance:
Use the username and password you generated in the Exasol admin console and click Connect Datasource:
Connecting Exasol in UI Bakery
Currently, UI Bakery only supports SQL query action step when working with Exasol data sources.
Executing query to Exasol in UI Bakery