ETL Job to read Server/database details from File and execute

[ShastriV]

Hi,

I need help to set context variables(database details) reading from a File for multiple database and execute the job.

Is there a way  to create a job which executes in all the databases without us manually giving database details in context variables and update target tables? I have multiple databases, I want job to execute for each database(reading these from a file one after the other). I have seen ini file but how should I read each section, set context variables  and execute job?

[vapukov]

until schemas the same, yes you can read database details from file and iterate over each row

similar question and solutions with - https://community.talend.com/t5/Design-and-Development/Reading-param-context-from-an-excel-sheet/m-p...

[ShastriV]

Thanks for your reply.

Instead of reading row by row say, I want to read each section(every section has 5 Parameters) ,store it as context variables and iterate. How would be the approach?