In the following procedure all the files have a database connection section in them. The database name, server name, user name, and password can all be changed in them.
The specifics for the database user name and password are outlined below.
First go to this link: https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/administrating/database-maintenance/move-the-sa-store-to-a-remote-database-server.html
Now all the files in this link need to be updated with just the new user name information. The passwords in these files will be update later in the steps below.
Once the above is done go to this link: https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/administrating/customization-and-maintenance/installation-maintenance/password-maintenance.html
There are two sections in here, one to change Catalyst and one to change SOI.
In the 'Change the SA Store Connection Password in all CA Catalyst Files' section while updating the password in these files change the user name also.
In the 'Change the SA Store Connection Password in all CA SOI Files' you will run the utility to change the password for SOI. The user info in these files was updated by the first link sent so just the password will need to be updated here.
To update user/password for Jaspersoft you need to do the following:
1. Log into Jaspersoft.
2. Click View, Repository and expand root, Public, ca, Service Operations Insight folder.
3. Click the datasources folder, and edit the 'soi ds' datasource.
3. Update the datasource 'User Name' and 'Password' fields and click Test Connection.
4. Click Save after the successful connection.