You can create connections to your Microsoft SharePoint instance from . You can create connections to:
NOTE: This connection supports reading from and writing to SharePoint lists.
For more information on Microsoft SharePoint, see https://www.microsoft.com/en-us/microsoft-365/sharepoint/collaboration.
The logged-in user must have required access to the tables and schema. For more information, see Using SharePoint.
General relational connectivity must be enabled. For more information, see Enable Relational Connections.
To create this connection, in the Connections page, select the Applications tab. Click the SharePoint card. See Connections Page.
This connection can also be created using the API.
Enter the URL for your SharePoint Site or sub-site. Example value:
Product edition of SharePoint in use:
|User Name||Username to use to connect to SharePoint.|
|Password||Password associated with the above username.|
After you have defined the Share Point Edition, credentials, and connection string, you can validate those credentials.
|Additional Connect String Options|
Apply any connection string options that are part of your authentication to SharePoint.
A default string has been provided for you. For more information, see below.
|Default Column Data Type Inference|
|Connection Name||Display name of the connection|
|Connection Description||Description of the connection, which appears in the application.|
The following connection string is provided for you:
|AutoCache||When enabled, the connection leverages any data that is automatically cached for each table. The default is |
|CacheMetadata||When enabled, table metadata can be retrieved from the SharePoint cache. The default is |
|CacheTolerance||This setting defines the duration in hours that objects are permitted to live in the cache. The default is |
This setting defines the number of seconds that a query to the SharePoint database is allowed to run without a response. The SharePoint default timeout is
The default value in the Connect String Options is
|ShowPredefinedColumns||When enabled, users of the connection are permitted to view the columns that are created with the table, such as Created By and Modified By columns. The default is |
For more information, see http://cdn.cdata.com/help/RSF/jdbc/Connection.htm.
You can import datasets from SharePoint through the Import Data page. See Import Data Page.