Skip to Content

Extract SharePoint as Source In SAP BODS?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 21, 2017 at 08:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2017 at 02:10 PM

    Arun,

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

    Mike

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 26 at 08:00 AM

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

    Add comment
    10|10000 characters needed characters exceeded