> ## Documentation Index
> Fetch the complete documentation index at: https://docs.textql.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Exasol Connector

> Connecting TextQL to Exasol

To connect TextQL with your Exasol instance, you will need to gather the following connection details:

* Host and port
* Authentication credentials (username & password, or personal access token)
* Database and schemas (optional)

### Creating the Connector in TextQL

Navigate to the [TextQL Connectors Page](/core/datasources/the-connectors-page) and click **Create New Connector**. Select Exasol from the available connectors to open the configuration form.

The form requires the following information:

* **Connector Name:** A descriptive name to identify this Exasol connection in TextQL.
* **Host:** Your Exasol hostname (e.g., `demodb.exasol.com` or your private cluster address).
* **Port:** The Exasol port (default `8563`).
* **Database:** Optional database name. Leave blank to use the default.
* **Schemas:** Optional comma-separated list of schemas to scope table discovery (e.g., `RETAIL, FINANCE`). If left blank, all user-accessible tables are discovered automatically.

### Authentication

TextQL supports two authentication methods for Exasol:

| Method                    | When to use                                             |
| ------------------------- | ------------------------------------------------------- |
| **Username & Password**   | Standard database authentication                        |
| **Personal Access Token** | Recommended for production and SSO-enabled environments |

Select your authentication type and fill in the relevant credentials.

#### Generating a Personal Access Token

1. Log in to your Exasol instance.
2. Open **User Settings** and navigate to **Personal Access Tokens**.
3. Click **Generate Token**, give it a name, and copy the token value.

<Warning>
  Personal access tokens are shown only once. Copy and save the token immediately after generating it.
</Warning>

### SSL Configuration

SSL is enabled by default. Disable it only for development environments where TLS is not configured on your Exasol cluster.

### Schemas

Exasol organizes tables under schemas (e.g., `SALES.ORDERS`). When you specify schemas like `SALES`, TextQL discovers all tables and views in those schemas. Schema names are case-insensitive — TextQL upper-cases them automatically to match Exasol's catalog conventions.

If you leave the Schemas field blank, TextQL discovers all user-accessible tables and views across the cluster.

### Testing the Connection

After entering your credentials, click **Create** to establish the connection. TextQL will validate your credentials and create the connector. If the connection fails, verify your host, port, SSL setting, and authentication details.

<Note>
  Having trouble connecting? See the [Network Configuration Guide](/core/datasources/databases/network-configuration) for firewall and IP whitelisting setup. Ensure your firewall allows outbound connections on the configured Exasol port.
</Note>

### Next Steps

Once connected, you can use TextQL to query your Exasol data. The connector supports querying any schema accessible to your Exasol user. For optimal performance and security:

* Use a dedicated Exasol user or personal access token for TextQL connections
* Specify schemas to limit table discovery scope
* Enable SSL for all production deployments