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.

How can Oracle interoperate with a non-Oracle database?

April 26, 2017database interoperate non-Oracle Oracle

0

Posted

How can Oracle interoperate with a non-Oracle database?

1 Answer

0

Posted

Oracle provides two connectivity solutions to address the needs of disparate data access: Oracle Transparent Gateways and Oracle Generic Connectivity. Oracle Transparent Gateways provides access to many non-Oracle data stores, including Microsoft SQL Server, Informix, Ingres, and Sybase from an Oracle environment. Oracle Generic Connectivity provides access to many data stores for which Oracle does not have a gateway solution. This feature enables transparent connectivity using ODBC and OLE DB.