topic SAS ODBC access in Administration and Deployment

SAS ODBC access

Dawn_Wu — Wed, 24 Nov 2021 06:52:35 GMT

Hi All,

I usually access HIVE data via SAS through below ODBC access:

libname rbana odbc user=XXXXXXX password="XXXXXXXX." datasrc=prod schema=my_schema;

(user and password is my staff_id and password.)

This hard coding method disallowed due to some reason.

Any other solutions to connenct to the HIVE data via SAS?

Say connect first, then let me to input my user-id and password?

Thanks & Regards,

Dawn

Re: SAS ODBC access

SASKiwi — Wed, 24 Nov 2021 08:26:25 GMT

Please post the SAS log containing your LIBNAME statement and any following messages.

Re: SAS ODBC access

gwootton — Wed, 24 Nov 2021 13:39:36 GMT

If the issue is with hard-coding your credentials you can store them in Metadata and then use the AUTHDOMAIN option instead of specifying a user name and password in the code.