Thread: [ODBC] information request on postgresql --> oracle connect via odbc
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
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
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