Tutorial: Azure Active Directory integration with Tableau Server
In this tutorial, you learn how to integrate Tableau Server with Azure Active Directory (Azure AD).
Integrating Tableau Server with Azure AD provides you with the following benefits:
- You can control in Azure AD who has access to Tableau Server
- You can enable your users to automatically get signed-on to Tableau Server (Single Sign-On) with their Azure AD accounts
- You can manage your accounts in one central location - the Azure portal
If you want to know more details about SaaS app integration with Azure AD, see what is application access and single sign-on with Azure Active Directory.
To configure Azure AD integration with Tableau Server, you need the following items:
- An Azure AD subscription
- A Tableau Server single sign-on enabled subscription
To test the steps in this tutorial, we do not recommend using a production environment.
To test the steps in this tutorial, you should follow these recommendations:
- Do not use your production environment, unless it is necessary.
- If you don't have an Azure AD trial environment, you can get a one-month trial here.
In this tutorial, you test Azure AD single sign-on in a test environment. The scenario outlined in this tutorial consists of two main building blocks:
- Adding Tableau Server from the gallery
- Configuring and testing Azure AD single sign-on
Adding Tableau Server from the gallery
To configure the integration of Tableau Server into Azure AD, you need to add Tableau Server from the gallery to your list of managed SaaS apps.
To add Tableau Server from the gallery, perform the following steps:
In the Azure portal, on the left navigation panel, click Azure Active Directory icon.
Navigate to Enterprise applications. Then go to All applications.
To add new application, click New application button on the top of dialog.
In the search box, type Tableau Server.
In the results panel, select Tableau Server, and then click Add button to add the application.
Configuring and testing Azure AD single sign-on
In this section, you configure and test Azure AD single sign-on with Tableau Server based on a test user called "Britta Simon."
For single sign-on to work, Azure AD needs to know what the counterpart user in Tableau Server is to a user in Azure AD. In other words, a link relationship between an Azure AD user and the related user in Tableau Server needs to be established.
In Tableau Server, assign the value of the user name in Azure AD as the value of the Username to establish the link relationship.
To configure and test Azure AD single sign-on with Tableau Server, you need to complete the following building blocks:
- Configuring Azure AD Single Sign-On - to enable your users to use this feature.
- Creating an Azure AD test user - to test Azure AD single sign-on with Britta Simon.
- Creating a Tableau Server test user - to have a counterpart of Britta Simon in Tableau Server that is linked to the Azure AD representation of user.
- Assigning the Azure AD test user - to enable Britta Simon to use Azure AD single sign-on.
- Testing Single Sign-On - to verify whether the configuration works.
Configuring Azure AD single sign-on
In this section, you enable Azure AD single sign-on in the Azure portal and configure single sign-on in your Tableau Server application.
To configure Azure AD single sign-on with Tableau Server, perform the following steps:
In the Azure portal, on the Tableau Server application integration page, click Single sign-on.
On the Single sign-on dialog, select Mode as SAML-based Sign-on to enable single sign-on.
On the Tableau Server Domain and URLs section, perform the following steps:
a. In the Sign-on URL textbox, type a URL using the following pattern:
b. In the Identifier textbox, type a URL using the following pattern:
c. In the Reply URL textbox, type a URL using the following pattern:
The preceding values are not real values. Later, you update the values with the actual URL and identifier from the Tableau Server configuration page.
Tableau Server application expects the SAML assertions in a specific format. Configure the following claims for this application. You can manage the values of these attributes from the "User Attributes" section on application integration page. The following screenshot shows an example for the same.
In the User Attributes section on the Single sign-on dialog, configure SAML token attribute as shown in the image above and perform the following steps:
Attribute Name Attribute Value username user.mailnickname
a. Click Add attribute to open the Add Attribute dialog.
b. In the Name textbox, type the attribute name shown for that row.
c. From the Value list, type the attribute value shown for that row.
d. Click Ok
On the SAML Signing Certificate section, click Metadata XML and then save the metadata file on your computer.
Click Save button.
To get SSO configured for your application, you need to sign-on to your Tableau Server tenant as an administrator.
a. In the Tableau Server configuration, click the SAML tab.
b. Select the checkbox of Use SAML for single sign-on.
c. Tableau Server return URL—The URL that Tableau Server users will be accessing, such as http://tableau_server. Using http://localhost is not recommended. Using a URL with a trailing slash (for example, http://tableau_server/) is not supported. Copy Tableau Server return URL and paste it to Azure AD Sign On URL textbox in Tableau Server Domain and URLs section.
d. SAML entity ID—The entity ID uniquely identifies your Tableau Server installation to the IdP. You can enter your Tableau Server URL again here, if you like, but it does not have to be your Tableau Server URL. Copy SAML entity ID and paste it to Azure AD Identifier textbox in Tableau Server Domain and URLs section.
e. Click the Export Metadata File and open it in the text editor application. Locate Assertion Consumer Service URL with Http Post and Index 0 and copy the URL. Now paste it to Azure AD Reply URL textbox in Tableau Server Domain and URLs section.
f. Locate your Federation Metadata file downloaded from Azure portal, and then upload it in the SAML Idp metadata file.
g. Click the OK button in the Tableau Server Configuration page.
Customer have to upload any certificate in the Tableau Server SAML SSO configuration and it will get ignored in the SSO flow. If you need help configuring SAML on Tableau Server then please refer to this article Configure SAML.
You can now read a concise version of these instructions inside the Azure portal, while you are setting up the app! After adding this app from the Active Directory > Enterprise Applications section, simply click the Single Sign-On tab and access the embedded documentation through the Configuration section at the bottom. You can read more about the embedded documentation feature here: Azure AD embedded documentation
Creating an Azure AD test user
The objective of this section is to create a test user in the Azure portal called Britta Simon.
To create a test user in Azure AD, perform the following steps:
In the Azure portal, on the left navigation pane, click Azure Active Directory icon.
To display the list of users, go to Users and groups and click All users.
To open the User dialog, click Add on the top of the dialog.
On the User dialog page, perform the following steps:
a. In the Name textbox, type BrittaSimon.
b. In the User name textbox, type the email address of BrittaSimon.
c. Select Show Password and write down the value of the Password.
d. Click Create.
Creating a Tableau Server test user
The objective of this section is to create a user called Britta Simon in Tableau Server. You need to provision all the users in the Tableau server.
That username of the user should match the value which you have configured in the Azure AD custom attribute of username. With the correct mapping the integration should work Configuring Azure AD Single Sign-On.
If you need to create a user manually, you need to contact the Tableau Server administrator in your organization.
Assigning the Azure AD test user
In this section, you enable Britta Simon to use Azure single sign-on by granting access to Tableau Server.
To assign Britta Simon to Tableau Server, perform the following steps:
In the Azure portal, open the applications view, and then navigate to the directory view and go to Enterprise applications then click All applications.
In the applications list, select Tableau Server.
In the menu on the left, click Users and groups.
Click Add button. Then select Users and groups on Add Assignment dialog.
On Users and groups dialog, select Britta Simon in the Users list.
Click Select button on Users and groups dialog.
Click Assign button on Add Assignment dialog.
Testing single sign-on
In this section, you test your Azure AD single sign-on configuration using the Access Panel.
When you click the Tableau Server tile in the Access Panel, you should get automatically signed-on to your Tableau Server application. For more information about the Access Panel, see introduction to the Access Panel.