| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Transparent Gateways
Kenneth C Stahl wrote:
>
> Connor McDonald wrote:
> >
> > Kenneth C Stahl wrote:
> > >
> > > Could someone provide a brief description of what a transparent gateway
> > > provides?
> > >
> > > Is there a transparent gateway that will run on a Unixware platform to
> > > access a Sql Server 6.5 database running on an NT server?
> >
> > The theory is that you just run your normal standard Oracle SQL against
> > the remote source (via a dblink) and the gateway "magically" converts
> > into the SQL that the other vendor db will understand...
> >
> > I've used the Oracle => DB2 one before and it does work albeit a little
> > slowly...Similarly, sometimes joins across the nodes caused a few
> > dramas, but on the whole, it was fine.
> >
>
> Can you run procedures which are stored in the remote database?
Depends on what you mean by 'remote'...
Our setup had what they call the 'integrating' server... an instance of Oracle running on the same platform as the non-oracle db...
In our case, we had Oracle on Sun talking to Oracle on IBM Mainframe which then spoke to DB2 (on the same mainframe)
The advantage of this was that any "busy" interaction between Oracle and DB2 was done across memory on the m/frame rather than across the network..We could run procedures on the mainframe Oracle instance with no problems...We did not attempt to use any of the stored procedure-ish functionality offered by DB2...
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 17 1999 - 03:26:43 CST
 |
 |