将数据从SQL Azure导入到Sharepoint在线外部列表中 [英] Import Data from SQL Azure into Sharepoint Online External List

问题描述

你好

我想将数据从SQL Azure导入到SharePoint在线外部列表中，并且只要数据库表中发生更改，该列表就应该始终保持更新.

I want to import Data from SQL Azure into SharePoint online External List, and the list should always stay updated whenever there are changes in database table.

BCS是一种方法，任何人都可以指导另一种方法.

BCS is one approach, Could anyone guide for another approach.

预先感谢.

推荐答案

我建议您使用BCS来实现它.以下文章供您参考:

I suggest you use BCS to achieve it. The following article for your reference:

带有Azure SQL Server数据库的Office 365 SharePoint Online BCS

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

或者我们可以创建一个SharePoint提供程序托管的加载项，并在Azure中访问SQL数据库.

Or we can create a SharePoint provider hosted add-in and access SQL Database in Azure.

在Azure中使用SQL数据库创建提供者托管的SharePoint加载项

http://www.c-sharpcorner.com/uploadfile/a30324/provider-hosted-sharepoint-add-in-with-sql-database-in-azure/

最好的问候，

Dennis

这篇关于将数据从SQL Azure导入到Sharepoint在线外部列表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！