Microsoft Excel Online Reader

Note

This adapter is in preview and is available on Striim Developer only. See Striim Developer for more information.

Excel Online is the web-based version of Microsoft Excel, part of the Microsoft Office suite of tools, which allows users to create, edit, and share spreadsheets directly in a web browser. It provides a lightweight and collaborative way to work on Excel files without requiring the desktop application.

The Microsoft Excel Online Reader connects with the Excel Online platform and reads supported objects.

Feature summary

Feature		Supported?	Notes
Objects	Standard objects	✓
Objects	Custom objects	✓
Authentication	Basic authentication		Username and password
	OAuth authentication	✓	Manual configuration based
	Custom authentication methods		Not all methods may be supported
Operations	Automated mode	✓
	Initial load	✓
	Pull-based incremental load	✓
	Push-based incremental load
	Automated pipeline
Governance	Connection profile
	Sherlock AI
	Sentinel AI
Schema handling	Initial schema creation	✓	Works with supported targets
Schema handling	Schema evolution
Setup	Wizard template
	Flow Designer	✓
	Striim TQL	✓
Runtime	Resilience/recovery	✓
	Parallel execution
	Metrics	✓	Standard metrics

Supported authentication method

Microsoft Excel Online supports user-based authentication using Azure AD, which leverages OAuth 2.0 for authentication and authorization. Creating a connection involves registering an application, obtaining client credentials, retrieving an authorization code via the redirect URL, exchanging the authorization code for an access token and refresh token, and configuring connection properties in Striim.

In the left navigation pane, select Azure Active Directory > App registrations.
Click New registration.
Enter a name for the application.
Specify the types of accounts this application should support:
- For private use applications, select Accounts in this organization directory only.
- For distributed applications, select one of the multi-tenant options.
Note
If you select Accounts in this organizational directory only (default), when you establish a connection with the Microsoft Excel Online Reader you must set the Azure Tenant to the ID of the Azure AD Tenant. Otherwise, the authentication attempt fails.
Set the redirect URI to http://localhost:33333 (default) OR, if you want to specify a different port, specify the desired port and set CallbackURL to the exact reply URL you just defined.
To register the new application, choose Register. An application management screen displays. Record these values for later use. (You will use the Application (client) ID value to set the OAuth Client ID parameter, and the Directory (tenant) ID value to set the Azure Tenant parameter.)
Navigate to Certificates & Secrets. Select New Client Secret for this application and specify the desired duration. After the client secret is saved, the Azure App Registration displays the key value. This value is displayed only once, so record it for future use. (You will use it to set the OAuth Client Secret.)
Add the following application permissions: Sites.Read.All, Files.Read, Files.Read.All, Files.Read.Selected, Files.ReadWrite, Files.ReadWrite.All, Files.ReadWrite.AppFolder, Files.ReadWrite.Selected, and offline_access.
If you have specified the use of permissions that require admin consent (such as the Application Permissions), you can grant them from the current tenant on the API Permissions page.

To grant admin consent:

Have an admin log in to the Azure portal at https://portal.azure.com.
Navigate to App Registrations and find the custom Azure AD application you created.
Under API Permissions, click Grant Consent and follow the wizard.

This gives your application permissions on the tenant under which it was created.

Supported objects

The following are the supported objects for reading from Microsoft Excel Online:

Drives
SharePointSites
SharedDocuments
Workbooks
Worksheets