# 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**.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FdxrJwpCUDTyG7Cj0dgii%2Fspaces_UX6zPRMFFK0yrTghj7cY_uploads_git-blob-4ac890e512a645dfe12eb41d007e87427f6c676e_image%20(98).png?alt=media&#x26;token=1f828667-7583-4eb7-bd1d-dc1f6471decf" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FzMATnVshMotScDcONNNA%2Fspaces_UX6zPRMFFK0yrTghj7cY_uploads_git-blob-525c6e0217d417a288adfe9f3c411da61ae56354_image%20(33)-min.png?alt=media&#x26;token=14dabc66-ee67-4015-af37-7c00bc3dd632" alt=""><figcaption></figcaption></figure>

3. Click **Next**, and skip the *Download driver* step.
4. On the next screen, click **Generate Personal Access Token**, and save your Exasol connection credentials.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FvCZ7pY4NlDLCwRxwdxXq%2Fspaces_UX6zPRMFFK0yrTghj7cY_uploads_git-blob-93ae4e89dc52eb3cfeb82ecc1cc2c2c25d9261ec_image%20(92)-min.png?alt=media&#x26;token=b9c2a157-120d-4559-8378-5913b01c152d" alt=""><figcaption></figcaption></figure>

### 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*.

{% hint style="success" %}
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`.
{% endhint %}

3. Specify the *username* and *password* you generated in the Exasol admin console, and test the connection.
4. Click **Connect Datasource** to complete the setup.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FtgKcJ9NTom4LIZeLTm5d%2FCleanShot%202025-04-14%20at%2013.42.43%402x-min.png?alt=media&#x26;token=8e14e73b-4454-4a0d-85f1-5890782be2fe" alt=""><figcaption></figcaption></figure>

## Usage

Currently, UI Bakery supports only the [SQL Query](https://docs.uibakery.io/reference/working-with-actions/sql-query) action step when working with Exasol data sources.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FvP3zv3EjHbAYdOtskLpd%2Fspaces_UX6zPRMFFK0yrTghj7cY_uploads_git-blob-d65658482eea72d98aa98766289df2e037193790_image%20(76)-min.png?alt=media&#x26;token=1e7807fb-302e-46ba-9e64-4f7e48862875" alt=""><figcaption></figcaption></figure>