Postgres Pro
Downloads
Home   >   mailing lists

Re: oracle db reads from postgresql - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: oracle db reads from postgresql
Date
Msg-id CAGDYbUMW_BWLyQfgYs7MEW1Ki8W4B2hWZaRtwj-Qafk-=uSj=A@mail.gmail.com
Whole thread Raw
In response to oracle db reads from postgresql  (Ray Stell <stellr@vt.edu>)
Responses Re: [MASSMAIL]Re: oracle db reads from postgresql
List pgsql-admin
Tree view
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.

http://agapoff.name/oracle-postgresql-links.html

https://www.toadworld.com/platforms/oracle/b/weblog/archive/2015/02/23/connecting-oracle-to-postgresql-using-oracle-gateways

Hope this will help.

--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com

pgsql-admin by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: [TIPS] Tuning PostgreSQL 9.2
Next
From: Pierre Chevalier Géologue
Date:
Subject: Re: Extracting data into .csv format