In this article:

Creating the ETL Task Step

To create a step executing ETL task, open the ETL task step wizard.

After the basic step properties have been determined, click the Next button on the first page of the wizard.

Step Description

The next wizard page is Step Description:

Determine the following for the ETL Task step on the Step Description page:

Owner Role. The box is mandatory. In the drop-down list select the owner role. The list contains roles of users specified in the authorization object.

If there is no required group of users in the list, click the Open Security Manager button. The dialog box of security manager of Foresight Analytics Platform opens, which enables the user to create the required group of users.

ETL Task. The box is mandatory. Select an ETL task in the drop-down list, you can use search. The list contains repository objects tree where ETL tasks and folders containing them are only displayed. To edit the selected ETL task, click the button. The ETL task editor dialog box opens.

Step Execution Time. The time, in which a step must be executed on process execution.

Enter a numeric value of step execution time and select a time measurement unit in the list:

Minute.
Hour.
Day (default).
Week.
Month.
Quarter.
Half-year.
Year.

To determine time, by which step must be finished, select the Finish Step By checkbox. When the "minutes" or "hours" time measurement units are selected, this box is hidden.

If the step is not finished by the scheduled execution period, the step status becomes Expired.

The step execution period impacts the whole process execution period, which is determined on starting process for execution.

Step Description. The box is optional. A text box for entering a comment for a step.

After the parameters have been determined on the Step Description page, click the Next button.

Managing Parameters

The next wizard page is Manage Parameters:

Determine the following for the ETL Task step on the Manage Parameters page:

Correspondence Between ETL Task and Process Parameters. It is required to set correspondence between ETL task and process parameters in order that ETL task executes with the same parameters as the process step started for execution:

Fixed. Select the Fixed dialog box to limit a list with parameters values used on starting ETL task.
ETL Task Parameter. The list contains parameters of the ETL task. It is filled in automatically.
Process Parameter. In the Process Parameter drop-down list select a process parameter that corresponds to the data entry form parameter.

If there is no required process parameter, click the Process Parameters button. The Process Settings and Parameters dialog box opens, in which a process parameter can be added.

Fill In from Authorization Object. Click the Fill In from Authorization Object button to copy automatically parameters settings from authorization objects.

After the parameters have been determined on the Manage Parameters page, click the Next button.

Events

The next wizard page is Events:

Set up automatically executed actions launched on step execution start or end.

On generating a list of executed actions, select a tab with event first:

Before Execution. The list of actions will be started before executing the current step in the specified order.
After Execution. The list of actions will be started after executing the current step in the specified order.
On Rejection. The list of actions will be started on the current step rejection. The list is available for steps with manual execution. If the step is executed automatically, the tab is not displayed.
On Failures. The list of actions will be started on failure to execute the current step in the specified order. To execute the actions:

When the server execution of processes is selected, select the Check Steps Execution Failures checkbox on the Scheduler page of the Parameters Setup and Business Process Management dialog box and set check frequency.
When the client execution of processes is selected, select the Check Failures item on the Administration page of the Parameters Setup and Business Process Management dialog box.

To add an event, click the button on the ribbon. The number of added actions is unlimited.

Actions to be added:

. Execute Fore method. In the right part of the window select:

Unit. In the drop-down list select a unit written in the Fore language, the list contains all repository units and folders containing units. Search by unit name is available.

To edit the selected unit, click the button.

To create a unit, click the button.

Method. In the drop-down list select a method. The list contains all unit methods corresponding to the signature:

Sub <Fore-method name>(Sender: IBProcessInstance; Args: IBProcessStepStateEventArgs);

Parameter:

Sender. Process instance.

Args. Event information: step, step old state, new state.

To refresh the methods list, click the button.

To copy method signature, click the button.

. Send Email. In the right part of the window select:

To; Copy; Bcc. The recipient email is entered manually, using option of copy/paste from clipboard.
Subject. The email subject is entered manually, using option of copy/paste from clipboard.
Contents. The contents is entered manually using the option of variables values substitution with step parameters, links to step objects to view in the web application, file attachment.

To change order of operations execution, use the / buttons on the toolbar, to delete use the button.

The list of automatically executed actions can be empty.

Click the Finish button to exit the wizard.

After creating the process steps, set up process steps execution conditions.