The gateway can be installed on the machine running the non-Oracle system, the machine running the Oracle database or on a third machine as a standalone. The non-Oracle system can run on the same machine as the Oracle server or on a different machine.
The driver must be installed on the same machine as the gateway. Any ODBC-compatible data source can be accessed using the gateway and the appropriate ODBC driver. The gateway works with an ODBC driver to access non-Oracle systems or other, remote Oracle servers. If your data is stored in a non-Oracle database system or cloud application, and you need to access it from an Oracle Database server, you can create a database link to an Oracle Database Gateway for ODBC. This article explains how to configure Oracle Database Gateway for ODBC. Configuring Oracle Database Gateway for ODBC
