ARM template for creating API connection to On-Premise SQL

Published Jun 09 2020 08:41 AM 3,594 Views
Senior Member

Scenario:

ARM template definition for creating connection to on-premise SQL server from Logic Apps.

ARM Definition:

This can be tweaked according to how you define parameters in parameters file.

Here the possible authentication modes for SQL are :

Windows authentication: Authtype - Windows

SQL server authentication: Authtype- basic

  {

   "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/{{reosurceGroupName}}/providers/Microsoft.Web/connectionGateways/{{On-Premise DatagatewayName}}"

     }

    }

Version history
Last update:
‎Jun 09 2020 08:41 AM
Updated by: