Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
satyavar
Contributor III
Contributor III

[resolved] Configuring job to run on different environments

Hi
I have developed around 60 jobs which are all pointing to my DEV environment. The Input and Output components are using Property Type as "Repository".
Now, I would like to execute all these jobs in STAGING and PRODUCTION environments? Please help me to understand on how can i make the same job pointing to different environment database connections depending on situation. How to configure metadatas?
Best regards,
Kalyan
Labels (2)
18 Replies
satyavar
Contributor III
Contributor III
Author

No i did not plan to switch, I thought when my job runs on STAGING - it picks from STAGING contexts so on...
Anonymous
Not applicable

Ideally, you should prepare your job with contexts, & have it deployed in any environment like that.
Now, at runtime, the actual variable values should be furnished via a config file. As a result, there will be 3 diff config files (with persons with appropriate clearances having access to these files, including passwords)
so, 1 job + 3 config files, should solve your problem. 0683p000009MACn.png
Let me know if this helps.
MathurM
satyavar
Contributor III
Contributor III
Author

Yes i understand that there will be one config file each per environment. But how do i store the passwords in the file? Because i see that TALEND stores them in an encrypted format.
Anonymous
Not applicable

Hi Kalyan,
Ideally, the server creds are fed into the config file by respective teams, already (& specifically) privy to the info.
Even if YOU are required to provide the passwords for all of the environment, you can simply type them in the config file (no need to encrypt it) & the Talend job will read it. BTW, the 'encryption' which you are talking about is not actually encryption. Its a setting, which only hides the passwords (& not actually encrypt it)
Anyways, you would not want to store environment passwords in your job, instead for them to be furnished to the job at runtime (from different sources would be even better) 0683p000009MA9p.png
MathurM
satyavar
Contributor III
Contributor III
Author

Hi
I am reading the values from a csv file and loading the context variables. When i am trying to override the context variable values set by metadata, they are not reacting. Please see the attached screenshot. The password is set to TALEND_2 in Load_Context_Variables job and when it comes to tJavaRow - It is set back to TALEND_1 because of ds_last_load_id object.
Any idea on how can i stop overriding the context variables and only let the values passed from csv?
Thanks
Kalyan
0683p000009MB2W.png
Anonymous
Not applicable

hi,
but there's any csv file to tContextLoad in your screenShoot (after tprejob)
https://help.talend.com/search/all?query=tContextLoad


regards
laurent

satyavar
Contributor III
Contributor III
Author

Hi
Load_CONTEXT_Variables job in the screenshot is reading the values from a csv file. Its a separate job, which i am planning to apply to all the jobs.
Thanks
Kalyan
Anonymous
Not applicable

I am reading the values from a csv file and loading the context variables

but you're not 0683p000009MACn.png
tFileinputDelimited component to tContextLoad is missing.
regards
satyavar
Contributor III
Contributor III
Author

Please see the below screen shot, I am reading the values from csv and using tContextLoad.
0683p000009MBZO.png