# 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](https://docs.e6data.com/product-documentation/~/revisions/W5MExJCuvHiG1ioEcgOy/connectors-and-drivers/broken-reference) tab in the e6data cluster.
* Download e6data JDBC Driver: Download and install the latest JDBC driver for e6data. Please contact the e6data team at <help@e6data.com> to obtain the JDBC driver.

## Connection

1. Get the necessary [connection information](https://docs.e6data.com/product-documentation/~/revisions/W5MExJCuvHiG1ioEcgOy/connectors-and-drivers/broken-reference) for your cluster:

* JDBC URL \
  The e6data JDBC connection URL follows the following format&#x20;

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

* Username&#x20;
* Password ([Personal Access Token](https://docs.e6data.com/product-documentation/~/revisions/W5MExJCuvHiG1ioEcgOy/user-settings/personal-access-tokens-pat))

2. 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:

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

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXer3rYjaF-muPglt_DQiBXSEvsdZm8r7MncxKQJnfhVT-mkaIZIso80VPvNygqniBpamO4qbP3x53-Ko_XqXx3MtjYvYUhDKIIEL-3dJ9RVgQ7TyOeQJWlsMejd3b_0YYOk-FakCEttoBm3ZOUiHxNX3qe3?key=TN7YoFkxPt_w230QjEPV5Q" alt=""><figcaption></figcaption></figure>

4. 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.

<figure><img src="https://3484040590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FeVBYKZm1xFKFFVzS0lRJ%2Fuploads%2FGtwz2ttb3LQf2Ne3tCBe%2Fimage.png?alt=media&#x26;token=f59476d8-2b99-4cb7-9331-a375ff8d2e10" alt="" width="375"><figcaption></figcaption></figure>

### TLS/HTTP <a href="#tls-http" id="tls-http"></a>

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.