Host scripts are generated either manually or via templates. Most Target Enablement Packs provide a rich set of templates for data warehouse operations that automate the generation of either PowerShell or Python scripts for all object types and supported sources. Scripts can also be created manually provided the rules for their inclusion into the scheduling process are followed.
Script Generation (Windows/SQL Server)
WhereScape RED TIP: Parameters
Parameters can also be added to Scripts to facilitate deployment processes or environment changes without the need to regenerate scripts.
For example: add $P<ParameterName>$ to the script where $P$ is the parameter indicator as shown below.
Before adding the Parameter to the script, create the desired parameter in Tools > Parameters > Add Parameter Source (context menu).
The script makes use of several environmental variables. These variables are acquired from both the Table and Connection properties. These variables are established in the environment by either WhereScape RED or the scheduler. If the script is to be executed outside of WhereScape RED or scheduler control, these variables must be assigned.