Procedure: ETL

Procedure is an object used to execute procedures or functions implemented in the Fore/Fore.NET languages in modules, forms, or repository assemblies.

Execution settings

The list of available items contains procedures and functions without parameters or with parameters of simple types. The Refresh List of Parameters button enables the user to refresh the list of available parameters according to the signature of selected procedure or function. Each option will have available editor, which enables the user to set value. Parameter values are passed to procedure or function on execution.

The list of inputs and outputs may be formed only based on provider outputs, to which the current object is connected. Physical data is not passed to the executed procedure or function. It is passed exactly from the input to the output. Inputs and outputs are set to include the Procedure object into an execution chain.

Edit Input

To set a list of fields and link to input, use the Edit Input page.

To display the page

In the Repository data consumer wizard:

On the Basic Properties page, if necessary, correct object name, identifier, note
On the Data Consumer page determine repository data consumer.

In the Access, Visual FoxPro, Dbase, Excel, OLE DB data consumers wizards:

On the Basic Properties page, if necessary, correct object name, identifier, note
On the Export Options page determine file for data export. Page view depends on consumer type
On the Error Handling page determine export object behavior in error situations.

In the Text, XML data consumer wizards:

On the Basic Properties page, if necessary, correct object name, identifier, note
On the Export Options page determine file for data export. Page view depends on consumer type.

In the User Consumer data consumer wizard:

On the User Class page determine unit and class, which will be used to get data.

In the DBMS Command object wizard of the Others group:

On the DBMS Command page select the DBMS Command or Procedure».

In the Procedure object wizard of the Others group:

On the Execution Settings page select assembly, unit or repository form and the procedure containing in it.

In the data transformer wizard, the Edit Input page will be available after transformer adding to the working area.

The following parameters are available on the page:

Identifier

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

Link to object

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.

Fields

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:

Click the Fill From button.
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:

Click the Fill From button.
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.

Edit Output

To set a list of fields and output link, use the Output Edit page.