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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.uibakery.io/reference/data-sources/exasol.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.