KNOWLEDGE BASE

Configure Sharepoint Lists (JDBC) connector on Tableau Server


Published: 17 Jan 2023
Last Modified Date: 17 Jan 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.
Did this article resolve the issue?