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, which enables the user to create a 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 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. On selecting the "minutes" or "hours" time measurement units, 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 Parameters. From 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.

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.
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.

. Send Email Notification. 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.

NOTE. Email notification can be sent only from Windows OS.

To change order of operations execution, use the / buttons on the toolbar, to delete - 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.