From: Chris Travers <chris@travelamericas.com>
To: Alfredo Rico <alfredorico@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Integration PostgreSQL with Oracle.
Date: Thu, 20 Oct 2005 11:43:41 -0700
Message-ID: <4357E55D.1080200@travelamericas.com> (raw)
In-Reply-To: <89cc056d0510201045n230e5912wcf7b840807e46564@mail.gmail.com>
References: <89cc056d0510201045n230e5912wcf7b840807e46564@mail.gmail.com>
Alfredo Rico wrote:
> Hi friends, greetings :-)
> Please apologize by my bad english, I speak sapnish.
>
> This question that I'll do could be a little difficult because I'm
> award that it should be very especific, although I'm looking for a
> first guide or directive in ordert to solve this dilemma.
>
> I'm developing a Java-Web Software using PostgreSQL for a company in
> which I work.
>
> One of the requirements is, using whatever mechanism (external to my
> Java-Web develop) to establish an
> interaction/integration/communication from my PostgreSQL database
> toward an Oracle Database already existents and in a production state
> inside the company,
Look into DBI-Link by David Fetter. It requires Perl, DBI, DBD::Oracle
to make it work. That would give you real-time communication between
PostgreSQL and Oracle...
Another option would be to write a simple Perl client, using the NOTIFY
framework, etc. to create a replication solution.
Does that make sense?
Best Wishes,
Chris Travers
Metatron Technology Consulting
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: chris@travelamericas.com, alfredorico@gmail.com
Subject: Re: Integration PostgreSQL with Oracle.
In-Reply-To: <4357E55D.1080200@travelamericas.com>
References: <89cc056d0510201045n230e5912wcf7b840807e46564@mail.gmail.com> <4357E55D.1080200@travelamericas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox