Looking for a way to query Sharepoint lists from SQL Server. In so doing, I would be able to mix information from the lists with information I already have in a database (think: user-updateable parameters to control queries). Ultimately, the data will feed Reporting Services reports, but it is only useful if the Sharepoint list is combined with other data. Has anyone achieved this or have suggestions as to where to look?
Things I have tried:
- Use Access 2007 to hold a linked table to the list. Can query the list in Access, but SQL Server doesn't seem to be able to go the double jump (to Access and then to Sharepoint). SQL can query a native Access table just fine.
- Use Reporting Services to query the same Access 2007 linked table. Works fine, but the problem is that I am using a separate RS data source and datasets in my report and need to combine the data from sharepoint with data from other data sources. Suggestions for this?
- Set up an RS data source as XML rather than text query. Works ok on my workstation, not on the server itself. But the main problem is again as above, this is a separate data source that needs joining with other data sources.
Many thanks to anyone who can help!