Hi
My work is in the progress of transitioning from SA9.4 on EG to SAS Viya and SAS Studio. In SAS EG, my authentication details for my teradata connection are created in SAS EG Explorer and I can easily connect to the teradata platform and run my code, I'd suspect that SAS EG Explorer adds the credentials to my profile or config in SAS Management Console, however I'm not 100% sure where they are stored. Now when I try to reference the authdomain in code in SAS Studio to connect to Teradata databases I get errors saying that my credentials aren't available. So it seems that SAS Studio isn't able to see the credentials that EG stored. I don't want to hard code my credentials in a SAS program for security reasons. Just wondering if there's a setting somewhere in SAS Studio that I can use to create or reference the authdomain or do I need to speak with the SAS admin?
Our 9.4 system and SMC is locked by the SAS admins so I can't just hop into SMC and add it.
Thanks
Authdomains are typically created via SMC and can be created or changed using the Server Manager or User Manager plugins. If they are being used to authenticate an external database then usually there is a metadata user group created to store the service account being used to access the dsatabase. The service account needs to have the authdomain applied to it. Also you need to be added as a member of the group for the authdomain to work for you.
If you can't check these out yourself then you will need to rely on your SAS administrator.
EDIT: If I'm understanding your post correctly then your question is more about using authdomains in SAS Viya. This is really a job for your SAS administrator but here is a link to how these are set up: https://documentation.sas.com/doc/en/sasadmincdc/v_069/calcredentials/p0c0l75i14ni65n10515di5layj8.h...
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.