What is the difference between accessing a data source using Generic Connectivity or an Oracle Transparent Gateway?
Oracle8i, Release 3, includes Generic Connectivity for free. Oftentimes, a data source may be accessible either via ODBC or an Oracle Transparent Gateway. On a support level, the difference is that with ODBC the customer must obtain and configure the ODBC driver himself. Oracle guarantees support for the ODBC interface, but any problems related to the ODBC driver, e.g. faulty ODBC driver, misconfiguration issues, non-availability of ODBC driver for a particular version of the data source, must be addressed by the customer. With the Transparent Gateways, Oracle offers end-to-end support for accessing a particular data source. Additionally the performance of an Oracle Transparent Gateway is usually better, since it is specifically designed for a specific source, whereas ODBC provides generic access to that source.