Updating MAS connection string via sas-admin CLI or sas-bootstrap-config

[bugraduman1]

Hey Everyone,

We need to update our MAS connection string without logging in to environment manager and of course not logging into even server. So I wrote playbook which retrieves password from vault, decode it , changes related uid``s password  in existing connection string. However,  I am having difficulties  to  write this updated string into MAS properties I am using  sas-bootstrap-config kv read command to read the value and tried kv write command to write it back and it appears sas-bootstrap-config kv write command does not work at all cause it does not show any error but also it does not update the value. Does anyone know how to update the value of sas.microanalyticservice.properties connnection string value using sas admin CLI ?  we are using sas viya 3.5 

Thanks in advance

[gwootton]

If the configuration you are trying to change is available in SAS Environment Manager, you should also be able to update it with the sas-admin CLI's configuration plugin. If you were to update the SAS Configuration Server directly through sas-bootstrap-config, your new value would likely be overwritten by the configuration service where the old value is present.

This blog explains how you could pull down a configuration to a file, modify the file, and push it back to the configuration service:
https://blogs.sas.com/content/sgf/2018/06/08/saving-and-reloading-sas-viya-configuration/

I wanted to say all that before addressing the behavior that sas-bootstrap-config did not update a key. For sas-bootstrap-config kv write to work on an existing key, you need to use the --force option. But again in your case you would not want to use sas-bootstrap-config as the parameter is defined through the configuration service, which would overwrite what was written by sas-bootstrap-config.