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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.