Re: oracle db reads from postgresql

From: Scott Whitney <scott(at)journyx(dot)com>
To: Ray Stell <stellr(at)vt(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: oracle db reads from postgresql
Date: 2016-02-17 14:53:00
Message-ID: BY1PR11MB0390B2C0483CFFE11826F163A7AE0@BY1PR11MB0390.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)postgresql(dot)org <pgsql-admin-owner(at)postgresql(dot)org> on behalf of Ray Stell <stellr(at)vt(dot)edu>
Sent: Wednesday, February 17, 2016 8:42 AM
To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrea Suisani 2016-02-17 14:59:56 Re: oracle db reads from postgresql
Previous Message Ray Stell 2016-02-17 14:42:10 oracle db reads from postgresql