Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Transparent Gateways
I running an Oracle DB on HP UX,
Oracle gateway on NT
connecting to MS-SQL 6.5 server.
Although Oracle names the Gateway as "transparent" (implying that it's transparent to the Oracle sql/procedures, etc,) it's not.
Commits / rollbacks are not under Oracle's control (duh!)
The gateway uses an ODBC connection. So, anything you could do with say, MS-Access (via odbc) you can do with your oracle connection. (You can't use triggers, for example, but you can execute stored procedures)
You create a database link to the tables on the SQL server via the gateway.
As with any odbc connection, it is very slow. It works, but performance is so incredibly bad, to do a complex join over the gateway.
We use the gateway simply as the "interface" to the SQL db. We use record posting date/timestamps to determine which SQL records have been posting since our last "pull"; we "manually" replicate SQL tables on the Oracle side, THEN process the records.
Watch out for treatment of INTs (numbers), varchars (CHARS), etc.
Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message
news:383180F2.BE0474F_at_Unforgettable.com...
> 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?
Received on Tue Nov 16 1999 - 13:57:30 CST