5.9 KiB
title |
---|
Configuration |
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
- Within DataHub, navigate to the Ingestion tab in the top, right corner of your screen
:::note If you do not see the Ingestion tab, please contact your DataHub admin to grant you the correct permissions :::
- Navigate to the Secrets tab and click Create new secret
- 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
- 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
Configure Recipe
- Navigate to on the Sources tab and then Create new source
- Select Tableau
-
Fill in the Tableau Recipe form:
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:
Click Next when you're done.
Schedule Execution
Now it's time to schedule a recurring ingestion pipeline to regularly extract metadata from your Tableau instance.
- Decide how regularly you want this ingestion to run-- day, month, year, hour, minute, etc. Select from the dropdown
- Ensure you've configured your correct timezone
- Click Next when you are done
Finish Up
- Name your ingestion source, then click Save and Run
You will now find your new ingestion source running
Validate Ingestion Runs
- View the latest status of ingestion runs on the Ingestion page
- Click the plus sign to expand the full list of historical runs and outcomes; click Details to see the outcomes of a specific run
- From the Ingestion Run Details page, pick View All to see which entities were ingested
- Pick an entity from the list to manually validate if it contains the detail you expected
Congratulations! You've successfully set up Tableau as an ingestion source for DataHub!