Solved

Copy Data from SharePoint List to SQL Server

Posted on 2013-06-07
1
599 Views
Last Modified: 2016-02-11
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
0
Comment
Question by:jkeagle13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 425 total points
ID: 39230083
Hi,
question: can you use SSIS or not?
What are existing tools in your situation?
And sirry, but having no custom code means no T-SQL as well.
BTW, the SSIS connector to Sharepoint is built from the SQL dev team.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision Office 365 tenants, synchronize your on-premise Active Directory, and implement Single Sign-On.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to increase the row limit in Jasper Server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question