3446524 - How to create an import data connection to Microsoft SharePoint in SAP Analytics Cloud (SAC)?

Images and data taken from SAP internal systems and demo environments. Any similarity to production data is purely coincidental.

• SAP Analytics Cloud (Cloud Foundry).
• SAP Integration Suite Open Connectors.
• Microsoft SharePoint.

Prerequisites

1. SAC is hosted on a non-SAP data center (Cloud Foundry environment) and not located within China.
2. Open Connectors is configured in SAC. If not configured, configuration steps can be found in the KBA 3435156 - How to configure SAP Integration Suite Open Connectors in SAP Analytics Cloud (SAC)

Procedures

1. Login to Microsoft Azure home page https://azure.microsoft.com/.
2. Click "Microsoft Entra ID" in the left navigation menu.
3. Click Add button, in the dropdown list, select "App registration".
    
4. In the App registration dialogue, enter the Name, select the Supported account type and enter the Redirect URI and click Register button.
   Note: Use the URL: https://bocauth.us1.sapbusinessobjects.cloud:443.
   Or if your SAP Business Technology Platform (BTP) landscape is operating in European Union (EU) Access mode (for data protection within the EU), use https://bocauth.eu1.sapbusinessobjects.cloud/.
   For example,
   
5. The registration only has the User.Read permission from Microsoft Graph APIs, it is needed to add the required permissions to access SharePoint REST APIs. Select "API permissions" in the left navigation menu, and then click "Add a permission" to add permissions for SharePoint APIs.
   
6. Select "Delegated permissions" for accessing APIs as signed-in user. As SAP Integration Suite Open Connectors accesses the API via the signed-in user.
   
7. Only select the permission "AllSites.Read".
    
8. Select Certificates & secrets tab from the left menu, click on New client secret. 
   
9. Then enter the description and select the expire time in the Add a client secret dialogue and click add button.
   Note down the secret value, which is the OAuth API Secret used to fill in SAC connection page:
   
10. Click Overview in the left navigation menu, note down the Application (client) ID, which is the OAuth API Key used in the SAC connection page.
    
11. In SAC, from the side navigation, choose  Connections   (Add Connection).
    The Select a data source dialog will appear.
12. Select SharePoint.
13. Enter the Connection Name, Description, SharePoint Site Address, OAuth API Key (get from step 10), and OAuth API secret (get from step 9).
    Note: Remove "https://", primary corporate site is <CompanyName>.sharepoint.com, team site: <CompanyName>.sharepoint.com/sites/<SiteName>. For example: SAP.sharepoint.com/sites/SAC.
    
14. Click Create button, in the pop up dialogue, click Trust button to trust the registered application.
15. Connection is successfully created.

If even after creating the connection successfully, the model creation throws the error: "An error occurred while parsing service metadata: undefined
Correlation ID: 10825526282041139621928911328103". Please check the KBA: 3253981 - Error:"An error occurred while parsing service metadata: undefined" occurs when creating a model from a SharePoint Data Source in SAC.

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-AQU-CLD , Data acquisition from Cloud-based (non-OData) sources , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To