Обсуждение: oracle db reads from postgresql

Поиск
Список
Период
Сортировка

oracle db reads from postgresql

От
Ray Stell
Дата:
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?


Re: oracle db reads from postgresql

От
Scott Whitney
Дата:
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/


Re: oracle db reads from postgresql

От
Andrea Suisani
Дата:
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/






Re: oracle db reads from postgresql

От
Ray Stell
Дата:
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?


Re: oracle db reads from postgresql

От
Andrea Suisani
Дата:
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.


Re: oracle db reads from postgresql

От
Andrea Suisani
Дата:
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


Re: oracle db reads from postgresql

От
Ray Stell
Дата:
On 2/17/16 9:53 AM, Scott Whitney wrote:
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.


Found these docs on the oracle support web:

How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC 11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1)
Problems Configuring Database Gateway For ODBC (DG4ODBC) to Connect To Postgres (Doc ID 881667.1)

Re: oracle db reads from postgresql

От
Shreeyansh Dba
Дата:
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.



Hope this will help.

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

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

От
"Gilberto Castillo"
Дата:
> 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