DBMS Command

Determine input identifier of editing object. It is possible to use Latin characters, numbers or the _ wildcard.

Set link to object. To do this, select the ETL task object in the drop-down list. Data from the object is sent to input.

Add required fields of the ETL task object to the list. Data will be loaded to specified fields.

NOTE. For the XML data consumer, the list of fields displays the XPath field that is identifier of the node in XML file. The field is created automatically and cannot be edited.

To add all fields from the object being consumer linked to the input to the list:

1. Click the Fill From button.

2. Select the From Consumer item in the button drop-down menu.

To add all fields from the object being provider linked to the output to the list:

1. Click the Fill From button.

2. Select the From Provider item in the button drop-down menu.

Click the Add button to add a new field. A dialog box opens where you can define values of field attributes:

NOTE. The Field Properties dialog box view depends on the selected data provider.

Set field attributes in the dialog box:

• Identifier. Unique identifier of the field.

• Name. Field name.

• Data Type. Select type of field data from the drop-down menu.

• Total Length. Determine total length of a field. Available only for string and real type data.

• Decimal Places. Determine the number of decimal places. Available only for real type data.

• Calculated Field. To set a formula, for which field value is calculated, select this checkbox. After selecting the checkbox enter the formula by using the keyboard or expression editor that opens on clicking the button. To increase the value of each new record for a fixed size, use the INCREMENT special expression.

NOTE. The INCREMENT special expression is available only for calculated field of integer type.

The syntax of the expression: INCREMENT[Value1, Value2] where Value1 - initial value, Value2 - step, by which the Value1 value must increase on each expression calling. Each data loading starts with initial value.

To edit field:

• Double-click the field with the main mouse button.

• Select the required field and click the Edit button.

To delete the selected field, click the Delete button. The field is deleted without confirmation of executing operation.

To move the field selected in the list, use the and buttons.

Determine output identifier of edited object. It is possible to use Latin characters, numbers or the _ wildcard.

Set link to object. To do this, select the ETL task object in the drop-down list. Data from the object is sent to input.

Add required fields of the ETL task object to the list. Data is loaded from selected fields.

To add all fields from the object being consumer linked to the input to the list:

1. Click the Fill From button.

2. Select the From Consumer item in the button drop-down menu.

To add all fields from the object being provider linked to the output to the list:

1. Click the Fill From button.

2. Select the From Provider item in the button drop-down menu.

Click the Add button to add a new field. The Field Properties dialog box opens:

NOTE. The Field Properties dialog box view depends on the selected data provider.

Set field attributes in the dialog box:

• Identifier. Unique identifier of the field

• Name. Field name

• Type. Select type of field data from the drop-down menu.

• Calculated Field. To set a formula, for which field value is calculated, select this checkbox. After selecting the checkbox enter the formula by using the keyboard or expression editor,  that opens on clicking the button To increase the value of each new record for a fixed size, use the INCREMENT special expression.

NOTE. The INCREMENT special expression is available only for calculated field of integer type.

The syntax of the expression: INCREMENT[Value1, Value2] where Value1 - initial value, Value2 - step, by which the Value1 value must increase on each expression calling. Each data loading starts with initial value.

To edit field:

• Double-click the field with the main mouse button

• Select the required field and click the Edit button.

To delete the selected field, click the Delete button. The field is deleted without confirmation of executing operation.

To move the field selected in the list, use the and buttons.