You can connect to your
Sharepoint 2010 list data using the
OData connector.
Please note - versions of Sharepoint before Sharepoint 2010 are not supported.
You should first ensure that your Sharepoint 2010 Server is set up to run the list service by browsing to:
http://[YOUR_SERVER]/_vti_bin/ListData.svcAnd ensure there are no errors. If you receive a message saying:
Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
Please take a look at this blog post:
http://blog.fpweb.net/sharepoint-2010-fix-for-common-odata-error/You will probably need to use Windows authentication to connect to Sharepoint. For this you will need version 0.9.0 of the
QVSource OData connector or later.
You can either leave the username and password blank (in which the connector will use your current windows credentials) or optionally enter them as illustrated below:
Your service end point should look something like this:
http://[YOUR_SERVER]/_vti_bin/ListData.svc