Re: [MASSMAIL]Re: oracle db reads from postgresql

From: "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
To: "Shreeyansh Dba" <shreeyansh2014(at)gmail(dot)com>
Cc: "Ray Stell" <stellr(at)vt(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [MASSMAIL]Re: oracle db reads from postgresql
Date: 2016-02-18 14:08:02
Message-ID: 47091.192.168.207.54.1455804482.squirrel@webmail.etecsa.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> 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?

Use HS module in Oracle, but is better to join Postgres to Oracle to
otherwise.

--
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yogi Barot 2016-02-18 14:14:06 Postgresql 9.5 error
Previous Message Pierre Chevalier Géologue 2016-02-18 10:49:19 Re: Extracting data into .csv format