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

SAS DI Libname issue: not able to register oracle table

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

SAS DI Libname issue: not able to register oracle table

[ Edited ]

Dear All,

 

I created libraries in SMC and registered tables from oracle, but i am not able to register some tables which are present into oracle from SAS DI.

at the time of register for tables in SAS DI its showing for AUTHDOMAIN username and password not assigned

Please help.

 

i have SAS personal login manager, is there anything which i need to do in it?

Thanks


Accepted Solutions
Solution
‎03-08-2017 08:16 AM
Trusted Advisor
Posts: 1,312

Re: SAS DI Libname issue: not able to register oracle table

Hello @sas_pkc1,

 

they problem I expect is that your user is not in the group that contains the user to connect to your Oracle database. Once you are in, disconnect from DI, connect again and try again.

 

You can read the following SAS post, I think it can be useful to you:

http://blogs.sas.com/content/sasdummy/2010/11/23/five-strategies-to-eliminate-passwords-from-your-sa...

View solution in original post


All Replies
Solution
‎03-08-2017 08:16 AM
Trusted Advisor
Posts: 1,312

Re: SAS DI Libname issue: not able to register oracle table

Hello @sas_pkc1,

 

they problem I expect is that your user is not in the group that contains the user to connect to your Oracle database. Once you are in, disconnect from DI, connect again and try again.

 

You can read the following SAS post, I think it can be useful to you:

http://blogs.sas.com/content/sasdummy/2010/11/23/five-strategies-to-eliminate-passwords-from-your-sa...

Occasional Contributor
Posts: 11

Re: SAS DI Libname issue: not able to register oracle table

Posted in reply to JuanS_OCS

Dear juan S_OCS,

 

 

Trusted Advisor
Posts: 1,312

Re: SAS DI Libname issue: not able to register oracle table

@sas_pkc1, glad that it helped a bit and you got it working.

 

Community Manager
Posts: 564

Re: SAS DI Libname issue: not able to register oracle table

Hi sas_pkc1,

 

I'm glad you found some useful info! If Juan's reply was the exact solution to your problem, can you "Accept it as a solution"? Or if it was helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.

Thanks!
Anna

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 256 views
  • 2 likes
  • 3 in conversation