In order to successfully change the schema password, you must change it in several places. The first area in which you must change the schema password is in the data sources defined in the application server. This password is not encrypted as the application server protects it. Both
username
and
password
are stored in the
cmxserver.properties
file, and the password must be entered in encrypted form.
The parameters are stored in
cmxserver.properties
as:
[databaseId].username=username
[databaseId].password=encryptedPassword
In addition to the data sources on the application server, Informatica requires the password to be encrypted and stored in various tables.