Logic App (Standard) : use of gateway with SQL Server connector ?

Xavier GARONNAT 1 Reputation point
2022-12-07T21:35:18.597+00:00

Hi,

I tried to use SQL Server connector within a Logic App (Standard) and I can't figure how to use an OnPremise Gateway ? I can't find where to specify the gateway.

Thanks,
Xavier.

268362-image.png

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,842 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 68,476 Reputation points
    2022-12-13T03:50:25.963+00:00

    @Xavier GARONNAT Thanks for reaching out. In Standard logic app workflows, built-in connectors that connect to on-premises data sources don't need to use the gateway as documented on the Note section here. So, you don't need OPDG in standard logic app for built-in connectors. Only with Azure connector you will see the option for gateway connection in standard logic app. It looks like you might have selected the Built-in connector rather than Azure connector in your standard logic app.

    269837-image.png

    269759-image.png

    Alternative if you are using build in sql connector then you will not see the gateway option and to connect you need to enable the VNET integration on your logic app with your on-premise resource.