[ODBC] information request on postgresql --> oracle connect via odbc

Started by Glauco Mancinialmost 20 years ago3 messagesgeneral

mancini@tiscali.com

almost 20 years ago

Hi all,

i'm looking for a method to connect natively a postgresql db to oracle (
maybe via odbc ? ) with something similar to the oracle dblink.

I connected successfully a oracle instance to a postgresql instance
using unix-odbc, now i need to proceed on the other way.

Can you please help me with some suggestion ?

Thanks for your attention, best regards

Glauco Mancini

Ragnar

gnari@hive.is

almost 20 years ago

In reply to: Glauco Mancini (#1)

Re: [ODBC] information request on postgresql --> oracle

On mï¿½n, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote:

i'm looking for a method to connect natively a postgresql db to oracle
( maybe via odbc ? ) with something similar to the oracle dblink.

I connected successfully a oracle instance to a postgresql instance
using unix-odbc, now i need to proceed on the other way.

Can you please help me with some suggestion ?

maybe plperlu and DBD::Oracle ?

gnari

Tino Wildenhain

tino@wildenhain.de

almost 20 years ago

In reply to: Ragnar (#2)

Re: [ODBC] information request on postgresql --> oracle

Ragnar schrieb:

On mï¿½n, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote:

i'm looking for a method to connect natively a postgresql db to oracle
( maybe via odbc ? ) with something similar to the oracle dblink.

I connected successfully a oracle instance to a postgresql instance
using unix-odbc, now i need to proceed on the other way.

Can you please help me with some suggestion ?

maybe plperlu and DBD::Oracle ?

Or easier: http://pgfoundry.org/projects/dbi-link/

Which uses that approach imho.

Regards
Tino