When having some on-premises data sources that one wants to access from Azure, is the "best practice" to create a data gateway, or is this becoming an outdated approach? I ask because I notice it relies on the "Gateway Cloud Service" which as I understand it is on its way out.
有一些想要从Azure访问的本地数据源,是创建数据网关的“最佳实践”,还是这种方法变得过时了?我问,因为我注意到它依赖于“网关云服务”,据我所知,它正在逐步推出。
The actual requirement for me is only to be able to do a query from a functions app to the on-premises sql server. I'm not even sure this is possible through the data gateway.
对我的实际要求只是能够从功能应用程序到本地sql server进行查询。我甚至不确定通过数据网关是否可行。
Any and all feedback appreciated.
任何和所有反馈都赞赏。
1 个解决方案
#1
1
Take a look at hybrid connections: https://docs.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections
看一下混合连接:https://docs.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections
They are designed for what you want to do:
它们专为您想要做的事情而设计:
Basically, a tunnel is created between the SQL endpoint in your on-premise environment and a target endpoint for your Azure Function in the Azure environment. It uses HTTPS traffic, so it is easy on the on-premise firewall. To create the SQL endpoint, you'll need to install an agent called the 'Hybrid Connection Manager', which will act as a proxy between the Azure endpoint and the SQL server.
基本上,在内部部署环境中的SQL端点与Azure环境中Azure功能的目标端点之间创建隧道。它使用HTTPS流量,因此在内部部署防火墙上很容易。要创建SQL端点,您需要安装一个名为“混合连接管理器”的代理,该代理将充当Azure端点和SQL服务器之间的代理。
After the endpoints are established, you can connect to the Azure endpoint with your function, and it will be tunneled to the on-premise SQL (using the HCM).
建立端点后,您可以使用您的函数连接到Azure端点,它将通过隧道连接到本地SQL(使用HCM)。
Bear in mind that this will only work with SQL accounts, not with AD accounts. Also, the Azure Function must be hosted by a dedicated App Service Plan, not the consumption plan (alas).
请记住,这只适用于SQL帐户,而不适用于AD帐户。此外,Azure功能必须由专用的应用服务计划托管,而不是消费计划(唉)。
#1
1
Take a look at hybrid connections: https://docs.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections
看一下混合连接:https://docs.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections
They are designed for what you want to do:
它们专为您想要做的事情而设计:
Basically, a tunnel is created between the SQL endpoint in your on-premise environment and a target endpoint for your Azure Function in the Azure environment. It uses HTTPS traffic, so it is easy on the on-premise firewall. To create the SQL endpoint, you'll need to install an agent called the 'Hybrid Connection Manager', which will act as a proxy between the Azure endpoint and the SQL server.
基本上,在内部部署环境中的SQL端点与Azure环境中Azure功能的目标端点之间创建隧道。它使用HTTPS流量,因此在内部部署防火墙上很容易。要创建SQL端点,您需要安装一个名为“混合连接管理器”的代理,该代理将充当Azure端点和SQL服务器之间的代理。
After the endpoints are established, you can connect to the Azure endpoint with your function, and it will be tunneled to the on-premise SQL (using the HCM).
建立端点后,您可以使用您的函数连接到Azure端点,它将通过隧道连接到本地SQL(使用HCM)。
Bear in mind that this will only work with SQL accounts, not with AD accounts. Also, the Azure Function must be hosted by a dedicated App Service Plan, not the consumption plan (alas).
请记住,这只适用于SQL帐户,而不适用于AD帐户。此外,Azure功能必须由专用的应用服务计划托管,而不是消费计划(唉)。