Overview of SharePoint Online Connector

The SharePoint Online (SPO) connector contains multiple Azure services including microservices, web jobs and Azure functions used for inventorying and managing SharePoint Online in EmpowerID. Inventoried information includes SPO site collections, user profiles, webs, groups, roles, role assignments and group membership. This information can managed in EmpowerID as well as managed and synchronized with data in any connected back-end user directories.

Supported Features and Attribute Mappings

User Profile Management
- Inventory user profiles
- Edit user profiles
- Bi-directional synchronization of SharePoint user profiles and EmpowerID Person attributes
Groups Management
- Inventory SharePoint groups
- Add users and groups to SharePoint groups
- Remove users and groups from SharePoint groups
Roles
- Inventory SharePoint roles / permissions
- Inventory SharePoint role assignments of users and groups to SharePoint resources
Webs
- Inventory SharePoint webs
Site Collections
- Inventory SharePoint site collections
User Profile Attribute Flow
The default SharePoint profile properties that EmpowerID can synchronize with and the naming convention used is shown in the below table. Custom attributes can be added as needed.

Azure Components Required by the SharePoint Online Microservice

Key to the SharePoint Online connector is the SharePoint Online (SPO) microservice, which communicates with EmpowerID and your SharePoint to allow you to collect and manage your SharePoint data in EmpowerID. To do so, the microservice needs to be deployed to each SharePoint tenant and each of those tenants needs to be configured with additional Azure components. The number of components needed differs depending on whether you are self-hosting or using EmpowerID SaaS.

Azure Components for Self-hosting EmpowerID

If you are not using EmpowerID SaaS and want EmpowerID to manage one or more of your SharePoint tenants, you need to configure one of those tenants with all of the components shown on the “EmpowerID side” (left) of Figure 1. These components are necessary to inventory SharePoint. In addition to these, you also need to configure each SharePoint tenant to be managed by EmpowerID with all of the components shown on the “Self-hosted” side of Figure 1. The only exception is to this is the Azure AD SCIM app service. This service only needs to be set up once within Azure.

All of the components shown on the EmpowerID side of the image are required whether you are self-hosting EmpowerID or using EmpowerID SaaS. The only difference is when using EmpowerID SaaS, you do not need to set up these components. EmpowerID takes care of that for you.

Figure 1 below image depicts the Azure components you need to configure when self-hosting EmpowerID. The purpose for each component is described in the table that follows the figure.

Figure 1: Azure components you need to configure for SharePoint Online when self-hosting EmpowerID

Table 1: Azure Components you need to configure when self-hosting EmpowerID

Azure Component	Purpose

Azure Component	Purpose
Key Vault	Stores secrets and certificate for the Azure functions and web jobs to access
Cosmo DB	Stores SPO and the SPO site collection information Tracks inventory objects per schedule Stores configuration needed by the SPO app service Used by the AzGeneralService app service to persist data each time a call is made to the service
Az General Service App Service with Managed Identity	Stores and retrieves configuration settings needed by SPO functions and web jobs
Storage Account	Used to store SharePoint site collection and topology information for each site collection in blobs Used to store the data necessary in the queues to trigger the web jobs
Service Bus	Queue stores differential data to be pushed to EmpowerID
Web Jobs App Service with Managed Identity	Call the SPO microservice to retrieve site collections and topology for each site collection and stores them in the blob
SPO Functions Function App with Managed Identity	Function to register SharePoint tenants in Cosmos DB Function to update SharePoint tenants in Cosmos DB Function to delete SharePoint tenants in Cosmos DB Function to claim inventory for SharePoint tenants in Cosmos DB Function to process data in the service bus queue and pushes it to EmpowerID All functions retrieve the configuration data from AzGeneralService App Service
Azure Components Required for each SharePoint Tenant
Azure Component	Purpose
Service Principal application 1	Used to provide Azure AD authentication to the app service that hosts the SharePoint Online microservice
Service Principal application 2	Used to grant API permissions to Microsoft Graph and SharePoint API endpoints
App Service	Used to host the SharePoint Online app service
Key Vault	Stores certificate for certificate-based authentication between the microservice and the service principal registered in Azure for it Stores an access policy that grants key, secret and certificate permissions to the SharePoint Online app service hosting the microservice
Cosmo DB	Stores configuration information needed by the SharePoint Online app service
Function App	Used to update SharePoint user profiles
Azure AD SCIM Microservice	Used to inventory and manage Azure AD information in EmpowerID. This microservice must be deployed to Azure before setting up the SPO microservice. For details, see Connecting to SharePoint Online.

Azure Components Required for EmpowerID SaaS

If you are taking advantage of EmpowerID SaaS, the components you need to configure in Azure are minimal as EmpowerID configures everything needed to inventory SharePoint (represented by the grayed out components on the left side of Figure 2 below). As a SaaS customer, you only need to configure the components shown on the right side of the figure. If you are using EmpowerID to manage more than one SharePoint tenant, you need to configure these components for each of those tenants.

Figure 2: Azure Components you need to configure for SharePoint Online when using EmpowerID SaaS (right-side)

Table 2: Azure Components you need to configure when using EmpowerID SaaS

Azure Component	Purpose

Azure Component	Purpose
Service Principal application 1	Used to provide Azure AD authentication to the app service that hosts the SharePoint Online microservice
Service Principal application 2	Used to grant API permissions to Microsoft Graph and SharePoint API endpoints
App Service	Used to host the SharePoint Online app service
Key Vault	Stores certificate for certificate-based authentication between the microservice and the service principal registered in Azure for it Stores an access policy that grants key, secret and certificate permissions to the SharePoint Online app service hosting the microservice
Cosmo DB	Stores configuration information needed by the SharePoint Online app service
Function App	Used to update SharePoint user profiles
Azure AD SCIM Microservice	Used to inventory and manage Azure AD information in EmpowerID. This microservice must be deployed to Azure before setting up the SPO microservice. For details, see Connecting to SharePoint Online.

EmpowerID Items to Deploy

The SharePoint Online connector includes several components that you need to deploy to Azure from EmpowerID. These components and their related files are listed in the below table.

EmpowerID Component	File

EmpowerID Component	File
AzGeneralService Microservice	AzGeneralServices_MicroserviceV3.zip
Service Principal application 2	Used to grant API permissions to Microsoft Graph and SharePoint API endpoints
App Service	Used to host the SharePoint Online app service
Key Vault	Stores certificate for certificate-based authentication between the microservice and the service principal registered in Azure for it Stores an access policy that grants key, secret and certificate permissions to the SharePoint Online app service hosting the microservice
Cosmo DB	Stores configuration information needed by the SharePoint Online app service
Function App	Used to update SharePoint user profiles
Azure AD SCIM Microservice	Used to inventory and manage Azure AD information in EmpowerID. This microservice must be deployed to Azure before setting up the SPO microservice. For details, see Connecting to SharePoint Online.

Next steps

Register Service Principal for App Service Authentication

Register Service Principal with SharePoint API Permissions

Create an app service for the SharePoint Online Microservice

Create a key vault

Provision a Cosmos DB Account for SharePoint Online

Create a Function app to Update User Profiles

Add application settings to the app service

Add Secret to Key Vault in EmpowerID Tenant

Publish the SharePoint Online Microservice

Configuration of SharePoint Online Inventory - Not Applicable if using EmpowerID SaaS