连接SharePoint Online和SQL数据库 [英] Connect SharePoint Online and SQL Database

问题描述

我有一个将sharepoint连接到sql数据库的要求。

我想创建一个aspx表单它有多个字段。它应该可以在Sharepoint中访问。当我填写表格并提交数据时，它应保存在SQl表中。它还应保存在两个不同的表中。

For例如：考虑表单有两个部分第1部分和第2部分

当我提交第1部分时应该保存到表1中，第2部分应该保存到SQL中的表2中。基本上我应该执行从sharepoint在线表单到SQL表的CRUD操作。有没有办法使用CSOM，JSOM或任何其他方法来执行此操作。

我有 如果它是onpremises，我们可以创建服务器端代码和webpart来实现这一点。怀疑关于sharepoint在线吗？

请帮助提供一些建议和示例。

谢谢&问候，

Poovi

解决方案

我们可以使用Business Connectivity Services（BCS）连接SharePoint Online和SQL Server。以下文章供您参考：

https://blog.kloud.com.au/2017/11/13/connect-sharepoint -online-and-sql-server-on-premises-with-bcs-sharepoint-apps-using-hybrid-connection-and-wcf-services /

https：//开头social.technet.microsoft.com/wiki/contents/articles/28286.office-365-sharepoint-online-bcs-with-azure-sql-server-database.aspx

<另一种方法，我们也可以使用SharePoint列表来存储表单提交的数据，然后使用CSOM创建一个Windows任务调度程序，以从SharePoint列表中获取数据并插入到SQL服务器表中。

最诚挚的问候，

丹尼斯

Hi,

I have a requirement which connects sharepoint to sql database.

I want to create a aspx form which will have multiple fields in it.It should be accessible in Sharepoint.When i fill the form and submit the data it should save in SQl tables.Also it should save in two different tables.

For ex:Consider the form is having two sections Section1 and Section 2

When i submit section 1 should be saved into table 1 and section 2 should be saved into table 2 in SQL.Basically i should perform CRUD operation from sharepoint online form to SQL tables.Is there a way to do this using CSOM,JSOM or any other method.

I have  a doubt like if it is onpremises we can create server side code and webpart to achieve this.What about for sharepoint online?

Please help with some suggestions and examples.

Thanks & Regards,

Poovi

解决方案

Hi,

We can connect SharePoint Online and SQL server using Business Connectivity Services (BCS). The following articles for your reference:

https://blog.kloud.com.au/2017/11/13/connect-sharepoint-online-and-sql-server-on-premises-with-bcs-sharepoint-apps-using-hybrid-connection-and-wcf-services/

https://social.technet.microsoft.com/wiki/contents/articles/28286.office-365-sharepoint-online-bcs-with-azure-sql-server-database.aspx

Another way, we can also use SharePoint list to store the data from the form submit, then create a windows task scheduler with CSOM to get the data from SharePoint list and insert into SQL server tables.

Best Regards,

Dennis

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