CData TDV Adapter for SharePoint
SharePoint Version Support
The adapter supports all versions of SharePoint that support the SOAP API. This includes: Windows SharePoint Services 3.0, SharePoint Server 2007+ (2010, 2013, etc.), and SharePoint Online. The adapter models the custom lists of your SharePoint site as bidirectional tables; when you connect, the adapter retrieves the metadata for these tables by calling SharePoint Web services. Supported authentication schemes are NTLM, Basic, Digest, Forms, Kerberos, SSO, STS (security token services), and SharePoint authentication cookies.
The SQL Compliance
section shows the SQL syntax supported by the adapter and points out any limitations.