An alternative to storing your sensitive database credentials with Tableau Online is to create connections using the OAuth 2.0 standard. The following connectors support OAuth authentication:
- Azure Data Lake Storage Gen2, Azure SQL, Azure Synapse
- Esri ArcGIS Server
- Google Ads, Google Analytics, Google BigQuery, Google Sheets
- LinkedIn Sales Navigtor
- Oracle Eloqua
- QuickBooks Online
- ServiceNow ITSM
From Tableau, when users sign in to data with a connector that uses OAuth, users are redirected to the authentication provider’s sign-in page. After users provide their credentials and authorise Tableau to access their data, the authentication provider sends Tableau an access token that uniquely identifies Tableau and the users. This access token is used to access data on users' behalf. For more information, see Overview of the OAuth process below.
Using OAuth-based connections provides the following benefits:
Security: Your database credentials are never known to or stored in Tableau Online, and the access token can be used only by Tableau on behalf of users.
Convenience: Instead of having to embed your data source ID and password in multiple places, you can use the token provided for a particular data provider for all published workbooks and data sources that access that data provider.
In addition, for live connections to Google BigQuery data, each workbook viewer can have a unique access token that identifies the user, rather than sharing a single user name and password credential.
The following steps describe a workflow in the Tableau environment that calls the OAuth process.
A user takes an action that requires access to a cloud-based data source.
For example, you open a workbook that’s published to Tableau Online.
Tableau directs the user to the cloud data provider’s sign-in page. The information that is sent to the data provider identifies Tableau as the requesting site.
When the user signs in to the data, the provider prompts the user to confirm their authorisation for Tableau Online to access the data.
Upon the user's confirmation, the data provider sends an access token back to Tableau Online.
Tableau Online presents the workbook and data to the user.
The following user workflows can use the OAuth process:
Creating a workbook and connecting to the data source from Tableau Desktop or from Tableau Online.
Publishing a data source from Tableau Desktop.
Signing in to a Tableau Online site from an approved client, such as Tableau Mobile or Tableau Desktop.
Note: Tableau Bridge does not support OAuth connections.
Access tokens for data connections
You can embed credentials based on access tokens with data connections, to enable direct access after the initial authentication process. An access token is valid until a Tableau Online user deletes it, or the data provider revokes it.
It is possible to exceed the number of access tokens your data source provider allows. If that's the case, when a user creates a new token, the data provider uses length of time since last access to decide which token to invalidate to make room for the new one.
Access tokens for authentication from approved clients
By default, Tableau Online sites allow users to access their sites directly from approved Tableau clients, after users provide their credentials the first time they sign in. This type of authentication also uses OAuth access tokens to store the users' credentials securely.
For more information, see Access Sites from Connected Clients.
Beginning with 2021.2, as a site admin, you can configure a custom OAuth client, for each OAuth supported data provider (connector), to override the pre-configured OAuth client settings for your site. You might consider configuring a custom OAuth client to support securely connecting to data that requires unique OAuth clients.
When a custom OAuth client is configured, default configurations are ignored and all new OAuth credentials created on the site use the custom OAuth client by default.
Important: Existing OAuth credentials established before the custom OAuth client is configured are temporarily usable but both site admins and users must update saved credentials to help ensure uninterrupted data access.
Step 1: Prepare the OAuth client ID, client secret and redirect URL
Before you can configure the custom OAuth client, you need to collect the information listed below. After you have this information, you can configure the custom OAuth client for each of the OAuth supported connector.
OAuth client ID and client secret: First, register the OAuth client with the data provider (connector) to retrieve the client ID and client secret generated for Tableau Online. Supported connectors include:
- Azure Data Lake Storage Gen2, Azure SQL Database, Azure Synapse
- Google Analytics, Google BigQuery
- Intuit Quickbooks Online
Redirect URL: Note the pod where your Tableau Online site is located to ensure you enter the correct redirect URL during the registration process in Step 2 below. The redirect URL uses the following format:
For example, https://us-west-2b.online.tableau.com/auth/add_oauth_token
Note: For more information about pods, see the Tableau Trust(Link opens in a new window) page.
Step 2: Register OAuth client ID and client secret
Follow the procedure described below to register the custom OAuth client to your site.
Sign in to Tableau Online using your site admin credentials and navigate to the Settings page.
Under OAuth Clients Registry, click the Add OAuth Client button.
Enter the required information, including the information from Step 1 above:
For Connection Type, enter one of the following database class values depending on the connector whose custom OAuth client you want to configure:
For Client ID, Client Secret and Redirect URL, enter the information you prepared in Step 1 above.
Click the Add OAuth Client button to complete the registration process.
(Optional) Repeat step 3 for additional connectors.
- Click the Save button at the bottom or top of the Settings page to save changes.
Step 3: Validate and update saved credentials
To help ensure uninterrupted data access, you (and your site users) must delete the previous saved credentials and add it again to use the custom OAuth client instead of the default OAuth client.
Navigate to your My Account Settings page.
Under Saved Credentials for Data Sources, do the following:
Click Delete next to the existing saved credentials for the connector whose custom OAuth client you configured in Step 2 above.
Next to the same connector, click Add and follow the prompts to 1) connect to the custom OAuth client configured in Step 2 above and 2) save the latest credentials.
Step 4: Notify users to update their saved credentials
Make sure you notify your site users to update their saved credentials for the data provider whose custom OAuth client you configured in Step 2 above. Site users can use the procedure described in Update saved credentials to update their saved credentials.