Change DB Component from PostGreSQL to Aurora

Five Stars

Change DB Component from PostGreSQL to Aurora

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.

Fifteen Stars TRF
Fifteen Stars

Re: Change DB Component from PostGreSQL to Aurora

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.

TRF
Highlighted
Five Stars

Re: Change DB Component from PostGreSQL to Aurora

Thank you! So I thought too.

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

Re: Change DB Component from PostGreSQL to Aurora

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! 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now