问题描述
当我们要查询本地数据库时,我们安装了MS Integration Runtime,只需执行几个步骤,便可以将数据从本地移动到云中.
When we wanted to query the on-premise database, we installed MS Integration Runtime and with few steps, we were able to move data from on-premise to the cloud.
但是,我们希望从云上对本地数据库调用过程或执行一些CRUD操作.如何才能做到这一点 ?有什么办法可以使用类似于Microsoft Integration Runtime的东西吗?
However, we would like to call procedures or do some CRUD operations over the on-premise database from the cloud. How can this be done ? Is there any way to use something similar to Microsoft Integration Runtime ?
我们无法修改数据库所在的防火墙或路由器设置.
We are not able to modify the firewall or router settings where the database is located.
谢谢.
Roberto E.
Roberto E.
推荐答案
https://docs.microsoft.com/zh-cn/azure/data-factory/transform-data-using-stored-procedure
https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
这篇关于与Microsoft Integration Runtime相似地公开本地数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!