Skip to main content

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.

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 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:
MethodWhen to use
Username & PasswordStandard database authentication
Personal Access TokenRecommended 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.
Personal access tokens are shown only once. Copy and save the token immediately after generating it.

​
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.
Having trouble connecting? See the Network Configuration Guide for firewall and IP whitelisting setup. Ensure your firewall allows outbound connections on the configured Exasol port.

​
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