Re: Is there any way to invoke Java API from PostgreSQL - Mailing list pgsql-sql

From aditya desai
Subject Re: Is there any way to invoke Java API from PostgreSQL
Date
Msg-id CAN0SRDHeFGESEvOLDJ+4dc2ck3rpp3qRUWu59Axxr4hSaAW1rQ@mail.gmail.com
Whole thread Raw
In response to Re: Is there any way to invoke Java API from PostgreSQL  (Erik Brandsberg <erik@heimdalldata.com>)
Responses Re: Is there any way to invoke Java API from PostgreSQL
Re: Is there any way to invoke Java API from PostgreSQL
List pgsql-sql
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.

Regards,
Aditya.

On Fri, Aug 13, 2021 at 10:02 AM Erik Brandsberg <erik@heimdalldata.com> wrote:
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.


Regards,
Aditya.


--
Erik Brandsberg
erik@heimdalldata.com

www.heimdalldata.com
+1 (866) 433-2824 x 700
AWS Competency Program

pgsql-sql by date:

Previous
From: Erik Brandsberg
Date:
Subject: Re: Is there any way to invoke Java API from PostgreSQL
Next
From: Erik Brandsberg
Date:
Subject: Re: Is there any way to invoke Java API from PostgreSQL