This section describes how you interact through Trifacta® 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.
NOTE: Non-tabular data and some SharePoint List columns are converted to strings on import. For more information, see SharePoint Data Type Conversions.
- No schema validation is performed as part of writing results to SharePoint Lists.
Uses of SharePoint
Trifacta 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
Read Access: Your SharePoint administrator must configure read permissions.
Write Access: You can write and publish jobs results to SharePoint.
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.
NOTE: Trifacta 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 Trifacta dataset from a List stored in SharePoint.
NOTE: Reading data is supported for SharePoint Lists only.
For more information, see SharePoint 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:
NOTE: Some Trifacta data 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.
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.
This page has no comments.