问题描述
我希望将SQL Server 2012连接到SharePoint服务器。这样可以完成SQL查询。请问什么是简单的方法？
I wish to connect SQL server 2012 to SharePoint server. This do complete SQL queries..what is the easy way to do so please?
我想基本上将数据从SharePoint表下载到SQL Server表中。
I want to download data from a SharePoint table into SQL server table basically.
我只能找到将SharePoint连接到SQL Server的教程。我想反过来
I can only find tutorials connecting SharePoint to SQL server. I want the other way around
也乐于通过SSIS做到这一点。
Happy to do this via SSIS too..
请帮助
推荐答案
从Sharepoint表中读取三个选项：
There are three options to read from Sharepoint table:
您可以使用ODATA Source组件访问共享点列表
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
您可以简单地使用共享点列表适配器组件，这些组件是SQL Server社区在名为 MSSQL SSIS社区：
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
- KingswaySoft SSIS Integration Toolkit for Microsoft SharePoint
- AxioWorks SQList
这篇关于SQL Server连接到SharePoint服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！