connecting several database using tFileInputProperties in Talend

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

Forteen Stars

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.
Four Stars

Re: connecting several database using tFileInputProperties in Talend

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

Forteen Stars

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.
Forteen Stars

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.
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.

Forteen Stars

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.

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads