Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between accessing a data source using Generic Connectivity or an Oracle Transparent Gateway?

April 26, 2017connectivity Data difference Gateway generic Oracle source transparent

0

Posted

What is the difference between accessing a data source using Generic Connectivity or an Oracle Transparent Gateway?

1 Answer

0

Posted

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.