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.

Configuration

Prerequisites

Before connecting the data source, you first need to create Exasol credentials for UI Bakery. To do so, follow the instruction below:

1. On the Exasol databases list page, expand the cluster you want to connect to, and click Connect via tools.

1. Specify 52.176.109.125 as the whitelisted IP for UI Bakery cloud. For the self-hosted version, specify the IP of your instance.

1. Click Next, and skip the Download driver step.

2. On the next screen, click Generate Personal Access Token, and save your Exasol connection credentials.

Connecting the data source

Now, you're ready to connect your Exasol datasource to UI Bakery. Follow the steps below:

1. On the Data sources page, click Connect, and select Exasol in the Data sources list.

2. Provide the JDBC connection string.

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 example, jdbc:exa:xxxxxxxxxxxxxxxxxxxxxxxxxx.clusters.exasol.com:8563.

1. Specify the username and password you generated in the Exasol admin console, and test the connection.

2. Click Connect Datasource to complete the setup.

Usage

Executing Exasol queries in UI Bakery

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