Search code examples
sql-serversharepointssissharepoint-2013etl

SQL server connecting to SharePoint server

I wish to connect SQL server 2012 to SharePoint server. This do complete SQL queries..what is the easy way to do so please?

I want to download data from a SharePoint table into SQL server table basically.

I can only find tutorials connecting SharePoint to SQL server. I want the other way around

Happy to do this via SSIS too..

Please help

Solution

  • There are three options to read from Sharepoint table:

    (1) Using ODATA Components

    You can use ODATA Source component to access to the Sharepoint Lists

    (2) Using Sharepoint List adapter

    You can simply use the Sharepoint List adapter components which are an open source project created by SQL Server community within a project called MSSQL SSIS Community:

    You can check the project page at the following link:

    Or you can simply download the assemblies from the link below:

    You can read more about this components in the following link:

    (3) Using third party components