topic Re: Batch update of SAS Metadata user ID's in Administration and Deployment

Batch update of SAS Metadata user ID's

YvanHelie — Thu, 11 Apr 2024 15:40:57 GMT

Hi,

Within a current SAS 9.4 deployment, we want to implement 'Integrated Windows Authentication' (IWA) with Active Directory. The source environment has SAS users created manually, with no User ID's related to Active Directory. Is there a way to import the users and then just run a script to update the User ID's (i.e. JSmith to AD Server\JSmith)?

Thank you!

Re: Batch update of SAS Metadata user ID's

MarcoGhiglieri — Thu, 11 Apr 2024 16:39:59 GMT

Hi!
You can customize this to your needs: SAS Help Center: About the Sample Code for Active Directory

Re: Batch update of SAS Metadata user ID's

carl_sommer — Thu, 11 Apr 2024 18:15:34 GMT

As @MarcoGhiglieri suggested, SAS provides macros and sample code for bulkload and synchronization of users between Active Directory and the SAS Metadata Server.

If you wish instead to have a program you can use to change the userid for the DefaultAuth login account (technically a Login metadata object, see SAS Namespace Types: Login :: SAS(R) 9.4 Metadata Model: Reference for properties and object associations), you could use the code in technical-support-code/usage/administration/sas-metadata-server/replace_metadata_login_case_s9.sas at main · sascommunities/technical-support-code · GitHub as an example. This code changes the case of the userids for Login objects associated with a designated authentication domain. But you could put your own code in place for the manner in which you wish to change the userid.

Carl Sommer - SAS Technical Support

Re: Batch update of SAS Metadata user ID's

YvanHelie — Thu, 11 Apr 2024 18:38:04 GMT

Hi Carl,

replace_metadata_login_case_s9.sas, that's EXACTLY what I was looking for!

Thx.