05-16-2018 06:28 AM
When I tried to connect Oracle TSN directly from DataFlux 2,7 Studio. I get errors:
However, if try the same on Toad DATA studio, I can see the Oracle DATAbase Connected.
1. Oracle Connection String on SAS Data studio
libname oralib1 oracle path="(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XYZ.SARIYAGROUP.ORG) (PORT=1521)) (CONNECT_DATA= (SID=HSP)))"
2. I tried second method Oracle Connection String in SAS Data studio
"(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XYZ.SARIYAGROUP.ORG) (PORT=1521)) (CONNECT_DATA= (SID=HSP)))"
Any suggestions are highly appreciated.
05-16-2018 08:05 AM
Your example looks like you are writing a SAS libname statement, but your subject mentions DataFlux.
If you are trying to write a libname statement in SAS Studio make sure you have all the required components of the libname statement. You example seem to be missing the user= and pw= components. Here is an example from the SAS documentation:
This example connects to Oracle without updating the TNSNAMES.ORA file.
libname x oracle user=myusr1 pw=mypwd1 path="(DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP)(HOST=pinkfloyd)(PORT=1521)) ) (CONNECT_DATA= " (SID=alien) " ) " ) " ";
If you would like additional information you can use this link:
If you trying to connect to Oracle from SAS Data Management Studio (Datafulx) then you can find more information here:
Need further help from the community? Please ask a new question.