Send data privately using on prem data gateway

Dhruv Dalsania 21 Reputation points
2022-11-14T12:48:00.2+00:00

I am working on a logic app for my client ,
I am stuck into an issue where I have standard logic app and i want to access the on prem oracle database .
so one solution is that we install on prem data gateway but we need to allow internet or whitelist some urls for that ,
but my client don't want to do that.We have site to site setup as well . so is there any way we can privately send data to logic app using site to site vpn tunnel.also if you have another approach to do this thing.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,112 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
331 questions
0 comments No comments
{count} votes

Accepted answer
  1. MayankBargali-MSFT 54,456 Reputation points
    2022-11-15T06:51:02.623+00:00

    @Dhruv Dalsania Thanks for reaching out. Unfortunately, standard logic app will also not help in your case as the communication over private endpoint only works with the built-in connectors in standard logic app and not with azure connectors. As there is no built-in connector for Oracle so you cannot communicate it over private endpoint.

    As you are using a consumption logic app you need to use the azure connector with OPDG having internet access.

    For OPDG to work you should have the internet on the machine where you are installing the OPDG as mentioned in the Related considerations here. The OPDG machine can be the same or a different machine on the same network as documented here in FAQ.

    For more details you can refer to this article on Connecting to Oracle Database from PowerApps, Flow and Logic Apps

    Install the gateway on a local computer that's on a wired network, connected to the internet.


1 additional answer

Sort by: Most helpful
  1. sreejukg 10,461 Reputation points
    2022-11-14T13:31:28.747+00:00

    Set up a private endpoint for the logic apps. With a private endpoint, your logic app will be accessible with a private IP address. Once you have the private end point, then you will be able to access your onpremise oracle database through private IP address using Site to Site VPN

    Refer: https://learn.microsoft.com/en-us/azure/logic-apps/secure-single-tenant-workflow-virtual-network-private-endpoint

    https://learn.microsoft.com/en-us/azure/app-service/overview-vnet-integration

    Hope this helps