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

[VivekKumarVS]

Hi @korayyersel_q 

We have subsite associated with sahrepoint and not sure how to access this in Datasphere. We tried below combination but getting Access denied error in Datasphere.

SharePoint Site Address: https://<domain>.sharepoint.com

Documents Library: 'Shared Documents' or 'sites/XXXX/Shared Documents'

When you say "I could access Sharepoint List in SAP Open Connectors directly using "/sites/lists-by-title/{title}/items" path" where did you enter this path?

Regards,

Vivek

[korayyersel_q]

Hi Vivek,

in Open Connectors we enter the subsite url:

xxx.sharepoint.com/sites/mainSite/subSite

After that we use this connection in SAC and Datasphere. For example, in datasphere you can navigate through the folders like this:

Best,

Koray

[VivekKumarVS]

Thanks Koray. It helped me set up connectivity for sharepoint files.
Can you please help with setting when we want to read lists from sharepoint? What should be the format of 'Sharepoint address' and 'Document library' fields?

Regards,

Vivek

[korayyersel_q]

@VivekKumarVS

[korayyersel_q]

@VivekKumarVS it is (at least was) not supported. please check my comment from ‎26.01.2024

[EmanuelGraves]

You'll primarily need to use the SharePoint Online connector from Datasphere's interface. First, make sure you have the necessary permissions on both SharePoint Online and Datasphere. Then, in Datasphere, select the SharePoint Online connector, provide your SharePoint site's URL, and authenticate your access. Once connected, you can select the specific data or documents you wish to import into Datasphere. Alternatively, you can also use an Office 365 Backup so that your SharePoint data is not only backed up securely but also intelligently managed. You can read about it at https://loopbackup.com/cloud-to-cloud-backup-for-microsoft-office-365/. It should make the data more accessible and easier to import into almost any system.

[klorn_pallier]

Hi, I have the same question about lists data. I couldn't get the connector to work with lists in Datasphere.

[korayyersel_q]

I have opened an incident about this. SAP confirmed: SharePoint lists are not supported.

[thorebedey]

Hi Tom,

inside DSP, you can integrate your SAP Open Connectors account to query data from a variety of sources, including Sharepoint or oneDrive.
See the Open Connectors Catalog here

BR,

Thore

[tom_darsy]

Hi Thore

In the Sharepoint API documentation, there is nothing mentioned about Get Lists data. Is there any other tool I can use for integration and load data into Datasphere?

Thanks