Skip to main content Skip to complementary content

Defining connection settings

About this task

You can display the properties of a connection by selecting it and clicking the Component view tab, or by right-clicking the connection and selecting Settings from the contextual menu. This section summarizes connection property settings.

Row connection settings

About this task

The Basic settings vertical tab of the Component view of the connection displays the schema of the data flow handled by the connection. You can change the schema by clicking the Edit schema button. For more information, see Setting a built-in schema in a Job.

Basic settings view of the component.

The Advanced settings vertical tab lets you monitor the data flow over the connection in a Job without using a separate tFlowMeter component.

The measured information will be interpreted and displayed in Talend Activity Monitoring Console. For more information, see Introduction to Talend Activity Monitoring Console.

Advanced settings view of the component.

To monitor the data over the connection, perform the following settings in the Advanced settings vertical tab:

Procedure

  1. Select the Monitor this connection check box.
    Note that this option is not supported for Spark Jobs.
  2. From the Mode list, select Absolute to log the actual number of rows passes over the connection, or Relative to log the ratio (%) of the number of rows passed over this connection against a reference connection. If you select Relative, you need to select a reference connection from the Connections List list.
  3. Click the plus button to add a line in the Thresholds table and define a range of the number of rows to be logged.

Iterate connection settings

About this task

When you configure an Iterate connection, you are actually enabling parallel iterations. For further information, see Launching parallel iterations to read data.

Trigger connection settings

OnSubjobOK connection settings

About this task

When working in a remote project, you can define checkpoints on OnSubjobOK trigger connection, so that the execution of your Job can be recovered, in case of Job execution failure, from the last checkpoint previous to the error through the Error Recovery Management page in Talend Administration Center.

Error recovery view of the component.

To define a checkpoint on a subJob trigger connection, perform the following settings in the Error recovery vertical tab of the connection's Component view:

Procedure

  1. Select the Recovery Checkpoint check box.
  2. Enter a name for the checkpoint in the Label field.
  3. Fill in any text that can explain the failure in the Failure instructions text field.

Results

For more information, see Setting checkpoints on trigger connections.

Run if connection settings

About this task

In the Basic settings view of a Run if connection, you can set the condition to the subJob in Java.

You can use variables in your condition. Pressing Ctrl+Space allows you to access all global and context variables. For more information, see Using variables in a Job or Route.

Information noteWarning: When adding a comment after the condition, be sure to enclose it between /* and */ even if it is a single-line comment.

In the following example, a message is triggered if the input file contains 0 rows of data.

Basic settings view of the connection.

Procedure

  1. Create a Job and drop three components to the design workspace: a tFileInputDelimited, a tLogRow, and a tMsgBox.
  2. Connect the components as follows:
    • Right-click the tFileInputDelimited component, select Row > Main from the contextual menu, and click the tLogRow component.
    • Right-click the tFileInputDelimited component, select Trigger > Run if from the contextual menu, and click the tMsgBox component.
  3. Configure the tFileInputDelimited component so that it reads a file that contains no data rows.
  4. Select the Run if connection between the tFileInputDelimited component and the tMsgBox component, and click the Component view. In the Condition field on the Basic settings tab, pressing Ctrl+Space to access the variable list, and select the NB_LINE variable of the tFileInputDelimited component. Edit the condition as follows: 
    ((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE"))==0
  5. Go to the Component view of the tMsgBox component, and enter a message, "No data is read from the file" for example, in the Message field.
  6. Save and run the Job. You should see the message you defined in the tMsgBox component.

Did this page help you?

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

Leave your feedback here