Skip to main content

Configuring Your Tableau Connector to DataHub

Now that you have created a DataHub-specific user with the relevant access in Tableau in the prior step, it's now time to set up a connection via the DataHub UI.

Configure Secrets​

  1. Within DataHub, navigate to the Ingestion tab in the top, right corner of your screen

Navigate to the "Ingestion Tab"

note

If you do not see the Ingestion tab, please contact your DataHub admin to grant you the correct permissions

  1. Navigate to the Secrets tab and click Create new secret

Secrets Tab

  1. Create a username secret

This will securely store your Tableau username within DataHub

  • Enter a name like TABLEAU_USERNAME - we will use this later to refer in recipe

  • Enter the username, setup in the setup guide

  • Optionally add a description

  • Click Create

    Tableau Username Secret

  1. Create a password secret

This will securely store your Tableau password within DataHub

  • Enter a name like TABLEAU_PASSWORD - we will use this later to refer in recipe

  • Enter the password of the user, setup in the setup guide

  • Optionally add a description

  • Click Create

    Tableau Password Secret

Configure Recipe​

  1. Navigate to the Sources tab and click Create Source

Click "Create Source"

  1. Select Tableau

Select Tableau from the options

  1. Fill in the Tableau Recipe form:

    Enter a Source Name at the top of the Connection Details page, then fill in the connection fields.

    You need to set minimum following fields in the recipe:

    a. Host URL: URL of your Tableau instance (e.g., https://15az.online.tableau.com/). It is available in browser address bar on Tableau Portal.

    b. Username: Use the TABLEAU_USERNAME secret (e.g., "${TABLEAU_USERNAME}").

    c. Password: Use the TABLEAU_PASSWORD secret (e.g., "${TABLEAU_PASSWORD}").

    d. Site: Required only if using tableau cloud/ tableau online

To filter specific project, use project_pattern fields.

config:
...
project_pattern:
allow:
- "SalesProject"

Your recipe should look something like this:

tableau recipe in form format

Schedule Execution​

Now it's time to schedule a recurring ingestion pipeline to regularly extract metadata from your Tableau instance.

  1. In the Sync Schedule section, turn on Run on a schedule, then decide how regularly you want this ingestion to run-- day, month, year, hour, minute, etc. Select from the dropdown

schedule selector

  1. Ensure you've configured your correct timezone

    timezone_selector

Save and Run​

  1. Click Save and Run at the top of the page

You will now find your new ingestion source running

ingestion_running

Validate Ingestion Runs​

  1. View the latest status of ingestion runs on the Ingestion page

ingestion succeeded

  1. Open the Run History tab to see the full list of historical runs and outcomes; click a run's status to open its Run Details page

ingestion_details

  1. In the Assets section of the Run Details page, click View all to see which entities were ingested

ingestion_details_view_all

  1. Pick an entity from the list to manually validate if it contains the detail you expected

ingestion_details_view_all

Congratulations! You've successfully set up Tableau as an ingestion source for DataHub!