Connect DataDatabases
Exasol
Exasol is available in the connection wizard when its required client is enabled on your DataSquares server.
Server prerequisite
Section titled “Server prerequisite”The standard API installation does not include the Exasol client. Ask your administrator to build and deploy a server image with the compatible client and restart the API. Installing a client on your own computer does not enable it on the server.
The wizard checks the current server and disables the tile while availability is unknown or the client cannot load. If the check fails, use Retry availability check. Once the tile is enabled, follow the steps below and Test Connection to verify database access. A successful client check does not verify credentials, network access, TLS, or query compatibility.
-
In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.
-
Pick Exasol on that page (search or browse by category).
-
Fill in the connection details below, then test the connection and save.
Connection details
Section titled “Connection details”| Field | What to enter |
|---|---|
| Host | The hostname or IP address of your Exasol server. |
| Port | Prefilled with 8563 (the Exasol default) — change it if your server listens elsewhere. |
| Username / Password | Credentials for a user with read access to the tables you want to analyze. |
| TLS | On by default: Use SSL/TLS encryption connects encrypted and verifies the server certificate. Tick Trust self-signed certificate for a private CA; turn TLS off only for a server that has none. |
Grant the connection user read-only access — DataSquares only ever reads from your source.
Related
Section titled “Related”- Connector catalog — everything DataSquares connects to.
- Quickstart — from connection to shared dashboard.