Use the SharePoint browser to read sources stored as SharePoint Lists, or you can select or create Lists to which to publish job results. Contents:
Your Trifacta deployment must be connected to a running instance of SharePoint Online or SharePoint On-Premises.
- The SharePoint browser appears when:
NOTE: You can read from and write to SharePoint Lists only. For more information, see Using SharePoint.
Use the links and icons to browse for SharePoint databases and Lists. When you select a SharePoint database, you can select one of the available Lists.
NOTE: Avoid using the Back button on your browser, which exits the SharePoint browser without applying changes to your configuration.
NOTE: The top-level object in the SharePoint Browser is the
SOAP schema. This object cannot be edited or imported.
|Database||Click a database link to display its tables.|
Click the Plus icon to select this SharePoint List as your source.
Use these links to navigate between pages of databases and Lists.
Click the links in the breadcrumb trail to navigate.
To filter the list of databases or Lists, enter a string in the Search box. The filter is applied as you type and matches anywhere in the name of a currently displayed database or List name.
Preview List Data
Database Lists are displayed by name only. To preview the data in the List, click the Eye icon next to the name of the List.
Tip: List previews include available metadata information, such as column headers and column and row counts.
Create Dataset with SQL
As needed, you can pre-filter the selected List inside the database. By entering a custom SQL statement, you can remove unnecessary data from the dataset that is extracted from the database, which enables faster and more meaningful imports of your database data. See Create Dataset with SQL.For more information, see Enable Custom SQL Query.
This page has no comments.