I have a bundle of Talend jobs which use PostGreSQL on AWS RDS as the backend (source / target). There's a quest to move the DB from PostGreSQL to Aurora on AWS.
The straight forward way is to open each job & replace the component. But it would be great if anyone can share an easier way out.
Can there be any changes at the metadata level without opening all the jobs?
Are there any other easy ways to make this change in about 100 jobs?
Please let me know.
Thanks!
Ganesh
P.S: Not sure which Community topic this should have been under, so have it duplicated in How-Tos and Best Practices forum too.
Hi,
Officially the only way is to modify the jobs one by one from the Studio.
However, you can try at your own risk to modify the .item files (an XML representation of the jobs) placed in the project workspace.
Be sure to have a backup first or you risk to definitively corrupt the jobs.
I was not able to get a job to run using the .itm file. It needed lot of changes to be made on "search and replace" & was a risk. One job I tried did not even open up as a job, i ended up corrupting the .itm file. Ultimately, better to go in and do the hard way.
