topic Re: Read data from SharePoint using ABAP sql command in Application Development and Automation Discussions

Read data from SharePoint using ABAP sql command

Former Member — Mon, 30 Aug 2010 13:30:47 GMT

We need to read data from a SharePoint site and update the sap object services with the information. There is a lot of information on how to put data into Sharepoint from SAP, but we need to get data from SharePoint and put it into SAP. Is it possible to retrieve data from SharePoint using sql command in ABAP program? If it is possible, what do we need to do to have SAP recognize where to get the SharePoint data?

Richard Newman

Re: Read data from SharePoint using ABAP sql command

Former Member — Tue, 31 Aug 2010 06:08:08 GMT

Hi Friend,

Try using FTP concept for this purpose.

Go through this link

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAPsolutiontoimplementFTP+transactions

Cheers

S.Janagar

Re: Read data from SharePoint using ABAP sql command

former_member848108 — Tue, 31 Aug 2010 06:19:09 GMT

Hi Newman,

You can use native sql in your abap code to read data from SharePoint's database. But I would suggest you to generate a SharePoint webservice which can provide you the neccessary data so that you can consume this webservice in ABAP

(Will be quite faster than native sql).

Regards,

Ozcan.

Re: Read data from SharePoint using ABAP sql command

Former Member — Wed, 08 Sep 2010 13:05:58 GMT

Ozcan, speed is not a problem in processing the data. Is SharePoint Webservice KM? We would like to use native sql if it is possible. I cannot see how to have SAP recognize the SharePoint site within the ABAP program like I would for a normal Oracle file outside of SAP. Any suggestions. Thanks.

Richard