The Tetra SharePoint Online Connector is a standalone, containerized application that uploads data from SharePoint Online document libraries to the Tetra Data Platform (TDP). It can be deployed in the cloud or on-premises by using a Tetra Hub and can monitor multiple folders across many SharePoint sites.

Design Overview

Polling is performed on a configurable interval, where the Connector uploads files reported by the Graph API delta query for the target folder and subdirectories. During this process, the Connector polls one folder at a time, processing delta query response pages sequentially. For each file being processed, the Connector fetches the file-related and SharePoint document library metadata, transforms them into labels, and then uploads the file with its associated labels to the TDP. You can configure the Connector to poll one or more folders in SharePoint Online for changes by using Microsoft Delta Queries.

For authentication and authorization, the Connector uses OAuth 2 client credentials flow and Microsoft enterprise application credentials.

Architecture

As a containerized application, the Tetra SharePoint Online Connector can be deployed to an on-premises Tetra Hub or the cloud. The following diagram shows an example workflow for a Tetra SharePoint Online Connector cloud deployment within a Tetra hosted multi-tenant or customer hosted (single-tenant) TDP deployment.

The diagram illustrates the following workflow:

1. The Connector sends a SharePoint Delta Query to poll SharePoint’s Graph API on an interval. During the poll, the Connector collects all file changes in a page of changes reported by the Microsoft Graph API and registers them for upload.
2. The Connector iterates over all SharePoint files to upload, and then collects the SharePoint DriveItem and ListItem metadata. This metadata is transformed into TDP labels.
3. The Connector uploads files and their file changes to the TDP. If the delta query response indicates that additional updates exist, then the Connector continues with the poll by sending the indicated delta query.

Prerequisites

• SharePoint Online Sites and corresponding document libraries are created and ready
• Tetra Data Platform (TDP) version 3.6 or higher
• A Microsoft enterprise application with credentials that the Connector can use along with authorization permissions to access files and their metadata in SharePoint Online sites
• (Optional) Tetra Hub. Although typically unnecessary because SharePoint Online and the TDP are cloud services, it is possible to deploy the Tetra SharePoint Online Connector as a standalone service to a Tetra Hub for on-premises networking requirements. If deployed to a Tetra Hub, internal networking/firewalls rules to allow communication between the Connector and the Hub must be configured. For more information, contact your customer success manager (CSM).

Operational Guides

For installation and operational instructions, see the Tetra SharePoint Online Connector v1.x Operational Guide.

Documentation Feedback

Do you have questions about our documentation or suggestions for how we can improve it? Start a discussion in TetraConnect Hub. For access, see Access the TetraConnect Hub.

📘

NOTE

Feedback isn't part of the official TetraScience product documentation. TetraScience doesn't warrant or make any guarantees about the feedback provided, including its accuracy, relevance, or reliability. All feedback is subject to the terms set forth in the TetraConnect Hub Community Guidelines.