Adding and linking components

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.

Information noteWarning:
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.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!