SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DATAFlux 2.7 Oracle Direct Connection error

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

DATAFlux 2.7 Oracle Direct Connection error

SAS_Oracle_Error_1.PNGSAS_Oracle_Error_2.PNGHello 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.


Accepted Solutions
Solution
‎05-16-2018 10:20 AM
New Contributor
Posts: 3

Re: DATAFlux 2.7 Oracle Direct Connection error

Posted in reply to LouGalway_sas

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

 

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

View solution in original post


All Replies
SAS Employee
Posts: 9

Re: DATAFlux 2.7 Oracle Direct Connection error

Posted in reply to SalmanSohail

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&docs...

 

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.ht...

 

Good Luck!

Solution
‎05-16-2018 10:20 AM
New Contributor
Posts: 3

Re: DATAFlux 2.7 Oracle Direct Connection error

Posted in reply to LouGalway_sas

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

 

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

SAS Employee
Posts: 9

Re: DATAFlux 2.7 Oracle Direct Connection error

Posted in reply to SalmanSohail
Yes, according to the documentation.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 150 views
  • 0 likes
  • 2 in conversation