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.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.