SharePoint Lists (JDBC)

This document describes how to connect Tableau to the SharePoint Lists (JDBC) driver and set up the data source.

Note: The SharePoint Lists JDBC connector requires Tableau 2022.3 or later and the SharePoint Lists JDBC driver.

Before you connect

Before you begin, gather this connection information:

  • The URL to the SharePoint site that contains the lists you want to connect to

  • The edition of your SharePoint server: on premises or SharePoint Online

  • The method of authentication: Azure AD, third-party SSO or integrated authentication

  • The user name or email address, password, and (optionally) SSO domain, if needed

    Required API Permissions

    Grant Tableau the following application programming interface (API) permissions.

    • profile
    • openid
    • email
    • AllSites.Manage
    • offline_access
    • User.Read

Recommendation

Setup a custom OAuth Client to use your company's IT policies

You can fully control your OAuth configuration according to your own IT policies with a custom OAuth client. The option to use your own OAuth client frees you from being tied to Tableau release cycles and Tableau’s OAuth client rotation schedule.

Driver required

This connector requires a driver to talk to the database. You might already have the required driver installed on your computer. If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download(Link opens in a new window) page where you can find driver links and installation instructions.

Make the connection and set up the data source

1. Start Tableau and under Connect, select SharePoint Lists (JDBC).

2. In the Server text box, enter the SharePoint URL.

3. Select the Edition: On Premise or SharePoint Online.

4. Select the Authentication method: Azure AD, Username and Password, NTLM, ADFS or Basic.

5. If Azure AD is chosen, select Sign In.

6. For other authentication methods, enter the required information, and then select Sign In.

 

On the Data source page, do the following:

1. (Optional) Select the default data source name at the top of the page, and then enter a unique data source name for use in Tableau.

For example, use a data source naming convention that helps other users of the data source figure out which data source to connect to.

2. To start your analysis, select the sheet tab.

Sign in on a Mac

If you use Tableau Desktop on a Mac, when you enter the server name to connect, use a fully qualified domain name, such as mydb.test.ourdomain.lan, instead of a relative domain name, such as mydb or mydb.test.

Alternatively, you can add the domain to the list of Search Domains for the Mac computer so that when you connect, you need to provide only the server name. To update the list of Search Domains, go to System Preferences > Network > Advanced, and then open the DNS tab.

Both Authentication methods on a Mac require you to enter your user name and password to connect.

Refresh your data

Tableau supports only extract connections for SharePoint lists, not live connections. You can update the data by refreshing the extract; incremental refreshes are not supported. For more information, see Refresh Extracts. For information about refresh schedules, see Schedule Extract Refreshes as You Publish a Workbook.

 

See also

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!