pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (5+ messages)  latest in thread

Message-ID: <4357E55D.1080200@travelamericas.com>
Permalink:  ../4357E55D.1080200@travelamericas.com/
Also on:    postgresql.org/message-id/4357E55D.1080200@travelamericas.com

 · 

reply

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