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?
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...
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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema