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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.