Re: Create a DBLink from PostrgeSQL 9.2 to Oracle 11g

On Tue, Apr 9, 2013 at 11:07 AM, kiran <kiran(dot)peddireddy(at)cmegroup(dot)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