Skip to main content
This feature requires a license that enables the bi-adapter component.

​
Prerequisites

  • Atoti application: An active Atoti application with a cube available.
  • Atoti Tableau Adapter: Activated on the server.
  • Tableau: Tableau Desktop or Tableau Cloud access. Tableau Desktop is supported from version 2026.1 onwards. Tableau Cloud also requires Tableau Desktop, to publish the .tds file.
  • PostgreSQL JDBC driver: Required for Tableau Desktop, including to publish to Tableau Cloud. 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.

​
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

Include the following dependency in your pom.xml file:
This artifact provides the BI Adapter SQL endpoint the Tableau Adapter is built on, covering the listening port, encryption, and monitoring.

​
2. Enable the SQL endpoint

Follow How to enable the SQL endpoint.

​
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. See Which SQL is supported? for the scope of SQL queries the SQL endpoint accepts.

​
Connect using a Tableau data source file

Atoti can generate the Tableau data source file (.tds) of a cube. A .tds file holds no data: it only stores the connection information and the field metadata Tableau needs to open a data source, so it can be shared and reopened like a shortcut to the cube. See the Tableau documentation for the full description of the format. The file generated by Atoti declares Tableau multilevel hierarchies that mirror the cube’s own multilevel hierarchies and therefore reproduces the cube’s structure in Tableau. Always connect Tableau to Atoti through this file. Connecting with the PostgreSQL connector alone is not supported. Atoti generates the file on request, through the BI adapter REST API. See that reference for the endpoint path, its parameters and its responses. The following command downloads the .tds file of the SALES_CUBE cube, specifying that Tableau should connect to my-atoti-host.
Server-side configuration The SQL port and the level-name mode are not request parameters. They are configured on the BI Adapter SQL endpoint.

​
Use the file with Tableau Cloud

Tableau Cloud does not open a .tds file directly. Open the file in Tableau Desktop, then publish it to Tableau Cloud as a data source:
  1. Open the .tds file in Tableau Desktop and sign in to the Atoti server with a username and password.
  2. Select Server > Publish Data Source, then sign in to the Tableau Cloud site.
  3. Keep the connection live, and set Authentication to Embedded password. See the Tableau documentation for the other authentication options.
  4. Click Publish.
Workbooks on Tableau Cloud then connect to the published data source. Tableau Cloud queries Atoti from Tableau’s infrastructure, so the host and port written in the .tds file must be reachable from there.