Tableau is a popular Bussines Intelligence (BI) tool allowing you to create extensive dashboards and connect to multiple source databases.
From Dataedo 10.4 we support Tableau Data Model connector that imports only database tables layer. In Dataedo 23.1 we introduce new Tableau connector with much extended metadata import.
Cataloging and documentating Tableau
Dataedo imports following report objects from Tableau:
- workbooks (as reports)
- dashboards and sheets (as workbooks' columns)
- virtual connection tables (as datasets)
- data flows (as datasets)
Dataedo imports following dataset objects from Tableau:
- database tables (as datasets)
- data sources (as datasets)
- custom SQL tables (as datasets)
Dataedo builds column-level lineage automatically from your source database (SQL Server, Snowflake, Postgres, etc.) through database tables, data sources to workbooks.
- If Tableau Cloud or Tableau Server is not licensed with Data Management, then by default, only admins can see database and table metadata through the Tableau Metadata API. This default can be changed to use "derived permissions," as described here.
- If you try to connect to the Tableau Server instance you need to manually enable the Tableau Metadata API. You can find details on how to do that here. Tableau Online has the Metadata API turned on by default.
Connecting to Tableau
Add new connection
To connect to Tableau instance create new documentation by clicking Add and choosing Database connection.
On the connection screen choose Tableau.
Provide connection details:
- Product - Tableau product version you're trying to connect, Online or Server.
- Host - Provide a host name pointing your Tableau organization. eg. https://dub01.online.tableau.com/
- Authentication - Select the way you want to authorize.
- Username - Username to your Tableau organization. eg. firstname.lastname@example.org
- Password - Password to your Tableau organization.
- Personal Access Token - You can find the instructions on how to obtain Personal Access Token down below.
- Token name
- Token secret
- Site - Name of the Tableau site. For Tableau Server you can use a [...] button to fetch sites list automatically.
How to get connection details in Tableau
Personal Access Token
To obtain Personal Access Token follow these steps:
- Go to your Tableau dashboard and then open My Account Settings.
- Scroll to the Personal Access Tokens section.
- Provide Token Name and click Create new token.
- Select Copy to clipboard.
Find out more on Personal Access Token in the Tableau docs
Connection details in Tableau Server
The only difference between Tableau Server and Online instance is the host URL. Tableau Online uses the tableau domain (*.tableau.com) and the Server can be in any domain your company set up.
You can save password for later connections by checking Save password option. Passwords are securely stored in the repository database.
When the connection was successful Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use an advanced filter to narrow down the list of objects.
Confirm list of objects to import by clicking Next.
The next screen allows you to change the default name of the documentation under your schema will be visible in the Dataedo repository.
Click Import to start the import.
When done close import window with Finish button.
Your database schema has been imported to new documentation in the repository.
To sync any changes in the schema in Tableau and reimport any technical metadata simply choose Import changes option. You will be asked to connect to Tableau again and changes will be synced from the source.
You can also schedule metadata updates using command line files. To do it, after creating documentation use Save update command option. Downloaded file can be run in command line, what will reimport changes to your documentation.
Exporting comments to Tableau Catalog
If you have Data Managmet Addon in your Tableau instance you can export your descriptions from Dataedo into Tableau.
Exported database tables' descriptions are inherited by Data Source fields. In the Tableau Web editor, they are always visible to the user, while in the Tableau Desktop editor, exported descriptions are visible only for Published Data Sources.
Add description to database table columns in Dataedo.
Right click on Tableau documentation in Dataedo.
Click on "Export" and "Export comments (Tableau Data Managment Addon required)" and select "Next".
Provide connection information if needed and click "Next".
Keep everything selected on a next screen and click on "Export".
Here's an outcome:
|Type (column, calculated, hierarchy, etc.)||✅|
|Virtual connection tables||✅||✅|
|Custom SQL tables||✅||✅|
|Write comments back||✅|
|Reference data (import lookups)|
|Importing from DDL|
|FK relationship tester|
Dataedo reads comments from following Tableau objects:
|Database tables comments||✅||✅|
|Data sources comments||✅||✅|
|Sources - database tables (column-level)||Metadata API||23.1 (2023)|
|Database tables - data sources (column-level)||Metadata API||23.1 (2023)|
|Data sources - workbooks (column-level)||Metadata API||23.1 (2023)|
|Prep Builder - data flows (column-level)||Metadata API||23.2 (2023)|