Procedure
-
From the palette, drag and drop a tPrejob, a
tMysqlConnection, a
tRouteInput, a tMap, a
tLogRow, a tMysqlOuput, a
tPostjob and a tMysqlClose
component onto the design workspace. Link them together with the
Row > Main
connection.
- Link the tPrejob component to the tMysqlConnection component using a Trigger > On Component Ok connection to build the pre-job.
- Link the tRouteInput component to the tMap component using a Row > Main connection.
- Connect the tMap component to the tLogRow component using the Row > New Output (Main) connection and name the output connection as row2.
- Link the tLogRow component to the tMysqlOuput component using a Row > Main connection.
-
Link the tPostjob component to the
tMysqlClose component using a Trigger >
On Component Ok connection to build the post-job.
Warning:
The use of tMysqlClose in the post-job as shown above in the Route-Job example is not valid for Data Service operation Jobs containing tESBProviderRequest, tESBProviderResponse, tESBProviderFault, or tRestRequest components. In these kind of Jobs it is not recommended to use close connection components like tMySQLClose. Because closing datasource connection is implemented directly in the tESBProvider* and tRestRequest components.