Tableau
Tableau (opens in a new tab) is a popular visual analytics platform.
Semantic Layer Sync
It is recommended to use Semantic Layer Sync to connect Cube to Tableau. It automatically synchronizes the data model between Cube and Tableau.
SQL API
You can also use the SQL API to connect Cube to Tableau.
Cube Cloud
Click How to connect your BI tool link on the Overview page, navigate to the SQL API tab and enable it. Once enabled, you should see the screen like the one below with your connection credentials:
Self-hosted Cube
You need to set the following environment variables to enable the Cube SQL API. These credentials will be required to connect to Cube from Tableau later.
CUBEJS_PG_SQL_PORT=5432
CUBEJS_SQL_USER=myusername
CUBEJS_SQL_PASSWORD=mypassword
Connecting from Tableau
Tableau connects to Cube as to a Postgres database.
In Tableau, select PostgreSQL connector and enter credentials from the above step.
It's not recommended to use Tableau extracts (opens in a new tab) when connecting to Cube. Use pre-aggregations to improve querying performance and manage data freshness upstream of Tableau.
Querying data
Your cubes will be exposed as tables, where both your measures and dimensions are columns.