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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
jay_t0
Contributor II
Contributor II

Mass update context variable value for all tasks?

Team uses context variables in all Tasks.
After publishing to cloud, certain variables must be overridden with specific values. Thats 's how it is. 🙂

How to update one common context variable (e.g. gv_HOST_NAME) value on all task in TMC?
We have nearly thousand tasks using same variable and the value has to be changed with a different host.
Any suggestion to bulk/mass update all jobs quickly will help!

Labels (2)
1 Reply
gvarun_arthasolutions
Partner - Contributor III
Partner - Contributor III

Hello,

Context Group

If gv_HOST_NAME is part of a Repository-stored Context Group and all your tasks utilize this group, updating the variable within the Context Group in Talend Studio and then republishing the affected Jobs will propagate the change to all tasks in TMC that use those, Jobs.

Bulk Update via TMC API
• TMC exposes REST APIs for managing tasks and context variables.
• You can script against the API (Python, PowerShell, etc.) to:
o Fetch all tasks
o Identify those with gv_HOST_NAME
o Update the variable value in bulk
• This avoids manual UI work and gives you repeatability.

Thanks