Modify component in multiple Jobs

[Anonymous]

Hello, 

I have a Talend project with multiple Jobs. In all of them, I am calling a PostgreSQL database. I have to switch to another type of SQL database and would like to know if there is a way to change these connections in a way where I don't have to go one by one for all the Jobs. At least, if there is a way to know which Jobs are interacting with the PostgreSQL database. Cheers!

[Anonymous · Accepted solution]

Hi
From a global perspective, you should define a context group in repository and define variables for the DB parameters, use these variables in the jobs, so that you just need to update the variable one time in one place if DB connectivity information changes.
For now, you have to check the job one by one and update them.

Regards
Shong