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

回答1:

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

• Using the SSIS OData Source Connector with SharePoint Online
• Using the OData Source in SQL Server Integration Services
• Connecting to SharePoint from SSIS using OData Source

(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:

• MsSQL SSIS Community

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

• Project Releases

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

• Extracting and Loading SharePoint Data in SQL Server Integration Services

(3) Using third party components

• KingswaySoft SSIS Integration Toolkit for Microsoft SharePoint
• AxioWorks SQList