SQL 服务器连接到 SharePoint 服务器

2021-12-23 00:00:00 etl sharepoint sql-server sharepoint-2013 ssis

我希望将 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

相关文章