Five Stars

how to update parameters in config file of job

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. 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator

Re: how to update parameters in config file of job

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Ten Stars

Re: how to update parameters in config file of job

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.

Francois Denis

Don't forget to tag when it's "solved"!

2 REPLIES
Moderator

Re: how to update parameters in config file of job

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Ten Stars

Re: how to update parameters in config file of job

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.

Francois Denis

Don't forget to tag when it's "solved"!