Обсуждение: 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

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.

> 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