Tableau

Tableau connects to Hydrolix using one of two interfaces:

• ClickHouse connector (port 8088, Tableau Desktop and Server): Uses the official ClickHouse Tableau Connector. Supports basic authentication only.
• MySQL connector (port 9004, Tableau Desktop, Server, and Cloud): Uses Tableau's built-in MySQL connector. No additional installation required. Supports basic authentication and API token authentication.

Configure the ClickHouse connector

The ClickHouse connector connects to Hydrolix on port 8088 using the official ClickHouse Tableau Connector. It requires basic authentication. Authorization tokens aren't supported.

ClickHouse prerequisites

• A running Hydrolix cluster
• A Tableau Desktop or Server instance
• A Hydrolix user account with read privileges on the target tables
• Connectivity from Tableau to the Hydrolix host on port 8088

Install the ClickHouse connector

Install the ClickHouse driver and connector following the instructions on the ClickHouse JDBC Connector page for the appropriate Tableau product.

Use the following settings when creating the connection in Tableau.

Setting	Description	Example
Server	The Hydrolix cluster hostname.	hostname.hydrolix.live
Port	The ClickHouse HTTP interface port.	8088
Username	Hydrolix user account with read privileges.	username@domain.tld
Password	The user account's password.	password

ClickHouse connector requires basic authentication

Hydrolix supports query access using HTTP basic authentication and authorization (bearer) tokens for user or service accounts. See access enforcement. The Tableau ClickHouse Connector can't set an HTTP Authorization header, which is required for service account or user authentication tokens.

The ClickHouse Connector requires HTTP basic authentication with user credentials.

Create a connection in Tableau

1. Open Tableau.
2. Verify the ClickHouse connector is installed:
   • Navigate to Connect > To a Server > More > ClickHouse JDBC by ClickHouse, Inc.
3. Enter the connection settings.
4. If your Hydrolix cluster enforces TLS, select Require SSL.
5. (Optional) Open Initial SQL to specify a SQL command to run at the beginning of every connection.
6. Click Sign In.

After signing in, find the Hydrolix cluster's projects in the left nav under Database in the Select Database dropdown.

Build the data source

On the data source page:

1. Select one or more tables from the Hydrolix project, or click New Custom SQL to write a query.
2. Choose a connection type:
   • Live: queries run directly against Hydrolix in real time.
   • Extract: Tableau caches data and can refresh on a schedule after publishing.
3. Drag tables onto the canvas to define joins or relationships.
4. Click Sheet to preview data and confirm the results.

Configure the MySQL connector

This feature was introduced in Hydrolix version 5.10.3.

Tableau connects to Hydrolix using Tableau's built-in MySQL connector and the Hydrolix MySQL-compatible interface on port 9004. No additional connector installation is required.

The MySQL connector supports both basic authentication and API token authentication.

MySQL prerequisites

• A running Hydrolix cluster (v5.10.3 or later)
• A Tableau Desktop, Server, or Cloud instance
• A Hydrolix user account with read privileges on the target tables
• Connectivity from Tableau to the Hydrolix host on port 9004

Connection settings

Setting	Description	Example
Server	The Hydrolix cluster hostname.	hostname.hydrolix.live
Port	The MySQL interface port.	9004
Username	User account email address, or __api_token__ for token-based authentication.	username@domain.tld
Password	The user account's password, or an API token.	password

Connect Tableau using the MySQL connector

1. Open Tableau.
2. Navigate to Connect > To a Server > MySQL.
3. Enter the connection settings from Connection settings.
4. If your cluster enforces TLS, select Require SSL.
5. Click Sign In.

After signing in, find the Hydrolix cluster's projects in the left nav under Database in the Select Database dropdown.