Create a DBLink from PostrgeSQL 9.2 to Oracle 11g

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

You can try http://oracle-fdw.projects.postgresql.org/

On Wed, Apr 10, 2013 at 12:07 AM, kiran <kiran.peddireddy@cmegroup.com>wrote: