Page tree

Trifacta SaaS


Contents:

   


Feature Availability: This feature is available in the following editions:

  • Trifacta® Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium
  • Trifacta Standard

Contents:


Use the SharePoint browser to read sources stored as SharePoint Lists, or you can select or create Lists to which to publish job results.
  • Your Trifacta deployment must be connected to a running instance of SharePoint Online or SharePoint On-Premises.

  • The SharePoint browser appears when:
    • You select the SharePoint connection to create a dataset. See Import Data Page.
    • You choose to add a publishing location in SharePoint. See Run Job Page.

NOTE: You can read from and write to SharePoint Lists only. For more information, see Using SharePoint.

Figure: SharePoint Browser

Browse 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.

IdentifierTypeDescription

DatabaseClick a database link to display its tables.
List

Click the Plus icon to select this SharePoint List as your source.

Page navigation

Use these links to navigate between pages of databases and Lists.

Breadcrumb

Click the links in the breadcrumb trail to navigate.

Search List

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.

This page has no comments.