Loop through Different databases and load data into tables

desanip — Fri, 03 May 2019 14:39:31 GMT

Hello,

Can someone tell me how i can loop through different databases in MYSQL server and load data into respective tables. All the tables have the same exact structure?

Can someone show me a sample layout?

Thanks in advance.

Re: Loop through Different databases and load data into tables

vapukov — Sun, 05 May 2019 01:33:25 GMT

Hi,

if all tables have the same structure, it is not very complicate

read connection information from anywhere (csv file in example)
Iterate - store row by row to variable
use this variable in the next subjob in tDBConnnection component connected by OnComponentOk trigger
do the rest

tJavaFlex - just a dummy component for split job into 2 separate parts

topic Loop through Different databases and load data into tables in Talend Studio

Loop through Different databases and load data into tables

Re: Loop through Different databases and load data into tables