how to update parameters in config file of job

[amtkmr1990]

Hi, 

I am using talend Open Source Data Integration tool which has a job. This job has a component MSSQLinput which contains DEV DB connection details. Once my work is done i push the workspace to git.

Then QA team download the workspace and import it. They open the job and changes the MSSQLinput component DB details to QA DB. 

      1. Instead of every time importing it and changing the component details, IS there a way where QA team can only change the job xml file and change the DB                    connection details using notepad.  

      2. Where is the config file of the job so QA team can change the DB connection only for that MSSQLinput component. 

[Anonymous · Accepted solution]

Hello,

You can use a tcontextload component in your job which loads a context from a flow.

Here is a scenario in this component reference:TallendHelpCenter:Reading data from different MySQL databases using dynamically loaded connection pa...,

Please have a look at it to see if it is what you are looking for.

Best regards

Sabrina

[fdenis]

Just start by using context (without tContextLoad)
on metadata, when building your connection save it as context.
in this context add qa context.
then when qa run your jab they just have to ru it with qa context.

when your ok with this process then use TloadContex to load local context. dev for you and qa for qa.