You can now create connections to your Microsoft SharePoint instance from
Trifacta Wrangler Enterprise. You can create connections to:
This connection supports reading from and writing to SharePoint Lists by abstracting the Sharepoint Lists as database tables for Trifacta.
Create a Sharepoint Connection
1. In the left navigation bar click Connections
2. In the Connections Page, click on Create Connection.
3. The Create Connection dialog opens up. Select Sharepoint from the available connection options.
4. Fill in the information to create a Sharepoint connection -
Enter the URL for your SharePoint Site or sub-site. Example value:
Product edition of SharePoint in use:
Username to use to connect to SharePoint.
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
Display name of the connection
Description of the connection, which appears in the application.
Connect string options
The following connection string is provided for you:
When enabled, the connection leverages any data that is automatically cached for each table. The default is
When enabled, table metadata can be retrieved from the SharePoint cache. The default is
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
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.
5. Once done adding the relevant details, click Create - the connection gets added to the list of available connections.
You can now use this to Import as well as Publish to Sharepoint Lists.
To learn more, read the following documentation guides-