Integrate Sharepoint online with Datasphere

[tom_darsy]

Hi

I have a requirement to load sharepoint online data into Datasphere. Please can you let me know how can this be achieved.

Thanks

[korayyersel_q]

Hi Tom,

yes it is possible and surprisingly quite straight forward. But to my knowledge it is only working for files (csv, excel) placed in a SharePoint document library. As far as I see it is not possible to read data from a Sharepoint List. This is my setup:

1. Create a SAP Integration Suite instance on BTP. Activate SAP Open Connectors.
2. Create a Sharepoint site and place some csv documents under "Documents" (btw in my case it was a Microsoft 365 SharePoint)
3. Create a connection from Open Connector to Sharepoint (https://help.openconnectors.ext.hana.ondemand.com/home/sharepoint-api-provider-setup)
4. Create a connection between SAP Datashpere and SAP Open Connector
5. Now you can browse through Sharepoint files and import data from csv, excel files
   

   
   But as you can see it is listing "Forms" and "Documents". I doesn't list SharePoint Lists. At first I thought that it is a permission issue. But then I could access Sharepoint List in SAP Open Connectors directly using "/sites/lists-by-title/{title}/items" path. I assume that the Datasphere navigation doesn't support Lists.

Best Regards,

Koray

[yzh2014]

Thanks Koray! For step 3 Create a connection from Open Connector to Sharepoint (https://help.openconnectors.ext.hana.ondemand.com/home/sharepoint-api-provider-setup) What is the redirect URI look like? 

[korayyersel_q]

Hi,

To be honest I am not sure anymore. The thing is we have changed our approach. Somehow for SAC > SharePoint integration there is a separate tutorial / SAP note, which works a bit differently:  https://me.sap.com/notes/3446524/E

We found out that if we create a SAC > SharePoint connection using this SAP note we can reuse the Open Connector instance for Datasphere > SharePoint. So this is what we do now. I don't follow the description from above anymore.

In this SAP note it is explained which redirect URI you should use. I assume that for the steps that I have described above same redirect URI should be fine.

Best,

Koray