Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Change database Input/Output components globally

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
Labels (2)
5 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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