Connect a BI Tool via JDBC

What this covers

Connecting a JDBC-compatible BI tool — Tableau, Power BI, DBeaver, or any PostgreSQL-compatible client — to a Tessallite workspace using the JDBC endpoint on port 5433.

Before you start

• Role required: Analyst (Viewer) or higher.
• You will need: the workspace slug, your email address, and your password.
• You will also need: the host address and port of the Tessallite gateway, obtained from your system administrator.
• The gateway JDBC port is 5433. For local installs, the host is localhost. For cloud installs, your system administrator provides the hostname.
• On GCP, JDBC requires a TCP load balancer. If your system administrator has not configured one, use the XMLA connection (Excel or Power BI) instead.

Connection details

The workspace slug is the identifier for your tenant. It is case-sensitive. If you are uncertain of the slug, ask your system administrator.

Scoping the connection to one model. The Database field also accepts two longer forms when you want the connection to open on a specific model instead of the whole workspace:

• acme/sales — workspace slug plus a model slug.
• acme/finance/sales — workspace, project, and model slug, useful when two projects contain models with the same name.

If the model or project you name does not exist, the connection is refused with a message that tells you the accepted formats, so a typo is easy to spot.

Connecting with DBeaver

1. Open DBeaver.
2. Click New Database Connection (the plug icon in the toolbar).
3. In the connection type list, select PostgreSQL.
4. Enter the Host, Port, Database, Username, and Password using the values from the table above.
5. Click Test Connection. A confirmation dialog should appear.
6. Click Finish.
7. The connection appears in the left panel. Expand it to see the available tables. Each model published in the workspace appears as a schema.

Connecting with Tableau

1. Open Tableau Desktop.
2. In the Connect pane on the left, select PostgreSQL.
3. Enter the server address in the Server field.
4. Enter 5433 in the Port field.
5. Enter the workspace slug in the Database field.
6. Enter your email address in the Username field and your password in the Password field.
7. Click Sign In.
8. The tables for the selected workspace are available in the data source pane.

Connecting with psycopg2 or other drivers

Pass the following connection parameters to your driver:

host=<hostname>
port=5433
dbname=<workspace-slug>
user=<your-email>
password=<your-password>

Any PostgreSQL-compatible driver accepts these parameters directly.

What you see after connecting

Each model published in the workspace appears as a schema. Within each schema, the dimensions and measures defined in the model are listed as columns. Querying them returns results immediately. Tessallite routes the query to the fastest available source — a pre-aggregated summary if one exists, or the raw data source otherwise.

Troubleshooting

Related

• Connect Excel via XMLA
• What is Tessallite
• JDBC connection guide