OLE DB

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

Determine a connection with the consumer object, to which data will be loaded. To do this, select the ETL task object in the drop-down list.

Fields of consumer object, to which data is to be loaded, are used to determine the format of data output.

NOTE. Editing the fields list is available only for data provider connectors. The fields list is filled in automatically for data consumer connectors.

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

1. Click the Fill From button.

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

After executing the operations, all fields from the linked data consumer object will be added to the fields list.

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

1. Click the Fill From button.

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

After executing the operations, all fields from the linked data provider object will be added to the fields list.

To add a new field:

1. Click the Add button. The Field Properties dialog box opens:

2. Set values of field attributes in the dialog box that opens:

• Identifier. Determine a field unique identifier. FIELD<Field number> is used by default.

• Name. Determine a field name. FIELD<Field number> is used by default.

• Type. Select type of field data in the drop-down list:

• String.

• Integer.

• Real.

• Data.

• Text.

The String data type is used by default.

• Calculated Field. To set a formula, by 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 Browse 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 call. Each data loading starts with initial value.

3. Click the OK button.

After executing the operations, a new field is added.

To edit field:

• Double-click the field.

• Select the required field and click the Edit button.

After executing the operations, the given above Field Properties dialog box opens.

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

To change data loading order to the connector, select the required field and move it in the list of fields using the Up and Down buttons.