Exasol

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.

Creating Exasol credentials for UI Bakery

When you are on your Exasol databases list page, expand the cluster you want to connect to and click Connect via Tools:

If you are using UI Bakery cloud, enter 52.176.109.125 as the whitelisted IP. For a self-hosted instance, enter the IP of your instance.

Click Next, and skip the next Download driver screen by clicking Next.

On the next screen, click Generate Personal Access Token and store your new Exasol connection credentials:

Connecting to Exasol from UI Bakery

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:

jdbc:exa:xxxxxxxxxxxxxxxxxxxxxxxxxx.clusters.exasol.com:8563

Use the username and password you generated in the Exasol admin console and click Connect Datasource:

Executing Exasol queries in UI Bakery

Currently, UI Bakery only supports SQL query action step when working with Exasol data sources.

SQL query