topic Re: Change DB Component from PostGreSQL to Aurora in Talend Studio

Change DB Component from PostGreSQL to Aurora

Anonymous — Sat, 16 Nov 2024 08:36:46 GMT

Hello!

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.

Re: Change DB Component from PostGreSQL to Aurora

TRF — Fri, 02 Mar 2018 21:03:28 GMT

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.

Re: Change DB Component from PostGreSQL to Aurora

Anonymous — Sat, 03 Mar 2018 04:13:55 GMT

Thank you! So I thought too.

I'll try changing the .itm file for a couple of jobs & let you know how
it goes.

Re: Change DB Component from PostGreSQL to Aurora

Anonymous — Tue, 26 Feb 2019 18:43:06 GMT

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.

Thanks!