Обсуждение: Create a DBLink from PostrgeSQL 9.2 to Oracle 11g

Hello,

I am looking for an example on creating a DBLink from PostrgeSQL 9.2 to
Oracle 11g.
I tried the below link and for some reason the ODBC_Link installation is
failing.

FYI.,
http://vibhork.blogspot.com/2011/05/postgresql-database-link-to-oracle.html


I have the Heterogeneous DB Connection Between Oracle And PostgreSQL. I want
the other way, reason being, I have 100's of oracle database and I need to
pull data from these oracle databases and store into PostgreSQL.

I tried many thing and not successful on the creating a DBLink from
PostrgeSQL 9.2 to Oracle 11g.

Any help, highly appreciated.
Waiting for your response.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Create-a-DBLink-from-PostrgeSQL-9-2-to-Oracle-11g-tp5751446.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On Tue, Apr 9, 2013 at 11:07 AM, kiran <kiran.peddireddy@cmegroup.com> wrote:
> Hello,
>
> I am looking for an example on creating a DBLink from PostrgeSQL 9.2 to
> Oracle 11g.
> I tried the below link and for some reason the ODBC_Link installation is
> failing.
>
> FYI.,
> http://vibhork.blogspot.com/2011/05/postgresql-database-link-to-oracle.html
>
>
> I have the Heterogeneous DB Connection Between Oracle And PostgreSQL. I want
> the other way, reason being, I have 100's of oracle database and I need to
> pull data from these oracle databases and store into PostgreSQL.
>
> I tried many thing and not successful on the creating a DBLink from
> PostrgeSQL 9.2 to Oracle 11g.
>
> Any help, highly appreciated.
> Waiting for your response.

if you have any experience with java (and maybe even if you don't),
you might want to check out jdbc-fdw.

https://github.com/atris/JDBC_FDW

merlin