问题描述
我希望将 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 服务器表中.
I want to download data from a SharePoint table into SQL server table basically.
我只能找到将 SharePoint 连接到 SQL 服务器的教程.我想换个方式
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 组件访问 Sharepoint 列表
You can use ODATA Source component to access to the Sharepoint Lists
- 使用 SSIS OData 源连接器SharePoint Online
- 使用SQL Server 集成服务中的 OData 源
- 使用 OData 源从 SSIS 连接到 SharePoint
您可以简单地使用 Sharepoint List 适配器组件，这些组件是由 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 社区
或者您可以直接从以下链接下载程序集:
Or you can simply download the assemblies from the link below:
- 项目发布
您可以在以下链接中阅读有关此组件的更多信息:
You can read more about this components in the following link:
- 在 SQL Server Integration Services 中提取和加载 SharePoint 数据
- 适用于 Microsoft SharePoint 的 KingswaySoft SSIS 集成工具包
- AxioWorks SQList
这篇关于SQL 服务器连接到 SharePoint 服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！