Solved: Data Gateway - Oracle setup

Anonymous · ‎11-20-2018

We need to setup a Gateway Cluster and include a data source that has both SQL (2016) and Oracle (12c) servers. What all needs to be setup, most importantly for oracle? Do I need to install the oracle (which bit?) client on the Gateway server? Are there any special configurations?

Anonymous · ‎11-20-2018

SQL didn't cause us any headaches but Oracle did.

Firstly we installed the Orcale Client onto the server with the gateway installed, which was easy enough. We also needed to install ODAC onto the gateway server. I believe it was the x64 version.

After that was complete we had to update the TNSNAMES.ORA file with all the connection details. We found that in the Oracle\product\<version number>\client_1_x64\network\admin\ folder. Yours might be a little different but see if you can locate the network\admin\ folder at least.

View solution in original post

Anonymous · ‎11-20-2018

SQL didn't cause us any headaches but Oracle did.

Firstly we installed the Orcale Client onto the server with the gateway installed, which was easy enough. We also needed to install ODAC onto the gateway server. I believe it was the x64 version.

After that was complete we had to update the TNSNAMES.ORA file with all the connection details. We found that in the Oracle\product\<version number>\client_1_x64\network\admin\ folder. Yours might be a little different but see if you can locate the network\admin\ folder at least.