Configure Sharepoint Lists (JDBC) connector on Tableau Server

Published: 17 Jan 2023
Last Modified Date: 16 Nov 2023

Question

How to configure the Sharepoint Lists (JDBC) connector on Tableau Server.

Environment

Tableau Server 2022.3
SharePoint Lists (JDBC)

Answer

On each node of a Tableau Server instance:

1. Download the packaged Sharepoint Lists (JDBC) Tableau connector (TACO) file or "cdata.sharepoint.taco", from the Tableau Exchange.

2. Move the .taco file to the following directory on each node of a Tableau Server instance:

Windows: C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors
Linux: [Your Tableau Server Install Directory]/data/tabsvc/vizqlserver/Connectors

3. Download and install the SharePoint Lists JDBC driver from the Tableau Driver center. The JDBC driver ( data.tableau.sharepoint.jar) needs to be placed in the following directory on each node of a Tableau Server instance:

Windows: C:\Program Files\Tableau\Drivers
Linux: /opt/tableau/tableau_driver/jdbc

4. Restart Tableau Server

Additional Information

There are no licensing fees when you use the CData driver with the SharePoint Lists (JDBC) Tableau Connector. However, if you use the CData driver with the Tableau Other Databases (ODBC) connector or outside of Tableau, licensing fees will apply.

If Tableau Prep flows fail with the error, "Error: TableauException: Unable to find a matching connection config constructor for this class name: cdata_sharepoint", please review the information on Running a packaged connector in Tableau Server to ensure the .taco file is placed in the correct directories.