Page tree

Release 8.2



Contents:

   


Contents:


You can create connections to your Microsoft SharePoint instance from Trifacta® Wrangler Enterprise. You can create connections to:

  • SharePoint On-Premises installations in your enterprise infrastructure
  • SharePoint Online

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.

Limitations

  • Single Sign-On (SSO) is not supported.
  • Column names are not validated on publishing.
  • The SharePoint connection uses SharePoint APIs. As a result, transaction management and rollbacks are not supported.

Pre-requisites

  • The logged-in user must have required access to the tables and schema. For more information, see Using SharePoint.

  • If you haven't done so already, you must create and deploy an encryption key file for the Trifacta node to be shared by all relational connections. For more information, see Create Encryption Key File.

Enable

Configure

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. 

Modify the following properties as needed:

PropertyDescription
SharePoint URL

Enter the URL for your SharePoint Site or sub-site. Example value:

https://exampleserver.sharepoint.com/sites/SharePointTest
SharePoint Edition

Product edition of SharePoint in use:

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

Authentication scheme:

  • Basic - (for SharePointOnline) username and password
  • NTLM - (for SharePointOnPremise) Windows-based authentication scheme for on-premises deployments.
User NameUsername to use to connect to SharePoint.
PasswordPassword associated with the above username.
Test Connection

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

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:

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.
CacheMetadataWhen enabled, table metadata can be retrieved from the SharePoint 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 SharePoint 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/RSF/jdbc/Connection.htm.

Use

You can import datasets from SharePoint through the Import Data page. See Import Data Page.

This page has no comments.