Have a TOS job that was created in one environment (staging) with db parameters set (hard coded) to map to the staging database. Same with the file structure. It refers to metadata on the staging environment.
We now have to migrate these jobs to the production environment in such a way that the connections should reflect the target environment (production in this case), without changing the settings every time the changes to the job are moved from staging to production.
Any reference to literature or past threads are welcome.
@amruni2017,you were using openstudio right? how are you moving the jobs from environments? is it using a Build job then you need to create different context groups for different environments. and then in .sh or .bat file you changes context file,which you want to use in the corresponding environment.
please check the below link how to use context groups.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.