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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Subbiah, Nagarajan Sent: Thursday, September 29, 2005 10:39 AM To: 'oracle-l_at_freelists.org'
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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 29 2005 - 12:29:20 CDT