Batch update of SAS Metadata user ID's

[YvanHelie]

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!

[MarcoGhiglieri]

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

[carl_sommer · Accepted solution]

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 a... 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

[YvanHelie]

Hi Carl,

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


Thx.