Connect Logic App with On-Prim Sql Server

Overview:

This article gives you an overview of how to connect your azure cloud services with on premise resources

On prem gateway act as a bridge between your on-premise data resource and your Azure cloud services

How it works:

· Azure Gateway use Azure service bus as an intermediate between cloud services and on prem gateway service

· Azure Gateway sends query to service bus

· On-Prem gateway service polls for service bus for all request

· On-Prem gateway fetch and execute query.

· On-prem gateway sends result back to service Bus

Limitation :

There are some limitation of SQL connector in Logic app

· The response size limit is 8MB through on-premises SQL server.

· The request size limit is 2MB through on-premises SQL server.

· SQL native query is not supported for on-premises SQL server.

· It only support 100 calls in 10 secs

https://docs.microsoft.com/en-us/connectors/sql/

Install On-Prem Gateway

Create Gateway on Azure

Create new table in on-prem database

Create logic app to connect with on-prem SQL Server

Http Action Setting : Use Fake API

SQL Connector on-prem Setting:

Specify parameter from Json Parsor to Table columns

Verify after execute the logic app