topic Re: Multiple context groups in a job in Talend Studio

Multiple context groups in a job

Anonymous — Thu, 08 Jun 2017 07:20:24 GMT

I need to use 3 separate DB connections in my job. I do not want to hard code the connection details & hence plan to use the context variables & 3 context groups. How can I ensure that when the same context environment is selected it gets reflected in all context groups?

Re: Multiple context groups in a job

vapukov — Thu, 08 Jun 2017 08:05:15 GMT

Environment affected to all groups and standalone context variables in Job

but You can easy - load values from csv file and do not store nothing in Studio, only variables names

Re: Multiple context groups in a job

Anonymous — Thu, 08 Jun 2017 08:20:09 GMT

Can you plz help how to read from CSV files & then read in my job.

Re: Multiple context groups in a job

TRF — Thu, 08 Jun 2017 08:47:34 GMT

Can you detail your question?

Re: Multiple context groups in a job

Anonymous — Thu, 06 Jul 2017 08:40:44 GMT

Hi,

You can refer to the related scenario "Reading data from different MySQL databases using dynamically loaded connection parameters

" in component reference about: TalendHelpCenter:tContextLoad

or the implicit context feature TalendHelpCenter:Configuring the Implicit Context Load feature.

Best regards

Sabrina

Re: Multiple context groups in a job

rajesh90 — Wed, 19 Jul 2017 17:06:30 GMT

Team, How to implement the same logic for a job already built and exported, in that case the prompt will be coming ? I have a scenario where the source and target path of the job keeps changing based on the environment. So i have that path in a config file like below, which I will change based on the environment. Config File : source;C:/users/temp/ target;C:/users/name/ Now in real time how to use this file to resolve the context variables.

Re: Multiple context groups in a job

TRF — Wed, 19 Jul 2017 20:31:44 GMT

You just have to read the config file with tFileInputDelimited then use a tJavaRow component to set the desired context variables with the field values like this "context.yourVariable = input_row.yourField;".

Hope this helps.