Using Data Services on top of Sharepoint webservices

[Former Member]

Hi all,

Is it possible from Data Services to connect to Sharepoint lists exposed as webservices?

Thus using Data Services as the ETL framework between Sharepoint and SAP BW?

Hope you can help out.

[former_member187605 · Accepted solution]

DS can consume any Web Service. Check http://wiki.scn.sap.com/wiki/display/EIM/Consuming+an+external+Web+Service for how to build the data flow.

[Former Member · Accepted solution]

Thanks for your answer.

Is there to your knowledge anything special to be aware of in regards to using web services from SharePoint?

[severin_thelen · Accepted solution]

In my opinion DS make no difference between different web service providers. So there should not be anything special you have to be aware of.

Regards

Severin

[Former Member]

you may face challenges when using SharePoint Webservices, especially if you are using NTLM authentication, this is not supported with WebServices datastore, I did manage to make it work in older DS version using Webservice adapter in few cases

other thing that you need to ensure is the WSDL should have complete schema and fixed schema for both input and output, DS doesn't support dynamically changing schema. This is easy to work around

only challenge will be NTLM auth, if you are using basic auth then it should be fine

few customers has worked around this by writing wrapper webservices, in worst case you can try that approach too