New News Entry

A new entry has been added to the news database.

Database Admin: http://www.postgresql.org/admin/edit_news.php?184

Submitted by: office(at)cybertec(dot)at
Headline: Oracle and MySQL Connectivity Packs now available
Summary:

Cybertec Geschwinde & Schoenig is glad to announce connectivity packs for MySQL and Oracle databases.
See http://www.cybertec.at/cluster.html for further information.

Story:

Oracle Connectivity Pack
The Oracle Connectivity Pack allows companies to use business logic which has been implemented for Oracle in PostgreSQL databases. In addition to that it is possible to exchange data between Oracle and PostgreSQL with the help of direct database connections.
Remote cursors can be used to fetch huge amounts of data from an Oracle database and to transfer it to Oracle within just one transaction.

MySQL Connectivity Pack
The MySQL Connectivity Pack allows developers to fetch data from remote MySQL databases and to use the results of those queries in local queries. This pack can be used for soft-migration as well as distributed computing (dblink_style connectivity).