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

Highlighted
Five Stars

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

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?

Thirteen Stars

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

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

 

-----------
Five Stars

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

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?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

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