topic How to substitute the pass through comand for libname in Administration and Deployment

How to substitute the pass through comand for libname

marcosemeao — Fri, 23 Nov 2018 18:29:21 GMT

People,

How to substitute the pass through comand for libname

connect to oracle as myconn (user=smith password=secret
path='myoracleserver');

for libname sintax

Re: How to substitute the pass through comand for libname

r_behata — Fri, 23 Nov 2018 19:11:28 GMT

PROC SQL;    
  CONNECT TO ORACLE (user=user password="password" path=schema);
  CREATE TABLE LIBRARY.tab_nm AS
   SELECT *       
      FROM CONNECTION TO ORACLE          
       (
           <Your ORACLE SQL query here>
     	);
  DISCONNECT
  FROM ORACLE; 
 QUIT;

Re: How to substitute the pass through comand for libname

Reeza — Fri, 23 Nov 2018 19:22:55 GMT

It's stage 1 & 2 here:
https://documentation.sas.com/?docsetId=bidsag&docsetTarget=p1t9q2knb9tq5ln101dkrdsa9ymf.htm&docsetVersion=9.4&locale=en

Yes, this is for data integration studio, but the idea is the same for a desktop here. Set up the ODBC connection (or whatever connection in user dsn) and then use a libname statement.

libname name8cha odbc schema="dbo" noprompt="server=XXXXXXX,YYYY;DRIVER=SQL Server;Trusted_Connection=yes;database=dbname";

That's an example of my connection string.

Re: How to substitute the pass through comand for libname

marcosemeao — Fri, 23 Nov 2018 19:26:49 GMT

thanks r_behata!

But I cant show my user and password at code.

I need to have a way that my user and password can't be seen by other users that can access my program.sas or log.

Regards

Re: How to substitute the pass through comand for libname

Kurt_Bremser — Fri, 23 Nov 2018 19:55:31 GMT

Then you have to make sure that only those with need-to-know have access to those files.

Re: How to substitute the pass through comand for libname

r_behata — Fri, 23 Nov 2018 19:58:28 GMT

Encoding the Password is one option.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002595992.htm

Re: How to substitute the pass through comand for libname

AndreasWindisch — Mon, 26 Nov 2018 07:24:43 GMT

Hey,

if you use a environment with a Metadata Server (normally BI Server) you could use a Authentication Domain (libname option 'authdomain='). You will have to setup the library in the Metadata Server first, but that are a few steps.

This paper will give you a short overview (it is some days older, but the steps are the same until now).
http://support.sas.com/techsup/technote/ts771.pdf

Best regards,
Andreas

Re: How to substitute the pass through comand for libname

marcosemeao — Tue, 27 Nov 2018 11:59:12 GMT

I'm sorry for the delay in replying

My client uses connection in SQL.

CONNECT TO ODBC AS SQLCON
(DSN = BW_PROD USER = SRV_SASLayout PWD = "XXXXXXX%" READ_ISOLATION_LEVEL = 'RU');

Thanks for the tips and I'm reviewing what you have sent

I'll test the alternatives.

thankful