analystUpdated 2026-04-17

JDBC Connection Guide

DBeaver New Database Connection dialog (PostgreSQL).

What this covers

Tessallite exposes a PostgreSQL wire-protocol endpoint on port 5433. Any JDBC client that supports the standard PostgreSQL driver can connect — including DBeaver, Tableau, and any tool using psycopg2 or the JDBC PostgreSQL driver. No Tessallite-specific driver is required.

This article is a detailed connection reference. For a shorter walkthrough, see Connect a BI Tool via JDBC.

Connection parameters

ParameterValueNotes
HostHostname or IP of the Tessallite GatewayUse localhost for local installs. Obtain from your System Admin for cloud deployments.
Port5433Fixed. Not the standard PostgreSQL port (5432).
DatabaseWorkspace slug (e.g., acme)Case-sensitive. This is not a real database name — it routes to the correct workspace.
UsernameYour Tessallite email address
PasswordYour Tessallite password
SSLOptionalAdd ?sslmode=require to the JDBC URL if the server requires SSL.
Driver classorg.postgresql.DriverStandard PostgreSQL JDBC driver. No Tessallite-specific driver needed.

JDBC URL format

jdbc:postgresql://HOST:5433/WORKSPACE_SLUG

Example:

jdbc:postgresql://analytics.example.com:5433/acme

With SSL:

jdbc:postgresql://analytics.example.com:5433/acme?sslmode=require
The "database" field must contain the workspace slug, not a real database name. Entering anything else returns FATAL: database "X" does not exist.

Connect with DBeaver

  1. Open DBeaver.
  2. Click New Database Connection (plug icon in toolbar).
  3. Select PostgreSQL and click Next.
  4. Fill in Host, Port (5433), Database (workspace slug), Username, and Password.
  5. Click Test Connection. A "Connected" dialog confirms success.
  6. Click Finish.
  7. Expand the connection in the left panel to see schemas and columns.

Connect with Tableau

  1. Open Tableau Desktop.
  2. In the Connect pane, under To a Server, select PostgreSQL.
  3. Enter the Gateway hostname in Server.
  4. Enter 5433 in Port.
  5. Enter the workspace slug in Database.
  6. Enter your credentials and click Sign In.

Connect with Apache Superset

  1. Log in to Superset.
  2. Go to Data > Databases > + Database.
  3. Select PostgreSQL as the database type.
  4. In the SQLAlchemy URI field, enter: postgresql://USER:PASSWORD@HOST:5433/WORKSPACE_SLUG — replace with your Tessallite credentials and gateway address.
  5. Click Test Connection to verify.
  6. Click Connect.
  7. Navigate to SQL Lab to run queries against Tessallite models, or create datasets from the connection for use in charts and dashboards.

Superset connects via the standard PostgreSQL driver (psycopg2). No additional driver installation is needed.

Driver note

Tessallite uses the PostgreSQL wire protocol. Use the standard org.postgresql.Driver (JDBC) or psycopg2 (Python). No special driver is required.

Troubleshooting

SymptomLikely causeResolution
Connection refused on port 5433Gateway not running or wrong hostVerify Gateway service is up with your System Admin
FATAL: database "X" does not existWrong workspace slugVerify slug with Tenant Admin (case-sensitive)
Authentication failedWrong username or passwordUse Tessallite email and password, not source DB credentials
SSL errorServer requires SSLAppend ?sslmode=require to the JDBC URL
No tables visibleNo published modelsA Modeller must publish at least one model

Related