How can we define the DB Tool password as an environment variable.As for different environments its different so its hard to change in all DB tools manually?
In general, if you want to reference a system environment variable in some tool field somewhere (DB Tool or otherwise) then you just type something like ${env_var:NameOfSystemEnvironmentVariable} in the field (works for password fields as well).
However, SOAtest also has its own concept of "Environments" where you can also define variables. If you want to use a SOAtest environment variable (as opposed to a System environment variable) then you do something similar, typing a variable reference like ${nameOfPasswordVariable} (without "env_var" prefix) where "nameOfPasswordVariable" is defined an an environment configuration referenced by your test suite. For general information about how to setup and configure environments in SOAtest, please see this: Configuring Testing in Different Environments
Comments
In general, if you want to reference a system environment variable in some tool field somewhere (DB Tool or otherwise) then you just type something like ${env_var:NameOfSystemEnvironmentVariable} in the field (works for password fields as well).
However, SOAtest also has its own concept of "Environments" where you can also define variables. If you want to use a SOAtest environment variable (as opposed to a System environment variable) then you do something similar, typing a variable reference like ${nameOfPasswordVariable} (without "env_var" prefix) where "nameOfPasswordVariable" is defined an an environment configuration referenced by your test suite. For general information about how to setup and configure environments in SOAtest, please see this: Configuring Testing in Different Environments