Обсуждение: 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
You can try http://oracle-fdw.projects.postgresql.org/
On Wed, Apr 10, 2013 at 12: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.
--
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general