BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Gooty5
Obsidian | Level 7

 

 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

1 ACCEPTED SOLUTION

Accepted Solutions
VincentRejany
SAS Employee

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

View solution in original post

2 REPLIES 2
VincentRejany
SAS Employee

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

Gooty5
Obsidian | Level 7
Hi Vincent - By using command "dfdbconf", able to resolve the issue.

Thank You
Muralidhar Gooty

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 2 replies
  • 1275 views
  • 0 likes
  • 2 in conversation