> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to use Tableau Adapter

<Info>
  This feature is experimental, and requires this option to be enabled<br />
  `-Dactiveviam.feature.experimental.atoti_sql_server.enabled=true`.
</Info>

## How to activate the Atoti Tableau Adapter

To activate the Atoti Tableau Adapter you need to follow these steps:

### 1. Add the SQL Bridge artifact to your project

Include the following dependency in your `pom.xml` file:

```xml theme={"languages":{"custom":["/engine/python-sdk/0.9/languages/pycon.tmLanguage.json"]}}
<dependency>
    <groupId>com.activeviam.activepivot</groupId>
    <artifactId>activepivot-server-sql-bridge</artifactId>
    <version>${project.version}</version>
</dependency>
```

### 2. Choose an appropriate listening port

By default, the server listens for SQL queries on port **5432**. This port number can be modified by
setting the `atoti.server.sql-bridge.port` property of your Atoti application.

## How to connect Tableau to Atoti

This guide explains how to connect Tableau (Desktop or Cloud) to an Atoti server using the PostgreSQL JDBC driver.
Only User/Password authentication is supported.

### What you need before starting

To connect Tableau to Atoti, ensure the following prerequisites are met:

* **PostgreSQL JDBC driver**: Required for Tableau Desktop. The **42.7.7** version of the
  driver is the only one guaranteed to work with Atoti. This version may be upgraded in any bugfix
  release. However, if you have tested a more recent version and it does not work, please open a support ticket.
* **Atoti server configuration**: The Tableau adapter needs to be activated on the [server](#how-to-activate-the-atoti-tableau-adapter)

### Connection steps

<Tabs>
  <Tab title="Tableau Desktop">
    Follow these steps to connect Tableau Desktop to an Atoti server:

    1. **Open Tableau Desktop** and create a new file.

    2. Click **Connect to Data** in the upper-left corner.
           <img src="https://mintcdn.com/activeviam/lTzImDUNm0cHRUws/engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_desktop_connect1.png?fit=max&auto=format&n=lTzImDUNm0cHRUws&q=85&s=2af5e5c58a67811f5565a047b68014eb" alt="Tableau Desktop connection first step" width="1016" height="726" data-path="engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_desktop_connect1.png" />

    3. From the list of connectors, select **PostgreSQL**.
           <img src="https://mintcdn.com/activeviam/lTzImDUNm0cHRUws/engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_desktop_connect2.png?fit=max&auto=format&n=lTzImDUNm0cHRUws&q=85&s=4d974f1cd2eceb8167b15484ae3db4e9" alt="Tableau Desktop connection second step" width="1016" height="726" data-path="engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_desktop_connect2.png" />

    4. Fill in the required connection details:
       * **Address**: IP address of the Atoti server.
       * **Port**: Port used by the PostgreSQL wire protocol (default is `5432`). If changed, refer to
         the `atoti.server.sql-bridge.port` property of your Atoti application.
       * **Database**: Always set to `atoti`.
       * **Authentication**: Choose your preferred authentication method.
             <img src="https://mintcdn.com/activeviam/lTzImDUNm0cHRUws/engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_desktop_connect3.png?fit=max&auto=format&n=lTzImDUNm0cHRUws&q=85&s=2f4bfa455df017fc33b72d5bd05f5b46" alt="Tableau Desktop connection third step" width="1016" height="726" data-path="engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_desktop_connect3.png" />

    5. Click **Connect** to establish the connection.
  </Tab>

  <Tab title="Tableau Cloud">
    To connect Tableau Cloud to an Atoti server:

    1. Open a new workbook in Tableau Cloud.
    2. Click **Connect to Data**, then select **Connectors**.
    3. Choose the **PostgreSQL** connector.
           <img src="https://mintcdn.com/activeviam/lTzImDUNm0cHRUws/engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_cloud_connect.png?fit=max&auto=format&n=lTzImDUNm0cHRUws&q=85&s=7888544e92ed3f6d661a83a10f1b5ae6" alt="Tableau Cloud connection first step" width="1845" height="982" data-path="engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_cloud_connect.png" />
    4. Provide the same connection details as for Tableau Desktop:
       * **Address**
       * **Port**
       * **Database**

    * **Authentication**: Only **username and password** authentication is supported in Tableau Cloud.
          <img src="https://mintcdn.com/activeviam/lTzImDUNm0cHRUws/engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_cloud_connect2.png?fit=max&auto=format&n=lTzImDUNm0cHRUws&q=85&s=ed655c1747450da816a4915b9f31943a" alt="Tableau Cloud connection second step" width="1850" height="992" data-path="engine/java-sdk/6.1/assets/user_guide/tableau_bi_adapter/tableau_cloud_connect2.png" />
  </Tab>
</Tabs>
