On Thu, Aug 12, 2021 at 9:43 PM aditya desai <admad123@gmail.com> wrote:
Hi Erik,
Sincere apologies. Maybe I wasn't clear. We need to transfer data between Azure PostgreSQL to On Prem Open Source PostgreSQL and Azure PostgreSQL to on Prem Oracle. Azure PostgreSQL is not allowing outgoing traffic through DB Links outside the same region. That's where we are looking for API-like solutions.
Honestly, what you are saying is that you aren't allowed to use a firecracker due to fire concerns, but is there a way to use dynamite instead. If fdw isn't allowed, then callouts to other language environments shouldn't be allowed either.
On Fri, Aug 13, 2021 at 12:28 AM aditya desai <admad123@gmail.com> wrote:
Hi,
Is there any way to invoke Java API from PostgreSQL? We need to transfer data between PostgreSQL and Oracle and oracle_fdw is not allowed due to security concerns in the environment. Also one of PostgresQL in Azure PostgreSQL and others are open source on prem.
Why not use PG replicate to a server that you do control (that might be Erik's "bastion" suggestion), or pg_dump/restore to a similar server, and then execute the business logic and ETL over to Oracle from there?