SQL Server连接到SharePoint服务器 [英] SQL server connecting to SharePoint server

问题描述

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

• 在SharePoint中使用SSIS OData源连接器在线


• 在SQL Server集成服务中使用OData源


• 使用OData源从SSIS连接到SharePoint

• 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社区

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

• 在SQL Server Integration S中提取和加载SharePoint数据服务

• Extracting and Loading SharePoint Data in SQL Server Integration Services

• 用于Microsoft SharePoint的KingswaySoft SSIS集成工具包


• AxioWorks SQList

• KingswaySoft SSIS Integration Toolkit for Microsoft SharePoint
• AxioWorks SQList

这篇关于SQL Server连接到SharePoint服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！