Horton

Thread

  1. Is there any way to invoke Java API from PostgreSQL

    aditya desai <admad123@gmail.com> — 2021-08-13T04:27:57Z

    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.

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

    Erik Brandsberg <erik@heimdalldata.com> — 2021-08-13T04:32:04Z

    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
[image: AWS Competency Program]
<https://aws.amazon.com/partners/find/partnerdetails/?n=Heimdall%20Data&id=001E000001d9pndIAA>

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

    aditya desai <admad123@gmail.com> — 2021-08-13T04:42:48Z

    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
> [image: AWS Competency Program]
> <https://aws.amazon.com/partners/find/partnerdetails/?n=Heimdall%20Data&id=001E000001d9pndIAA>
>

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

    Erik Brandsberg <erik@heimdalldata.com> — 2021-08-13T04:54:46Z

    If the issue is about managed Azure PG replication and regions, you may
want to setup a bastion PG host that you manage in the same region that is
used to act as a coordination point.  Just an idea.  In general, I think
this list is about PG specific issues, not about how to work around cloud
specific implementations of security measures that may impact global
implementations.  The same issues could apply for MySQL replication as
well.  PG does have Java api integration, but cloud providers limit what
can be done on their own implementations for security reasons.  These
aren't PG issues, they are provider issues.

On Fri, Aug 13, 2021 at 12:43 AM 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.
>
> 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
>> [image: AWS Competency Program]
>> <https://aws.amazon.com/partners/find/partnerdetails/?n=Heimdall%20Data&id=001E000001d9pndIAA>
>>
>

-- 
*Erik Brandsberg*
erik@heimdalldata.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>

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

    Steve Midgley <science@misuse.org> — 2021-08-13T16:39:51Z

    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.
>
> 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.
>>>
>>>
>>>
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?

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

    aditya desai <admad123@gmail.com> — 2021-08-18T10:18:57Z

    Thanks Steve!! All of the below are supported for DB Links.
Postgres VM - Oracle 12 c
Postgres VM - Azure Postgres
Azure Postgres - Azure Postgres
Oracle - Postgres VM
Oracle - Azure Postgres

Stuck with anything that is outgoing from Azure Postgres. Will check
Bastion Host or try pg_dump/restore.

Regards,
Aditya.


On Fri, Aug 13, 2021 at 10:10 PM Steve Midgley <science@misuse.org> wrote:

>
>
> 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.
>>
>> 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.
>>>>
>>>>
>>>>
> 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?
>