connecting several database using tFileInputProperties in Talend

Highlighted
Four Stars

connecting several database using tFileInputProperties in Talend

I'm completely new to talend and currently I need to build a job that reads params values like

  1. Database Name
  2. Server Name
  3. Host Name
  4. Password
  5. usernameFrom a property file and passed those values in a tPostgresqlConnection Component.

This is what I have try so far

 

tFileInputProperties -------> tContextLoad ------> tPostgresqlConnection

 

Problem is the job is taking only one database connection instead of looping for all databases connection that I have defined in the file properties.

Can someone advice how i can create a Job that will loop params values on the tPostgresqlConnection component?

 

Job.PNG

Highlighted
Moderator

Re: connecting several database using tFileInputProperties in Talend

use Tflowto iterate between tfileinput and context and iterate and load to table.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Four Stars

Re: connecting several database using tFileInputProperties in Talend

can you please provide more details about your job logic please.

Highlighted
Moderator

Re: connecting several database using tFileInputProperties in Talend

I have showned inthis example,please find.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Moderator

Re: connecting several database using tFileInputProperties in Talend

is your issue fixed?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Four Stars

Re: connecting several database using tFileInputProperties in Talend

Issues not fixed yet. Infact in your job logic I can't understand why you are using tInputFileDelimited and why there's no db connection?

 

I'm looking for a job that will loop on different db as to bring data in a data warehouse and I can't see this on your job.

 

It would be nice if you could provide more info.

Highlighted
Moderator

Re: connecting several database using tFileInputProperties in Talend

in tfileinput, i take the parameters and tried to show there.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARTNER 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

Talend Cloud Developer Series – Updating Context Variables

This video will show you how to add context parameters to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now

Talend Cloud Developer Series – Fetching Studio License

This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License

Watch Now