How to connect Azure SQL database from on-premise SSMS in hybrid environment without Azure Data Gateway
<p>I am trying to connect to Azure SQL database through on-premise SSMS and SSIS (its a requirement to push data on premise to Azure cloud). But my organization's firewall is blocking the connection to Azure database, although the Azure subscription is with same org. I tried pulling data with Azure Data Factory but it requires installation of Data Gateway and firewall is also blocking installation/registration of this gateway. Is there any alternate way to bypass this. Raising firewall exception for Data Gateway is not an option in this case. Thanks </p>