New ways to automate business processes

There are several new ETL Package objects in the latest version of Advanced ETL Processor:

What are the Package variables?

Package variables provide a convenient way of storing/accessing temporary data.

Note:

• Package variable name can be any string.
• It is not recommended to use very short names for package variables, for example, the user can call a variable “I” and set the value to Test. This might create problems later because It would be replaced with “Test”, so “C:\Program files” would become “C:\Program ftestles”

How Package variables can help business process automation?

There are several ways Package variables can benefit the user:

• They can be used to provide additional information.
• As temporary storage of the data, for example for cycles
• To modify package object properties dynamically  

What are the ways of accessing and modifying package variables?

Script package object allows writing additional complicated checks and validations.
It supports all functions used by Calculation object + variables' functions.

Example:
 

Var I : Integer;
begin
I:=1;
SetVariable('I',I);
I:=GetVariable('I');
WriteToLog('Error',I);
Result:=True;
end;

Result:=True;  => Succes
Result:=False; => Failure

Set Variable package object is a convenient way of changing package object properties dynamically.
Once the variable is set, it will be replaced with the actual value for the objects executed after.

System variables

System variables are used to provide the user with additional information.
For example, SQL script has failed and the user would like to email the SQL to the developer. Insert <Sql Script> into email message body and it will be replaced with actual SQL automatically

Usage examples:

• Using cycles to load data from multiple directories

• Package variables in File Operation properties dialogue