Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, with my team we just installed Talend Remote Engine on CentOS7, so far so good. However we have the doubt of how to change the context variables within the remote engine in such a way to incorporate other database credentials.
any help is welcome
thank you very much
Hi
Sorry, I don't understand on change the context variable within the remote engine. As far as I know, we can load the value of context variable at runtime during the job execution or assign the new value through TMC before run the task.
Regards
Shong
Hi Shong, thanks for your reply, I will try to explain my idea a bit more:
We have all our servers running on Google Cloud, when the devs try to connect to a database they simply use "localhost:1433" via IAP (which is a google cloud proxy for secure remote access).
Now my main goal here is to automatically replace the "localhost" with the internal ip address of the database when the job runs inside the remote engine (for both test and production environments).
As far as I know, we can create multiple values for a variable, however, developers are not allowed to know the QA and production credentials, so I'm looking for a way to hide those values
was reading this article: https://www.talend.com/blog/2019/03/13/best-practices-for-using-context-variables-with-talend-part-4/ btw
thanks
You handle the replacement of context values within the TMC. This is done by defining connections that leverage context parameters that start with “connection_”. You can see more details here:
Another option could be to leverage a file or script on the server to provide the parameter values and then with the Talend job read in the parameters and leverage a tContextLoad to populate the context variables.