Foreign Data Wrapper for Oracle (Beta) released

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: <pgsql-announce(at)postgresql(dot)org>
Subject: Foreign Data Wrapper for Oracle (Beta) released
Date: 2011-08-26 11:24:38
Message-ID: D960CB61B694CF459DCFB4B0128514C206CEBCD1@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

I announce the first Beta release of oracle_fdw.

Project home page: http://oracle-fdw.projects.postgresql.org/

oracle_fdw is a PostgreSQL extension that provides a Foreign
Data Wrapper for easy and efficient read access to Oracle
databases.

Features:

* Uses the new standard compliant SQL/MED environment of PostgreSQL 9.1
* Supports translation of Oracle data types to similar PostgreSQL data
types
* WHERE conditions are propagated to Oracle where possible
* Only the required Oracle table columns are selected
* EXPLAIN shows the remote query, EXPLAIN VERBOSE the Oracle execution
plan
* Should compile and run on all platforms supported by Oracle Client
and PostgreSQL
* Works with the regular Oracle client and Oracle Instant Client
* Installable with a single CREATE EXTENSION command
* Oracle connections are cached for the duration of the PostgreSQL
session
* Supports Oracle external authentication to avoid storing passwords in
the database
* Uses Oracle prefetching for high performance

Requirements:

* PostgreSQL 9.1 or better
* Oracle client 10.1 or better
* For EXPLAIN VERBOSE, SELECT privileges on V$SQL and V$SQL_PLAN

Enjoy!

Yours,
Laurenz Albe

Browse pgsql-announce by date

  From Date Subject
Next Message Gary Carter 2011-08-26 15:42:53 EnterpriseDB Announces Postgres Plus(R) Cloud Server Beta Program
Previous Message Brian Pottberg 2011-08-23 19:59:05 PG Day 2011 Important Annoncement!