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?

Forteen 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?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads