Re: Is there any way to invoke Java API from PostgreSQL

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(at)heimdalldata(dot)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(at)gmail(dot)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(at)heimdalldata(dot)com
>
> www.heimdalldata.com
> +1 (866) 433-2824 x 700
> [image: AWS Competency Program]
> <https://aws.amazon.com/partners/find/partnerdetails/?n=Heimdall%20Data&id=001E000001d9pndIAA>
>