Обсуждение: oracle db reads from postgresql
I've dreaded this task coming my way for years. An Oracle developer wants to read postgresql data from his Oracle db. Is there a current, successful path to making this work or is it fools errand? I find this description: https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ which is 3 yrs old. I see they want me to load an v8 rpm for the odbc driver so I tried to compile the latest and failed out of the gate. Just wondering if anyone has it working or not? Is there a more current howto?
The last time I did this, I started with this: http://docs.oracle.com/cd/E11882_01/gateways.112/e12070/toc.htm and specifically this: http://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10660 and modified appropriately for PG ODBC. ________________________________________ From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of Ray Stell <stellr@vt.edu> Sent: Wednesday, February 17, 2016 8:42 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] oracle db reads from postgresql I've dreaded this task coming my way for years. An Oracle developer wants to read postgresql data from his Oracle db. Is there a current, successful path to making this work or is it fools errand? I find this description: https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ which is 3 yrs old. I see they want me to load an v8 rpm for the odbc driver so I tried to compile the latest and failed out of the gate. Just wondering if anyone has it working or not? Is there a more current howto? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin Journyx, Inc. 7600 Burnet Road #300 Austin, TX 78757 www.journyx.com p 512.834.8888 f 512-834-8858 Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
On 02/17/2016 03:42 PM, Ray Stell wrote: > I've dreaded this task coming my way for years. An Oracle developer wants to read postgresql data from his Oracle db. Is there a current, successful path to making this work or is it fools errand? I find this description: > https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ which is 3 yrs old. I see theywant me to load an v8 rpm for the odbc driver so I tried to compile the latest and failed out of the gate. Just wonderingif anyone has it working or not? Is there a more current > howto? > > if you're using postgresql 9.1+ you could give oracle_fwd a try: http://laurenz.github.io/oracle_fdw/
On 2/17/16 9:59 AM, Andrea Suisani wrote: > if you're using postgresql 9.1+ you could give oracle_fwd a try: Isn't that the opposite direction? Reading oracle from pg?
On 02/17/2016 04:33 PM, Ray Stell wrote: > On 2/17/16 9:59 AM, Andrea Suisani wrote: >> if you're using postgresql 9.1+ you could give oracle_fwd a try: > Isn't that the opposite direction? Reading oracle from pg? > brian fart of mine sorry. scratch that.
On 02/17/2016 04:33 PM, Ray Stell wrote: > On 2/17/16 9:59 AM, Andrea Suisani wrote: >> if you're using postgresql 9.1+ you could give oracle_fwd a try: > Isn't that the opposite direction? Reading oracle from pg? > brian fart of mine sorry. scratch that
On 2/17/16 9:53 AM, Scott Whitney wrote:
Found these docs on the oracle support web:
How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC 11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1)
Problems Configuring Database Gateway For ODBC (DG4ODBC) to Connect To Postgres (Doc ID 881667.1)
The last time I did this, I started with this: http://docs.oracle.com/cd/E11882_01/gateways.112/e12070/toc.htm and specifically this: http://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10660 and modified appropriately for PG ODBC.
Found these docs on the oracle support web:
How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC 11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1)
Problems Configuring Database Gateway For ODBC (DG4ODBC) to Connect To Postgres (Doc ID 881667.1)
On Wed, Feb 17, 2016 at 8:12 PM, Ray Stell <stellr@vt.edu> wrote:
I've dreaded this task coming my way for years. An Oracle developer wants to read postgresql data from his Oracle db. Is there a current, successful path to making this work or is it fools errand? I find this description: https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ which is 3 yrs old. I see they want me to load an v8 rpm for the odbc driver so I tried to compile the latest and failed out of the gate. Just wondering if anyone has it working or not? Is there a more current howto?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi Raymond,
PF following tutorials which worked for me.
Hope this will help.
> On Wed, Feb 17, 2016 at 8:12 PM, Ray Stell <stellr@vt.edu> wrote: > >> I've dreaded this task coming my way for years. An Oracle developer >> wants >> to read postgresql data from his Oracle db. Is there a current, >> successful >> path to making this work or is it fools errand? I find this description: >> https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ >> which is 3 yrs old. I see they want me to load an v8 rpm for the odbc >> driver so I tried to compile the latest and failed out of the gate. >> Just >> wondering if anyone has it working or not? Is there a more current >> howto? Use HS module in Oracle, but is better to join Postgres to Oracle to otherwise. -- Saludos, Gilberto Castillo ETECSA, La Habana, Cuba