RE: Oracle Transparent Gateway
- From: "Pass, Stephanie" <Stephanie_Pass@xxxxxxxxxxxxxxxxx>
- To: <Nagarajan.Subbiah@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 11:26:39 -0600
Why not use a db-link in oracle, OLEDB or ODBC connectivity and a linked server
on the sql server side? Will be a lot cheaper than trying to use OTG.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Subbiah, Nagarajan
Sent: Thursday, September 29, 2005 10:39 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Oracle Transparent Gateway
Hi,
Is the Oracle Transparent Gateway a licensable product? We have a requirement
to access the SQL Server from the Oracle using the DB link or Synonyms of the
SQL Server object in the Oracle using the dblink.
In the Heterogeneous connectivity document, it says either you could use the
Generic connectivity or the Transparent Gateway. The transparent gateway can
use the SQL Server database as a another Oracle database so we could use the
Database link. How about the Generic connectivity? I wasn't clear that the
Generic connectivity has the same feature of using the db link. Also, Does
Oracle support the SQL Server connectivity from the Unix (HP-UX)?
Thanks,
Raja
Other related posts:
