SAS ODBC access

[Dawn_Wu]

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

[SASKiwi]

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

[gwootton]

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.