Generic connectivity is to access non-oracle database data stores

Q.  Generic connectivity is to access non-oracle database data stores as long as the non-oracle database system supports the ODBC or OLE DB protocols.

- Published on 19 Oct 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - In addition to Oracle Transparent Gateways for various non-Oracle database systems, there is a set of agents that comprise the Oracle Generic Connectivity feature.

    - These agents contain only generic code and the customer is responsible for providing the necessary drivers.

    - Oracle has Generic Connectivity agents for ODBC and OLE DB that enable you to use ODBC and OLE DB drivers to access non-Oracle systems that have an ODBC or an OLE DB interface.

    - To access a specific non-Oracle system using Generic Connectivity agents, you must configure an ODBC or OLE DB driver to the non-Oracle system.

    - These drivers are not provided by Oracle. However, as long as Oracle supports the ODBC and OLE DB protocols, you can use the Generic Connectivity feature to access any non-Oracle system that can be accessed using an ODBC or OLE DB driver.

    - Generic Connectivity agents have some limitations. Connections to a Generic Connectivity agent are supported only for the local Oracle database server.

    - Functionality of these agents, especially when compared to the Oracle Transparent Gateways, is limited.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)