与Microsoft Integration Runtime相似地公开本地数据库 [英] Expose on-premise database similar as with Microsoft Integration Runtime

问题描述

当我们要查询本地数据库时，我们安装了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.

推荐答案

您可以尝试使用存储过程"活动在本地数据库上调用一些SP，这是文件:

You can have a try with Stored Procedure activity to call some SP over the on-prem database, here is the document:

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相似地公开本地数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！