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

Discussion

• 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