Re: oracle db reads from postgresql

On Wed, Feb 17, 2016 at 8:12 PM, Ray Stell <stellr(at)vt(dot)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(at)postgresql(dot)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