Procedure
-
Add the following components by typing the component names on the design
workspace or dropping them from the Palette:
-
a tMysqlConnection component (displayed as tDBConnection_1), to open a connection to the MySQL database,
-
a tRowGenerator, to generate random input data,
-
a tMysqlOutput component (displayed as tDBOutput_1), to write data to the MySQL database.
-
- Connect the tRowGenerator component to tDBOutput_1 component using a Row > Main connection.
-
Connect the tDBConnection_1
component to the tRowGenerator using a
Trigger > OnSubjobOk connection.