topic Re: DataFlux Data Management Server Custom connection in SAS Data Management

DataFlux Data Management Server Custom connection

Gooty5 — Wed, 25 Apr 2018 01:38:30 GMT

Hi - I am trying to create DataFlux Data Management Server Custom Connection to access an Oracle Database with a Fully-Specified Connection String with the following information. Am I using the correct information? Please let me know. Really appreciate your help.

Do I need to use DataFlux 64-bit Oracle Wire Protocol or DataFlux 64-bit Oracle as driver, tnsnames.ora as path and Database Schema Name as catalog?

conopts=(driver=<DataFlux 64-bit Oracle Wire Protocol>; uid=user; pwd=passs; path=/opt/sas/thirdparty/oracle/Oracle_FullClient/product/11.2.0/client_1/network/admin/tnsnames.ora; catalog=<Database Schema Name>;)

Thank You

Muralidhar Gooty

Re: DataFlux Data Management Server Custom connection

VincentRejany — Mon, 30 Apr 2018 13:18:05 GMT

HI Muralidhar

If you want to set up a connection to an Oracl instance on DM Server, on windows you should use the ODBC manager and specify your options there. On linux, you should use the command "dfdbconf" and follow the options, mind that you are able to edit these options afterwards in the odbc.ini file.

For both systems, make sure to save your connections, meaning to store (encrypted) user and password.

Hope that makes sense.

Vincent

Re: DataFlux Data Management Server Custom connection

Gooty5 — Mon, 30 Apr 2018 18:38:59 GMT

Hi Vincent - By using command "dfdbconf", able to resolve the issue.

Thank You
Muralidhar Gooty