Обсуждение: 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.-
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.-
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.
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.-
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
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.
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.-
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.
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.-