| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | dba(at)ciberforce(dot)net |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: How to connect to an oracle table from Postgres? |
| Date: | 2006-06-06 16:07:17 |
| Message-ID: | 36e682920606060907y46327be9v172229809b1bfe44@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 6/6/06, dba(at)ciberforce(dot)net <dba(at)ciberforce(dot)net> wrote:
> I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same network. Is there a good way to pull this off?
Your only option with native PostgreSQL is to use dbi-link. Not to
explicitly plug EnterpriseDB here, but we have a native OCI-based
connector for PostgreSQL which is quite a bit faster than dbi-link if
speed is what you need.
dbi-link:
http://pgfoundry.org/projects/dbi-link/
EnterpriseDB Release 2 Beta 3:
http://www.enterprisedb.com/products/download.do
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 2nd Floor | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2006-06-06 16:09:09 | Re: oralink documentation |
| Previous Message | kevin | 2006-06-06 15:38:23 | oralink documentation |