| D s ed |
|---|
| r | true |
|---|
| editions | gdpent,gdppro,gdppr,gdpst,awsent,awspro,awspr,awsst |
|---|
|
| Excerpt |
|---|
You can create connections to your Microsoft instance from . |
You can create connections to:
- On-Premises installations in your enterprise infrastructure
- Online
| Info |
|---|
NOTE: This connection supports reading from and writing to lists. |
For more information on Microsoft
, see
https://www.microsoft.com/en-us/microsoft-365/sharepoint/collaboration.
Limitations
- Single Sign-On (SSO) is not supported.
- Column names are not validated on publishing.
- The SharePoint connection uses APIs. As a result, transaction management and rollbacks are not supported.
- No schema validation is performed as part of writing results to SharePoint Lists.
Prerequisites
To create this connection, in the Connections page , select the Applications tab. Click the card. See Connections Page.
Modify the following properties as needed:
| Property | Description |
|---|
| Enter the URL for your Site or sub-site. Example value: | Code Block |
|---|
https://exampleserver.sharepoint.com/sites/SharePointTest |
|
| Product edition of in use: SharePointOnPremise - Use this option if you have an on-premises installation of to which you can connect within your enterprise infrastructure.SharePointOnline - Use this option if you are connecting to Online.
|
| Auth Scheme | Authentication scheme: Basic - (for SharePointOnline) username and passwordNTLM - (for SharePointOnPremise) Windows-based authentication scheme for on-premises deployments.
|
| User Name | Username to use to connect to . |
| Password | Password associated with the above username. |
| Test Connection | After you have defined the 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 . A default string has been provided for you. For more information, see below. |
| Default Column Data Type Inference | Set to disabled to prevent the platform from applying its own type inference to each column on import. The default value is enabled . |
| Connection Name | Display name of the connection |
| Connection Description | Description of the connection, which appears in the application. |
Connect string options
The following connection string is provided for you:
| Code Block |
|---|
AutoCache=false;CacheMetadata=false;CacheTolerance=1;timeout=0;ShowPredefinedColumns=false |
| Parameter | Description |
|---|
| AutoCache | When enabled, the connection leverages any data that is automatically cached for each table. The default is false. |
| CacheMetadata | When enabled, table metadata can be retrieved from the cache. The default is false . |
| CacheTolerance | This setting defines the duration in hours that objects are permitted to live in the cache. The default is 1 . |
| timeout | This setting defines the number of seconds that a query to the SharePoint database is allowed to run without a response. The default timeout is 60, which may cause complex queries of larger datasets to timeout. The default value in the Connect String Options is 0 , which means that there is no enforced timeout. Other timeouts may apply. |
| 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 false . |
For more information, see http://cdn.cdata.com/help/RSG/jdbc/Connection.htm.
Use
You can import datasets from
. See
Database Browser.
Using SharePoint Connections
This section describes how you interact through
with your SharePoint Lists.
Uses of SharePoint
can use SharePoint for the following tasks:
- Import datasets by reading from SharePoint Lists.
Write to SharePoint Lists with your job results.
Before You Begin Using SharePoint
Secure access
SSL is available over HTTPS for SharePoint connections.
Storing data in SharePoint
Your SharePoint administrator should provide database access for storing datasets. Users should know where shared data is located and where personal data can be saved without interfering with or confusing other users.
| Info |
|---|
NOTE: does not modify source data in SharePoint. Datasets sourced from SharePoint are read without modification from their source locations. |
Reading from SharePoint
You can create a
from a List stored in SharePoint.
| Info |
|---|
NOTE: Reading data is supported for SharePoint Lists only. |
For more information, see Database Browser.
Writing to SharePoint
You can write back data to SharePoint using one of the following methods:
Data Validation issues:
| Info |
|---|
NOTE: Some do not map exactly to SharePoint List data types. These differences may appear when writing to a new SharePoint List. For more information, see SharePoint Data Type Conversions. |
| Info |
|---|
NOTE: Column name validation is not supported. |
- No validation is performed for the connection and any required permissions during job execution. So, you can be permitted to launch your job even if you do not have sufficient connectivity or permissions to access the data. The corresponding publish job fails at runtime.
- Prior to publication, no validation is performed on whether a target is a table or a view, so the job that was launched fails at runtime.
Reference
Supported versions: n/a
- Read: Supported
- Write: Supported
