共享点联机连接到SQL Server的前提 [英] Sharepoint online connection to SQL Server on premise

问题描述

我需要将本地SQL Server数据库连接到共享点在线列表...我需要在共享点站点上显示数据.

I need to connect my on premise SQL Server Database to sharepoint online lists... I need to display data on sharepoint sites.

我已经通过SharePoint Designer中的外部内容类型连接到数据库.虽然我可以看到表格和列，视图等.但是我无法在线在共享点上呈现数据.

I have connected to the data base through the external content types in SharePoint Designer. Though I can see the tables and columns, views etc..I am not able to render data on sharepoint online.

请帮助，因为我能够将Power Bi网关用于Power Bi解决方案.

Please help as I am able to use the Power Bi gateway for Power Bi solutions.

也应该没有用于共享点的网关吗?

Shouldn't there be a gateway for sharepoint also ?

推荐答案

就像拥有PowerBI网关-在Premise上访问一样，您可以使用oData Service并创建BCS连接以在On Premise中从SharePoint Online连接到SQL Server.与Power BI Gateway不同，您可以使用Out在盒子里，你会 必须自己创建oData服务和BCS连接.以下参考资料中给出了详细的解释:

Just like you have a gateway for PowerBI - On Premise access, you can make use of oData Service and create a BCS connection to connect from SharePoint Online to SQL Server in On Premise.Unlike the Power BI Gateway which you can use Out of the box, you will have to create a oData Service and BCS connection on you own.  A detailed explanation is given in the below references :

-  混合BCS体系结构简介–第1部分

-  创建oData源

-  外部内容类型配置

-  连接到本地服务

此致

Priyan

这篇关于共享点联机连接到SQL Server的前提的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！