Our customer wanted to combine data from SharePoint files with SAP data in an SAP Analytics Cloud (SAC) dashboard. Since there is no native SharePoint connector for SAP Datasphere, Analytics Consultant, Uzair Barday created a connection using SAP BTP’s open connector, which he then utilised in SAP Datasphere.
Uzair outlines and demonstrates the required steps for establishing a connection from SAP Datasphere to SharePoint in this short video:
BTP Open Connector for Sharepoint
Here are the steps:
- Register an app for SharePoint API Access in Azure Active Directory
- Configure the registered application’s SharePoint API permissions
- Generate certificates and secrets for your registered app
- Create a SharePoint Open Connector instance in SAP BTP Integration Suite
- Establish a connection to your SharePoint Open Connector in Datasphere
- In Datasphere, create a dataflow to read your SharePoint directory
- In SAC create your story using your SharePoint-based model in Datasphere
The full end-to-end instructional document with details of how to complete each step can be found in Uzair’s SAP Community blog post.
SAP Analytics Cloud, SAP Datasphere, SAP Integration Suite, Open Connectors, SAP Business Technology Platform
