azure - 使用本地数据网关的 Sql 连接的 ARM 模板架构
问题描述
我有一个定义 SQL 连接的 ARM(天蓝色资源管理器)模板。SQL 连接需要使用本地数据网关资源。
我的问题:配置 SQL 连接资源以使用本地数据网关资源的资源架构是什么?
这是当前资源 JSON:
{
"type": "Microsoft.Web/connections",
"apiVersion": "2016-06-01",
"name": "sql",
"location": "southcentralus",
"kind": "V1",
"properties": {
"displayName": "OnPremSqlConn",
"parameterValues": {
"server": "XXXXXXXXXX",
"database": "XXXXXXXXXX",
"authType": "windows",
"userName": "XXXXXXXXXX",
"password": "XXXXXXXXXX"
},
"customParameterValues": {},
"api": {
"id": "/subscriptions/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/providers/Microsoft.Web/locations/southcentralus/managedApis/sql"
}
}
}
解决方案
我搜索了“arm template sql connection use gateway”,这是第一个结果。
{
"type": "Microsoft.Web/connections",
"apiVersion": "2018-07-01-preview",
"name": "[parameters('sql_1_Connection_Name')]",
"location": "[parameters('logicAppLocation')]",
"properties": {
"displayName": "[parameters('sql_1_Connection_DisplayName')]",
"customParameterValues": {},
"api": {
"id": "[concat(subscription().id, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'sql')]"
},
"parameterValues": {
"server": "[parameters('sql_1_server')]",
"database": "[parameters('sql_1_database')]",
"username": "[parameters('sql_1_username')]",
"password": "[parameters('sql_1_password')]",
"authType": "basic",
"gateway": {
"id": "/subscriptions/{{subscriptionId}}/resourceGroups/{{resourceGroupName}}/providers/Microsoft.Web/connectionGateways/{{On-Premise DatagatewayName}}"
}
}
相关部分是:
"id": "/subscriptions/{{subscriptionId}}/resourceGroups/{{resourceGroupName}}/providers/Microsoft.Web/connectionGateways/{{On-Premise DatagatewayName}}"
如果您导航到 Azure 门户中的资源,此 ID 也将在 URL 栏中可用,或者您可以针对现有 Azure SQL DB 设置网关,然后使用导出模板功能从该资源获取 ARM 模板。