Loop through Different databases and load data into tables

[desanip]

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.

[vapukov]

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