jkeagle13
asked on
Copy Data from SharePoint List to SQL Server
Hello,
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?
Thanks,
Joseph Irvine
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?
Thanks,
Joseph Irvine
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.