pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIs there any way to invoke Java API from PostgreSQL
6+ messages / 3 participants
[nested] [flat]
* Is there any way to invoke Java API from PostgreSQL
@ 2021-08-13 04:27 aditya desai <admad123@gmail.com>
2021-08-13 04:32 ` Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg <erik@heimdalldata.com>
0 siblings, 1 reply; 6+ messages in thread
From: aditya desai @ 2021-08-13 04:27 UTC (permalink / raw)
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Is there any way to invoke Java API from PostgreSQL
2021-08-13 04:27 Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
@ 2021-08-13 04:32 ` Erik Brandsberg <erik@heimdalldata.com>
2021-08-13 04:42 ` Re: Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Erik Brandsberg @ 2021-08-13 04:32 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
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;
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Is there any way to invoke Java API from PostgreSQL
2021-08-13 04:27 Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
2021-08-13 04:32 ` Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg <erik@heimdalldata.com>
@ 2021-08-13 04:42 ` aditya desai <admad123@gmail.com>
2021-08-13 04:54 ` Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg <erik@heimdalldata.com>
2021-08-13 16:39 ` Re: Is there any way to invoke Java API from PostgreSQL Steve Midgley <science@misuse.org>
0 siblings, 2 replies; 6+ messages in thread
From: aditya desai @ 2021-08-13 04:42 UTC (permalink / raw)
To: Erik Brandsberg <erik@heimdalldata.com>; pgsql-sql <pgsql-sql@lists.postgresql.org>
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;
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Is there any way to invoke Java API from PostgreSQL
2021-08-13 04:27 Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
2021-08-13 04:32 ` Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg <erik@heimdalldata.com>
2021-08-13 04:42 ` Re: Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
@ 2021-08-13 04:54 ` Erik Brandsberg <erik@heimdalldata.com>
1 sibling, 0 replies; 6+ messages in thread
From: Erik Brandsberg @ 2021-08-13 04:54 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
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;
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Is there any way to invoke Java API from PostgreSQL
2021-08-13 04:27 Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
2021-08-13 04:32 ` Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg <erik@heimdalldata.com>
2021-08-13 04:42 ` Re: Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
@ 2021-08-13 16:39 ` Steve Midgley <science@misuse.org>
2021-08-18 10:18 ` Re: Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Steve Midgley @ 2021-08-13 16:39 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: Erik Brandsberg <erik@heimdalldata.com>; pgsql-sql <pgsql-sql@lists.postgresql.org>
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?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Is there any way to invoke Java API from PostgreSQL
2021-08-13 04:27 Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
2021-08-13 04:32 ` Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg <erik@heimdalldata.com>
2021-08-13 04:42 ` Re: Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
2021-08-13 16:39 ` Re: Is there any way to invoke Java API from PostgreSQL Steve Midgley <science@misuse.org>
@ 2021-08-18 10:18 ` aditya desai <admad123@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: aditya desai @ 2021-08-18 10:18 UTC (permalink / raw)
To: Steve Midgley <science@misuse.org>; +Cc: Erik Brandsberg <erik@heimdalldata.com>; pgsql-sql <pgsql-sql@lists.postgresql.org>
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?
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-08-18 10:18 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-08-13 04:27 Is there any way to invoke Java API from PostgreSQL aditya desai <admad123@gmail.com>
2021-08-13 04:32 ` Erik Brandsberg <erik@heimdalldata.com>
2021-08-13 04:42 ` aditya desai <admad123@gmail.com>
2021-08-13 04:54 ` Erik Brandsberg <erik@heimdalldata.com>
2021-08-13 16:39 ` Steve Midgley <science@misuse.org>
2021-08-18 10:18 ` aditya desai <admad123@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox