Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mGIfF-00040j-3n for pgsql-sql@arkaria.postgresql.org; Wed, 18 Aug 2021 10:19:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mGIfE-0006bd-2r for pgsql-sql@arkaria.postgresql.org; Wed, 18 Aug 2021 10:19:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mGIfD-0006bV-NW for pgsql-sql@lists.postgresql.org; Wed, 18 Aug 2021 10:19:15 +0000 Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mGIf8-00067l-Ex for pgsql-sql@lists.postgresql.org; Wed, 18 Aug 2021 10:19:14 +0000 Received: by mail-lj1-x22c.google.com with SMTP id w4so2648887ljh.13 for ; Wed, 18 Aug 2021 03:19:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=VtoQr3tPVdsDcrrUHmJsGJ+kAgqM3TXtJfUlZVBsWqE=; b=gDQtUlX4ZzPW/UGIvP+324MGsVKvSKbndGeJ9IEgJ5qdZaJuw/X1Al2Czp0I9ApccG EgFan4JJIk9u+MnpBWLudHsGol5fbmUvBiCUcZ5FvKGwrQ+/PyxqlDq1Ydy57sMzxGEB RZH5E9kY57xLgnvlCtIjn0c1gN7mlCYvnWqDSmkwpd10ytNcY+sDgWy/7cllg4OTdxOP aOdgBkSzr5edwHXk2ZQE3oeB7oEc6OWuYh0L9UAf3g1ti/GDQ35HE+aAHjhzRKuEhWeP gXq9NOm0o461uTPta421m9vn1t9u8e8F5tnp1sBX9O8Nqi3jNzgMaB0SQ82OIPCXIai3 nq7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=VtoQr3tPVdsDcrrUHmJsGJ+kAgqM3TXtJfUlZVBsWqE=; b=QL2dzcK2a3/jirnq8pEmKNCWwAwEge0syYJBQykD0ax1EDD5puHqyugAi8rvUuA1uN D0urBVCnmg2l6nq+XoNo5OHy/2ivCO+ogWYlulrgyqio/Q/x2n5GmfHAveGpsmGl5ghX GphwsmjsdhEQJIFkyjSAdVnhlwgXpo7ZFA3tYVBptk1y8qxpJloHgJVQ0wwyshfUHGpf fuXJKkZKTrkzz0l42KvyeiAMlXx8XcpU9P9po/AqEwE1CNBZ36CKn9IztdGXKWva7Muc YnPXLTYWyaLeGWBoGdXQZPYQ3EiVjpw+8oZg7B1PmBeo4Kc9IY5hsv7+udXWjsdxM2iJ K2cA== X-Gm-Message-State: AOAM532NVRoKXemE00MXMMJ7/Fo2sxuiZsKBFTzl1CGMD/QpQlH4rC73 PGn7H2yT6CA6vSw0S68cHfHaddzpZVV5SEm+GMA= X-Google-Smtp-Source: ABdhPJwuvBcUdWcMWtOLnEBy0aYjdkjeqrooQW5SeqeQg9MsXuBnm2nF76L1rk19yAlBFVLzGOSEF/51ElLqMGL7LgM= X-Received: by 2002:a2e:b615:: with SMTP id r21mr2002016ljn.276.1629281949025; Wed, 18 Aug 2021 03:19:09 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: aditya desai Date: Wed, 18 Aug 2021 15:48:57 +0530 Message-ID: Subject: Re: Is there any way to invoke Java API from PostgreSQL To: Steve Midgley Cc: Erik Brandsberg , pgsql-sql Content-Type: multipart/alternative; boundary="000000000000cf882905c9d2c335" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cf882905c9d2c335 Content-Type: text/plain; charset="UTF-8" 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 wrote: > > > On Thu, Aug 12, 2021 at 9:43 PM aditya desai 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 >> 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 >>> 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? > --000000000000cf882905c9d2c335 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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
<= div>Oracle - Azure Postgres

Stuck with anything th= at 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:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">
Hi Erik,<= div>Sincere apologies. Maybe=C2=A0 I wasn't clear. We need to transfer = data between Azure PostgreSQL to On Prem Open Source PostgreSQL and Azure P= ostgreSQL to on Prem Oracle. Azure PostgreSQL is not allowing outgoing traf= fic through DB Links outside the same region. That's where we are looki= ng for API-like solutions.

Regards,
Adit= ya.

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 us= e a firecracker due to fire concerns, but is there a way to use dynamite in= stead.=C2=A0 If fdw isn't allowed, then callouts to other language envi= ronments shouldn't be allowed either.

On Fri, Aug 13, 2021 at 12:28 AM a= ditya desai <adm= ad123@gmail.com> wrote:
Hi,
Is there any way to invoke Java API= from PostgreSQL? We need to transfer data between PostgreSQL and Oracle an= d oracle_fdw is not allowed due to security concerns in the environment. Al= so 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" suggesti= on), or pg_dump/restore to a similar server, and then execute the business = logic and ETL over to Oracle from there?
--000000000000cf882905c9d2c335--