pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alfredo Rico <alfredorico@gmail.com>
To: Goulet, Dick <DGoulet@vicr.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Integration PostgreSQL with Oracle.
Date: Thu, 20 Oct 2005 14:34:49 -0400
Message-ID: <89cc056d0510201134r7b46ce02ga390e5f42e8b16c1@mail.gmail.com> (raw)
In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502E097CD@25exch1.vicorpower.vicr.com>
References: <4001DEAF7DF9BD498B58B45051FBEA6502E097CD@25exch1.vicorpower.vicr.com>

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 <DGoulet@vicr.com> 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 an
> 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 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,
>
> 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 some
> direction on that matter?
>
> Beforehand thank you very much by your help and support.
>
> Kind Regars.
> Alfredo Rico.-
>
>

view thread (5+ messages)  latest in thread

Message-ID: <89cc056d0510201134r7b46ce02ga390e5f42e8b16c1@mail.gmail.com>
Permalink:  ../89cc056d0510201134r7b46ce02ga390e5f42e8b16c1@mail.gmail.com/
Also on:    postgresql.org/message-id/89cc056d0510201134r7b46ce02ga390e5f42e8b16c1@mail.gmail.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: alfredorico@gmail.com, DGoulet@vicr.com
  Subject: Re: Integration PostgreSQL with Oracle.
  In-Reply-To: <89cc056d0510201134r7b46ce02ga390e5f42e8b16c1@mail.gmail.com>
  References: <4001DEAF7DF9BD498B58B45051FBEA6502E097CD@25exch1.vicorpower.vicr.com> <89cc056d0510201134r7b46ce02ga390e5f42e8b16c1@mail.gmail.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