How to connect On prem tableau server to Azure Databricks

Question

Trying to establish a connection between on prem tableau server to Azure Databricks. Do we have to create App registration for the tableau server?

Answer 1

Hi @Rajagopalan, Valli (She/Her/Hers) (MNIT)

Thank you for posting your query!

According to this documentation: https://learn.microsoft.com/en-us/azure/databricks/integrations/configure-oauth-tableau To connect your on-premises Tableau Server to Azure Databricks, you will need to create an OAuth application for Tableau Server in your Azure Databricks account.

Add Tableau Server as an OAuth Application - Locate your Azure Databricks account ID and your Tableau Server URL.

Run the following command in the Databricks CLI:

databricks account custom-app-integration create --confidential --json '{"name":"<name>", "redirect_urls":["<redirect-url>"], "scopes":["all-apis", "offline_access", "openid", "profile", "email"]}'

Replace <name> with a name for your OAuth application and <redirect-url> with your Tableau Server URL appended with /auth/add_oauth_token.

Store the Client Secret - A client ID and client secret will be generated. Securely store the client secret as it cannot be retrieved later.

Configure OAuth in Tableau Server - Sign in to Tableau Server as an administrator. Go to Settings > OAuth Client Registry > Add OAuth client. For Connection Type, select Databricks. Enter the Client ID and Client Secret generated in the previous step. Enter the Redirect URL used earlier.

These steps will enable your Tableau Server to connect to Azure Databricks using OAuth.

For more details refer: https://learn.microsoft.com/en-us/azure/databricks/integrations/configure-oauth-tableau

https://learn.microsoft.com/en-us/azure/databricks/partners/bi/tableau

I hope this information helps.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.