Copy Data from SharePoint List to SQL Server
Posted on 2013-06-07
We have a very tightly controlled environment for our SharePoint SQL server. I need to create a table and replicate the data from a SharePoint List nightly for a OLAP Cube I am building for BI.
It is very easy to do this apparently with SSIS using add-ons and plug-ins. These would all be considered prohibited unless they came right from Microsoft.com, and even then it would probably require months of paperwork. Anything else, like from codeplex.com, is a moot argument not even worth starting.
Is there any out-of-the box way to pull data from a SharePoint List to a SQL database? I have seen other references to just writing a small helper program in a language like C# around the SharePoint APIs. Again, not going to happen due to the strict requirements prohibiting custom code.
I am hoping there is some fancy work-around that simply leverages existing tools. Any ideas?