Skip to Content
0

Extract SharePoint as Source In SAP BODS?

Mar 18, 2017 at 07:00 AM

359

avatar image
Former Member

Hi Experts,

Can we use SharePoint API as a source to extract data from SharePoint Site(by using SharePoint URL) in SAP BODS.

I have requirement to extract the data from Sharepoint REST and load into Teradata, Could you please guide me how to do this requirement.

Thanks,Murali

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Arun Sasi Mar 21, 2017 at 08:56 AM
0

Sharepoint cannot be access directly. It requires NTLM Authentication, which is not supported by DS WebService Adapter or WebService Datastore.

Refer SAP Note 1840879 - Reading/Writing source files from MS Sharepoint - Data Services 4.x

Refer to below links

https://archive.sap.com/discussions/thread/1925432

https://archive.sap.com/discussions/thread/3695115

You should be possible to access the file system on the Sharepoint directly.

The path should look something like this:

\\server domain@SSL\folder1\...\subfolderN\docname

Once you have the files available you can write a script to move the files to Data Services Job Server.

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 28, 2017 at 02:10 PM
0

Arun,

Do you know of a public example that works where we can extract from a webservice URL?

Mike

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 26 at 08:00 AM
0

You can use BODS Odata adapter to extract SharePoint list schema.

Share
10 |10000 characters needed characters left characters exceeded