[resolved] Change database Input/Output components globally

One Star

[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
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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

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

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

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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog