pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Integration PostgreSQL with Oracle.
5+ messages / 3 participants
[nested] [flat]

* Integration PostgreSQL with Oracle.
@ 2005-10-20 17:45 Alfredo Rico <alfredorico@gmail.com>
  2005-10-20 18:43 ` Re: Integration PostgreSQL with Oracle. Chris Travers <chris@travelamericas.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Alfredo Rico @ 2005-10-20 17:45 UTC (permalink / raw)
  To: pgsql-admin

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.-

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Integration PostgreSQL with Oracle.
  2005-10-20 17:45 Integration PostgreSQL with Oracle. Alfredo Rico <alfredorico@gmail.com>
@ 2005-10-20 18:43 ` Chris Travers <chris@travelamericas.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Chris Travers @ 2005-10-20 18:43 UTC (permalink / raw)
  To: Alfredo Rico <alfredorico@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Integration PostgreSQL with Oracle.
@ 2005-10-20 18:13 Goulet, Dick <DGoulet@vicr.com>
  2005-10-20 18:34 ` Re: Integration PostgreSQL with Oracle. Alfredo Rico <alfredorico@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Goulet, Dick @ 2005-10-20 18:13 UTC (permalink / raw)
  To: Alfredo Rico <alfredorico@gmail.com>; pgsql-admin

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.-

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Integration PostgreSQL with Oracle.
  2005-10-20 18:13 Re: Integration PostgreSQL with Oracle. Goulet, Dick <DGoulet@vicr.com>
@ 2005-10-20 18:34 ` Alfredo Rico <alfredorico@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Alfredo Rico @ 2005-10-20 18:34 UTC (permalink / raw)
  To: Goulet, Dick <DGoulet@vicr.com>; +Cc: pgsql-admin

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.-
>
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Integration PostgreSQL with Oracle.
@ 2005-10-21 14:17 Goulet, Dick <DGoulet@vicr.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Goulet, Dick @ 2005-10-21 14:17 UTC (permalink / raw)
  To: Alfredo Rico <alfredorico@gmail.com>; +Cc: pgsql-admin

Alfredo,
 
    Well I'm no Java guru by any stretch of the imagination..  One
possibility would be to go to
http://www.oracle.com/technology//index.html.  There's a Java developers
mailing list, similar to this one, that can help you and a discussion
forum.

  _____  

From: Alfredo Rico [mailto:alfredorico@gmail.com] 
Sent: Thursday, October 20, 2005 2:35 PM
To: Goulet, Dick
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Integration PostgreSQL with Oracle.


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.-
	
	

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2005-10-21 14:17 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-20 17:45 Integration PostgreSQL with Oracle. Alfredo Rico <alfredorico@gmail.com>
2005-10-20 18:43 ` Chris Travers <chris@travelamericas.com>
2005-10-20 18:13 Re: Integration PostgreSQL with Oracle. Goulet, Dick <DGoulet@vicr.com>
2005-10-20 18:34 ` Alfredo Rico <alfredorico@gmail.com>
2005-10-21 14:17 Re: Integration PostgreSQL with Oracle. Goulet, Dick <DGoulet@vicr.com>

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