SEO

#1 (**permalink**) 04-09-2008, 09:58 AM

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

#2 (**permalink**) 04-09-2008, 09:58 AM

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#3 (**permalink**) 04-09-2008, 09:58 AM

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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