RE: Oracle Transparent Gateway

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: