Connect On-Premise Database with Azure Web App

To connect Azure Web App with On-Premise Oracle DB without public IP expose, we are going to use Azure VNET Integration.

How it works?

• Integrate your app with an Azure Virtual Network

  : On-Premise Database already connected with Azure VNET with S2S VPN. So, we will going to connect Azure Web App to Azure VNET by using P2S VPN, then it will route to On-Premise DB.

Requirements

• One VNet and a branch office (BGP)

  : Between On-Premise DB and Azure VNET, BGP should be setup to communicate.

Our Approach

[Done]

1. Setup P2S VPN at Azure VPN gateway.
2. Integrate VPN between Azure VNET and Azure Web App.
3. Check if On-Premise machine support BGP
4. Setup Azure VPN gateway to use BGP for routing and get ASN & address pool.

[To Do]

5. Setup On-Premise machine to use BGP and connect on-Premise machine and Azure VNET

   • LINK: https://docs.microsoft.com/ko-kr/azure/vpn-gateway/vpn-gateway-bgp-resource-manager-ps

6. Add address pool to Azure Web App

   • LINK: https://blogs.msdn.microsoft.com/waws/2017/07/20/add-routes-to-an-azure-web-app-integrated-with-a-vnet/

7. Ping test at Azure web app to On-Premise DB

8. To get data, query to Database from Node