topic [resolved] Change database Input/Output components globally in Talend Data Catalog

[resolved] Change database Input/Output components globally

Anonymous — Tue, 19 Jul 2016 12:48:40 GMT

Hi
Is there a way to change database components (eg tAS400Input, tAS400Output) to another database (eg MS SQL Server) globally, in 'one click'? I have jobs created for AS400 database, about 300 tables covered and I want to convert components in those jobs to cover MS SQL Server. Can you do this in Talend the way you change a Db Connection that propagates the changes to all jobs?
BR
Marcin

Re: [resolved] Change database Input/Output components globally

Anonymous — Wed, 20 Jul 2016 04:35:26 GMT

Hi,
Could you please take a look at talend context feature to see if it is what you are looking for?
Here is a scenario in component reference tcontextload.
Best regards
Sabrina

Re: [resolved] Change database Input/Output components globally

Anonymous — Wed, 20 Jul 2016 13:33:38 GMT

Thanks for your answer xdshi.
If I understood the documentation for tContextLoad correctly it only changes the parameters of a specific data component eg. host, database library and so on. It does not change a component for example tAS400Input into a component tMSSqlInput. Am I right? Because this is what I'm looking for.
BR
Marcin

Re: [resolved] Change database Input/Output components globally

Anonymous — Thu, 21 Jul 2016 08:42:24 GMT

Hi,

tContextLoad correctly it only changes the parameters of a specific data component eg. host, database library and so on.

tContextLoad can be used to load value of context variable from properties file.

For your requirement, so far there is no such an option that changing database components to another database globally, in 'one click.
Best regards
Sabrina

Re: [resolved] Change database Input/Output components globally

Anonymous — Mon, 25 Jul 2016 14:06:08 GMT

OK, thanks for information.
I managed to replace the AS400 entries directly in the scripts code. Seems it worked fine.

Re: [resolved] Change database Input/Output components globally

Anonymous — Mon, 20 Mar 2017 08:14:31 GMT

Hi Kulmar,
I'm looking for the same. Need to convert the tpostgressql component to tpostgressqlplus component in 40-50 jobs. Can you please help me, how you managed to changed the component in code without talend UI?
Thanks