Load MS Sharepoint Excel data on SAP DWC

[fagonzalez]

Hello Community,

We are migrating all the local spreadsheets to MS Sharepoint on line, so we need to load some of them to SAP DWC.

Do you know how to integrate DWC with O365?

Thanks in advance.

Fernando

[DebjitSingha]

Hello fagonzalez,

There are multiple options available when it comes to extracting data out of MS SharePoint locatation.

1. SFTP connection to SharePoint server. This is flexible in terms of file type support. Generic SFTP

Supported file types:

• JSON, JSONL

• Parquet

• ORC

• CSV

• XLS, XLSX

2. Open Source JDBC connector to pull data from CSV:

https://github.com/simoc/csvjdbc

3. Flat file consumption (SharePoint):

https://developers.sap.com/tutorials/data-warehouse-cloud-5-import-dataset.html

4. SCP Open Connector option:

How to Connect Microsoft SharePoint with SAP Data Intelligence using SCP Open Connector

5. 3rd Party Connectors:

Video : PreCog Connector (3rd Party)

https://precog.com/integrations/sharepoint-to-sap-data-warehouse-cloud/

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

-Debjit