Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-announce by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group