Logins and Passwords using Context variables

[Anonymous]

We have three processing environments - Dev, Test, Prod.  I have upwards of 25 database dbConnections that I need to define.  I also have the need to either select or update data in my output dbConnections.  To prevent inadvertent changes to data when I really only meant to select from the dbConnection, it appears that I may need 6 context environments, for example Dev Select, Dev Update, ...  Is there a way to better utilize the context functions without creating 6 context environments for every dbConnection?

[Anonymous]

Hi,
Have you already checked TalendHelpCenter:tContextLoad component or  implicit tContextLoad  which can  modify dynamically the values of the active context?
You can get your DB connection parameter variables from a file or table.

Best regards
Sabrina