Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Read data from SharePoint using ABAP sql command

Former Member

‎2010 Aug 30 2:30 PM

0 Likes
1,370

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

3 REPLIES 3
Read only

Former Member

‎2010 Aug 31 7:08 AM

0 Likes
804

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

Read only

former_member848108
Active Participant

‎2010 Aug 31 7:19 AM

0 Likes
804

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.

Read only

Former Member
In response to former_member848108

‎2010 Sep 08 2:05 PM

0 Likes
804

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