Automating updating Connection / Login password

Discussion created by JohnO'Mullane on Oct 2, 2015
Latest reply on Oct 13, 2015 by Jennifer_Jinhong_34
We now have up to 50 objects, be they Connection or Login objects which contain database / user passwords.
Every 6 months we are forced by SOX requirement to change these passwords.

Is there any way to automated this by maybe using an  external script(parameterised), that would pull the password from somewhere(possible a database table) and pass the passwords into the relevant objects within Automic?