topic Re: DATAFlux 2.7 Oracle Direct Connection error in SAS Data Management

DATAFlux 2.7 Oracle Direct Connection error

SalmanSohail — Wed, 16 May 2018 10:28:38 GMT

Hello Everyone,

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.

Re: DATAFlux 2.7 Oracle Direct Connection error

LouGalway_sas — Wed, 16 May 2018 12:05:03 GMT

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:

http://go.documentation.sas.com/?docsetId=acreldb&docsetTarget=p1qft7bzdij79zn1bxh59mc3w8xj.htm&docsetVersion=9.4&locale=en#n0t5gnj4qn51s3n16w7cismv9qcc

If you trying to connect to Oracle from SAS Data Management Studio (Datafulx) then you can find more information here:

http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_T_DataConnOver.html

Good Luck!

Re: DATAFlux 2.7 Oracle Direct Connection error

SalmanSohail — Wed, 16 May 2018 13:28:49 GMT

The last five lines showing lots of (") open and close apostrophes, is that required?

"      (SID=alien)
       "   )
       " )
       " ";

Re: DATAFlux 2.7 Oracle Direct Connection error

LouGalway_sas — Wed, 16 May 2018 14:37:16 GMT

Yes, according to the documentation.