topic Re: connecting several database using tFileInputProperties in Talend in Talend Studio

connecting several database using tFileInputProperties in Talend

Anonymous — Sat, 16 Nov 2024 08:47:56 GMT

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

Database Name
Server Name
Host Name
Password
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?

manodwhb — Mon, 29 Jan 2018 10:35:38 GMT

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

Anonymous — Mon, 29 Jan 2018 10:45:36 GMT

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

manodwhb — Mon, 29 Jan 2018 11:15:22 GMT

I have showned inthis example,please find.

manodwhb — Thu, 01 Feb 2018 07:20:38 GMT

is your issue fixed?

Anonymous — Thu, 01 Feb 2018 17:02:41 GMT

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.

manodwhb — Fri, 02 Feb 2018 04:47:00 GMT

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