I have a datawarehouse placed in a MS SQL Server database. I created many jobs in Talend with target tables in this database. There is also many jobs with lookups to these tables.
Now we have to change the database type, the datawarehouse will be migrated from
MS SQL Server
to MySQL.
Is there any chance to fix this somehow without having to open and change hundreds of places where this DB connection is used (both as DBInput, lookup and target) ?
I am new in Talend and I expected that it would be possible just to change the DB connection in the metadata repository and propagate the change to all jobs. Actually it is possible to that, but unfortunately it has no effect, I still have to open all DBInput's and DBOutput's and do the changes manually.
I have found this: https://community.talend.com/s/question/0D53p00007vCn62CAC/tdbconnection-reusing-for-different-database-type
