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 3BE3DDA919 for ; Thu, 20 Oct 2005 17:13:07 -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 05765-07 for ; Thu, 20 Oct 2005 20:13:04 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.198]) by svr1.postgresql.org (Postfix) with ESMTP id 8899BD6F4A for ; Thu, 20 Oct 2005 15:34:48 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id i26so277670wxd for ; Thu, 20 Oct 2005 11:34:49 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=IfZmBCxtLV80U5GmjBaG0kx9jNVVVOsmFMcLf8lTRzyxhFIrAeX4cLJ/ywNxvpObJlUEARYgcQzSGjQBqBRT0Chnawu8J9uXmPvuzpBDezigsS67LqEhOBWd1Q1Fw1RNHmMXdgwg133N78gWSvqJR2jo+AeQGw246X/vhnQuNEI= Received: by 10.70.39.6 with SMTP id m6mr1149158wxm; Thu, 20 Oct 2005 11:34:49 -0700 (PDT) Received: by 10.70.15.7 with HTTP; Thu, 20 Oct 2005 11:34:49 -0700 (PDT) Message-ID: <89cc056d0510201134r7b46ce02ga390e5f42e8b16c1@mail.gmail.com> Date: Thu, 20 Oct 2005 14:34:49 -0400 From: Alfredo Rico To: "Goulet, Dick" Subject: Re: Integration PostgreSQL with Oracle. Cc: pgsql-admin@postgresql.org In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502E097CD@25exch1.vicorpower.vicr.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5277_32898883.1129833289780" References: <4001DEAF7DF9BD498B58B45051FBEA6502E097CD@25exch1.vicorpower.vicr.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.455 required=5 tests=[AWL=0.344, HTML_40_50=0.086, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/235 X-Sequence-Number: 19307 ------=_Part_5277_32898883.1129833289780 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Dick, greetings.. :-) Ok, my application is behind a firewall and inside of the same network in which Oracle database is. Second, this must be so instantaneous. Could you tell me more about an additional Java procedure to handle Oracle?? Thanks a lot in advanced... Kind Regards.- Alfredo Rico. On 10/20/05, Goulet, Dick wrote: > > Alfredo, > Well if you'll pardon my total lack of Spanish, I'll definitely pardon > your English. > First question though, what is the architecture being implemented here? > Are we talking about in Intranet application where your Java & the > Postgresql db are outside of the firewall. If that is the case some other > actions may be necessary. > Second how fast does this have to happen? If it's instantaneous, then a= n > additional Java procedure to handle Oracle would probably be the fastest.= If > it can delay a bit there are other methods that would work. > > ------------------------------ > *From:* pgsql-admin-owner@postgresql.org [mailto: > pgsql-admin-owner@postgresql.org] *On Behalf Of *Alfredo Rico > *Sent:* Thursday, October 20, 2005 1:46 PM > *To:* pgsql-admin@postgresql.org > *Subject:* [ADMIN] Integration PostgreSQL with Oracle. > > 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 whic= h > I work. > > One of the requirements is, using whatever mechanism (external to my > Java-Web develop) to establish an interaction/integration/communication f= rom > my PostgreSQL database toward an Oracle Database already existents and in= a > production state inside the company, > > I have heard about using XML in ordert to carry out Data Bases > integrations (from diferents manufacturers ) and even I have heard about > using Web Services (SOAP) but I don't sure. > > Some of you has faced some similar situation? Could you suggest to me som= e > direction on that matter? > > Beforehand thank you very much by your help and support. > > Kind Regars. > Alfredo Rico.- > > ------=_Part_5277_32898883.1129833289780 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Dick, greetings.. :-)

Ok, my application is behind a firewall and inside of the same network in w= hich Oracle database is.

Second, this must be so instantaneous. Could you tell me more about an addi= tional Java procedure to handle Oracle??

Thanks a lot in advanced...

Kind Regards.-
Alfredo Rico.

On 10/20/05, Goulet, Dick <DGoulet@vicr.com> wrote:
Alfredo,
 
    Well if you'll pardon my total lack of Span= ish,=20 I'll definitely pardon your English.
 
    First question though, what is the architec= ture=20 being implemented here?  Are we talking about in Intranet application = where=20 your Java & the Postgresql db are outside of the firewall.  If tha= t is=20 the case some other actions may be necessary.
 
    Second how fast does this have to happen?&n= bsp;=20 If it's instantaneous, then an additional Java procedure to handle Oracle w= ould=20 probably be the fastest.  If it can delay a bit there are other method= s=20 that would work.
 

Hi friends, greetings :-)
Please apologize by my bad english,= I=20 speak sapnish.

This question that I'll do could be a little difficul= t=20 because I'm award that it should be very especific, although I'm looking fo= r a=20 first guide or directive in ordert to solve this dilemma.

I'm develo= ping=20 a Java-Web Software using PostgreSQL for a company in which I work.

= One=20 of the requirements is, using whatever mechanism (external to my Java-Web= =20 develop) to establish an interaction/integration/communication from my=20 PostgreSQL database toward an Oracle Database already existents and in a=20 production state inside the company,

I have heard about using XML i= n=20 ordert to carry out Data Bases integrations (from diferents manufacturers )= and=20 even I have heard about using Web Services (SOAP) but I don't sure.

= Some=20 of you has faced some similar situation? Could you suggest to me some direc= tion=20 on that matter?

Beforehand thank you very much by your help and=20 support.

Kind Regars.
Alfredo Rico.-


------=_Part_5277_32898883.1129833289780--