SharePoint

This guide sets up the SharePoint connector, which inventories your SharePoint sites, document libraries, and Excel workbooks through the Microsoft Graph API. Datalogz reads metadata only; it never accesses the data inside your files.

There are two ways to authenticate. App mode (recommended) uses an application registration with client credentials. User mode signs in as a user via Microsoft's device-code flow.

Step 1: Register an application in Microsoft Entra (app mode)

1. Register a new application in the Microsoft Entra portal. Note the Application (client) ID and Directory (tenant) ID.

2. Under API permissions, add the Microsoft Graph application permissions Sites.Read.All and Files.Read.All, and grant admin consent.

3. Under Certificates & secrets, create a client secret and copy its value immediately. It cannot be viewed again later.

Step 2: Create the connector in Control Tower

1. Sign in to Datalogz Control Tower and go to Settings > BI Connectors.

2. Click New Connector and select SharePoint.

3. Choose your authentication mode. For app mode, enter the Directory (Tenant) ID, Application (Client) ID, and client secret. For user mode, follow the device-code sign-in prompts.

4. Choose the scope: sync all sites in the tenant or an allowlist of specific sites.

5. Enter a Connector Name and select the snapshot frequency.

6. Click Next, then Confirm and Finish.

Control Tower ingests sites, document libraries, and files, including an inventory of Excel workbooks (worksheets, tables, pivot tables, and more). Syncs are incremental, so unchanged libraries are not re-scanned.

For questions or help with this setup, contact [e-mail].