Tableau Desktop

Tableau Desktop is a robust data visualization tool for business intelligence and analytics. It enables users to connect to various data sources, analyse data, and create interactive, shareable dashboards. Known for its user-friendly interface and flexibility, Tableau Desktop excels at transforming raw data into meaningful insights through dynamic visualizations.

Requirements

Below are the prerequisites you need to fulfil before connecting the e6data cluster to Tableau Cloud:

• Establish a Direct Connection in your cluster

• Tableau Desktop Version: Use version 2023.3.0 or later.

• You can obtain the connection details required from the Connection Information tab in the e6data cluster.

• Download e6data JDBC Driver: Download and install the latest JDBC driver for e6data. Please contact the e6data team at [e-mail] to obtain the JDBC driver.

Connection

1. Get the necessary connection information for your cluster:

• JDBC URL The e6data JDBC connection URL follows the following format

jdbc:e6data://<HOSTNAME>:<PORT>/database=<DATABASE>&catalog=<CATALOG_NAME>

• Username

• Password (Personal Access Token)

1. Install the JDBC Driver: Place the installed E6 JDBC driver in the appropriate folder for your operating system:

• Windows: C:\Program Files\Tableau\Drivers

• Mac: ~/Library/Tableau/Drivers

• Linux: /opt/tableau/tableau_driver/jdbc

Once you have gathered this information, you can create a new connection in Tableau Desktop. To connect with Tableau Desktop, follow the below instructions:

1. Select the Other Databases (JDBC) option under the "To a server" section.

1. To Configure the Connection:

• Enter the e6data JDBC URL and select MySQL as the dialect.

• Click Connect to establish a JDBC connection with e6data.

• Finally, click the "Sign In" button.

TLS/HTTP

e6data utilizes globally trusted certificates, ensuring that the host and port provided by the connection dialogue are adequate. Any e6data cluster necessitating authentication must also employ TLS/HTTPS. If adhering to globally trusted certificate best practices, utilize the cluster’s HTTPS URL in the connection string as detailed in the aforementioned steps.