Commands routine

Admin |

ETL > Domains > Routines link in the Definition section > Commands link

Note: this link is visible only if the 0003874 function is included in the user's role and is enabled. If the ETL domain is locked, the link will not be selectable.

Purpose of the page

This page allows you to define custom statements and stored procedures that can be run during the execution of an ETL routine.

Buttons on the page

Element	Description
	Allows you to add a command.
	Allows you to remove a command.

Commands

Please find below the most important fields.

Field	Description
Command type	Allows you to define the type of command to be run during the execution of a routine: - Custom allows you to manually define a generic SQL statement. - Stored procedure allows you to define a stored procedure.
Command	If the type is Custom, it will contain the SQL text to be run; the ETL’s dynamic syntax can be used (see Filter Syntax or SQL Query) If the type is Stored procedure, it will allow you to select one of the stored procedures present in the CCH Tagetik database whose name has the prefix CPM_SP.
ETL phase	Indicates the step of the ETL routine (Extract, Transform, Load) in which to run the command
Sorting	Indicates the order in which to run the command in respect of the Extraction, Transformation or Loading tasks involved in the step of the ETL routine; it the sorting is the same, the task is run first.
Parameters	If the selected stored procedure requires the selection of parameters, these will be shown in the Stored procedure parameters panel below. Depending on the parameter name, different editors will be shown to select the value (see Stored procedure manual). The ETL’s dynamic syntax can be used (see Filter Syntax or SQL Query) as the value of a parameter.