topic Re: ETL Job to read Server/database details from File and execute in Talend Studio

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

ShastriV — Thu, 10 Jan 2019 21:30:03 GMT

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?

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

vapukov — Fri, 11 Jan 2019 07:08:49 GMT

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

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

ShastriV — Fri, 11 Jan 2019 14:26:47 GMT

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?