How to extract data from Sharepoint Using BODS

[Former Member]

Hi,

Existing Scenario:

Data is extracted from SharePoint in xls format and placed at a shared path from where it gets picked up by BODS and loaded into the target system. This data extraction from SharePoint is a manual activity, so each day, file is extracted manually and placed for BODS.

Desired Scenario:

To avoid this manual activity, it is required to extract data directly from SharePoint via BODS and load into target system without any manual intervention.

Can this be achieved ?

Any pointers will be helpful.

Thanks,

Sumant

[Former Member]

Suraj,

I had the exact same question a few weeks back and received the following suggestions. Please check thread below.

http://scn.sap.com/thread/3695115

We adopted the path of writing a script to download the file to a shared server which can be accessed by the job server.

-Chaitanya