Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

D s ed
rtrue
editionsgdpent,gdppro,gdppr,gdpst,awsent,awspro,awspr,awsst


Excerpt

You can create connections to your Microsoft 

D s conntype
typesharepoint
 instance from 
D s product
rtrue

You can create connections to:

  • D s conntype
    typesharepoint
     On-Premises installations in your enterprise infrastructure
  • D s conntype
    typesharepoint
     Online
Info

NOTE: This connection supports reading from and writing to

D s conntype
typesharepoint
lists.

For more information on Microsoft

D s conntype
typesharepoint
, see https://www.microsoft.com/en-us/microsoft-365/sharepoint/collaboration.

Limitations

D s conn req sql

  • Single Sign-On (SSO) is not supported.
  • Column names are not validated on publishing.
  • The SharePoint connection uses
    D s conntype
    typesharepoint
     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

  • The logged-in user must have required access to the tables and schema. 

Configure

To create this connection, in the Connections page , select the Applications tab. Click the

D s conntype
typesharepoint
 card. See Connections Page.

Modify the following properties as needed:

PropertyDescription

D s conntype
typesharepoint
URL

Enter the URL for your

D s conntype
typesharepoint
Site or sub-site. Example value:

Code Block
https://exampleserver.sharepoint.com/sites/SharePointTest

D s conntype
typesharepoint
Edition

Product edition of

D s conntype
typesharepoint
in use:

  • SharePointOnPremise - Use this option if you have an on-premises installation of
    D s conntype
    typesharepoint
    to which you can connect within your enterprise infrastructure.
  • SharePointOnline - Use this option if you are connecting to
    D s conntype
    typesharepoint
    Online.
Auth Scheme

Authentication scheme:

  • Basic - (for SharePointOnline) username and password
  • NTLM - (for SharePointOnPremise) Windows-based authentication scheme for on-premises deployments.
User Name

Username to use to connect to

D s conntype
typesharepoint
.

PasswordPassword associated with the above username.
Test Connection

After you have defined the

D s conntype
typesharepoint
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

D s conntype
typesharepoint
.

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 NameDisplay name of the connection
Connection DescriptionDescription 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


ParameterDescription
AutoCacheWhen 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

D s conntype
typesharepoint
cache. The default is false .

CacheToleranceThis 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

D s conntype
typesharepoint
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.

ShowPredefinedColumnsWhen 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

D s conntype
typesharepoint
. See Database Browser.

Using SharePoint Connections

This section describes how you interact through 

D s product
rtrue
 with your SharePoint Lists.

  • SharePoint is a content management system for sharing and collaborating across the enterprise. For more information, see https://sharepoint.microsoft.com
  • In SharePoint, data is stored in an object called a List. Lists can also include non-tabular data. 

    Info

    NOTE: Non-tabular data and some SharePoint List columns are converted to strings on import. For more information, see SharePoint Data Type Conversions.

Uses of  SharePoint

D s product
 can use SharePoint for the following tasks:

  1. Import datasets by reading from SharePoint Lists.
  2. Write to SharePoint Lists with your job results.

Before You Begin Using SharePoint

  • Read Access: Your SharePoint administrator must configure read permissions. 

  • Write Access: You can write and publish jobs results to 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:

D s product
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 

D s item
itemdataset
 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:

  • Job results can be written directly to SharePoint as part of the normal job execution. Create a new publishing action to write to SharePoint. See Run Job Page.

  • For more information on how data is converted to SharePoint, see SharePoint Data Type Conversions

Data Validation issues:

Info

NOTE: Some

D s item
itemdata types
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

D s also
labelsharepoint