X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1779BD9B02 for ; Thu, 20 Oct 2005 15:43:44 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75518-07 for ; Thu, 20 Oct 2005 18:43:41 +0000 (GMT) Received: from mail.travelamericas.com (unknown [206.130.134.147]) by svr1.postgresql.org (Postfix) with SMTP id 9AF83D904F for ; Thu, 20 Oct 2005 15:43:41 -0300 (ADT) Received: (qmail 4144 invoked from network); 20 Oct 2005 18:43:42 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 20 Oct 2005 18:43:42 -0000 Message-ID: <4357E55D.1080200@travelamericas.com> Date: Thu, 20 Oct 2005 11:43:41 -0700 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alfredo Rico Cc: pgsql-admin@postgresql.org Subject: Re: Integration PostgreSQL with Oracle. References: <89cc056d0510201045n230e5912wcf7b840807e46564@mail.gmail.com> In-Reply-To: <89cc056d0510201045n230e5912wcf7b840807e46564@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.045 required=5 tests=[AWL=-0.005, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/234 X-Sequence-Number: 19306 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