Generic connectivity enables to connect to non-oracle database data stores

Q.  Which of the agent is used so that the Generic connectivity enables you to connect to a non-oracle database data stores?
- Published on 03 Aug 15

a. A Heterogeneous Services ODBC agent
b. A Heterogeneous Services OLEDB agent
c. Both A & B
d. None of the above

ANSWER: Both A & B


  • Nirja Shah   -Posted on 21 Sep 15
    - Generic Connectivity is implemented as one of the following types of Heterogeneous Services agents:

    1. ODBC agent for accessing ODBC data providers
    2. OLE DB agent for accessing OLE DB data providers that support SQL processing--sometimes referred to as OLE DB (SQL)
    3. OLE DB agent for accessing OLE DB data providers without SQL processing support--sometimes referred to as OLE DB (FS)

    - Each user session receives its own dedicated agent process spawned by the first use in that user session of the database link to the non-Oracle system.

    - The agent process ends when the user session ends.

    - Generic Connectivity Architecture
    - To access the non-Oracle data store using Generic Connectivity, the agents work with an ODBC or OLE DB driver.
    - The Oracle database server provides support for the ODBC or OLE DB driver interface.
    - The driver that you use must be on the same platform as the agent.
    - The non-Oracle data stores can reside on the same machine as the Oracle database server or on a different machine.

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.)