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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

Modern Data Engineering in the Cloud

Learn about modern data engineering in the Cloud

Watch Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog