Dear all:
I am investigating the usage of the Oracle Gateway for ODBC to connect and Oracle 12 R1 on RHEL 6 64-bit to a Azure DB SQL running on the Microsoft Azure Cloud. See a previous post on this at:
Access Azure Data in Oracle
I realize that the Oracle Gateway and ODBC driver does not need to be installed on the Oracle database server, so I can avoid having to deal with a Linux install. So far, so good.
Now what I cannot fully grasp is where the Microsoft ODBC driver must be installed, to translate to ODBC the Microsoft side of the equation.
My initial gut feeling is that I need to install it on the same server where Oracle Gateway for ODBC is installed, but I want to confirm with someone already using this if this is correct.
I assume that anyone also using a non-cloud SQL Server setup is applicable, the only difference is that on that scenario you may have the option to install the Microsoft ODBC driver on the same host where SQL Server is installed, whereas I have no access to that running from Azure.
My final concern is that I need to be able to create a DB link in Oracle pointing to Azure SQL DB and I am unsure if by having all components installed in a dedicated server (Oracle Gateway for ODBC + Microsoft ODBC Driver 17.2) + configuring the SQL*Net properly is all that is required for the CREATE DATABASE LINK command to work and be able to run queries using it from any Oracle Client setup.
Does the SQL*Net require any path references to any of the files above, so that those file require to be on the Linux server and accessible to the user owner of the Oracle Home directory running the instance?
I assume that if I decide to install the Oracle Gateway for ODBC on a dedicated Windows box, that is not running the database, I must install a brand new Oracle Gateway using below document, can anyone confirm?
https://docs.oracle.com/database/121/OTGIW/overview.htm#OTGIW100
Thanks and regards.