Routine - Extraction
Admin | 
ETL > Domains > select the desired domain > Routines > Extractions link
Note: if the ETL domain is locked, the link will not be selectable.
Purpose of the page¶
On this page, you can manage the tasks of a Routine that allow you to extract data from sources defined in the Data sources and save it in the ETL’s staging table
What it looks like¶
Attributes tab
If the Active option is enabled, the task will be run (default).
| Field | Description |
|---|---|
| Sorting | indicates the order in which the task must be run. You cannot set the value 0 or a sorting that already exists |
| Data source | indicates, through a data source, the possible data extraction methods to be selected later in the execution step (mandatory) |
| Descriptions | The description of the routine in the languages enabled in the environment |
| ETL filter (SQL Model) | allows you to select a filter that has been defined previously in the SQL models to limit the number of data items to be extracted. |
| ETL filter (specific) | allows you to indicate a filter with the SQL syntax to limit the number of data items to be extracted. The ETL’s dynamic syntax can be used (see ETL syntax) IMPORTANT: If the user specifies both the ETL filter (SQL Model) and the ETL filter (specific), the system will concatenate the conditions with the logic operator AND. |
Filter parameters tab
This tab allows you to set up to nine filter parameters to dynamically limit the number of data items to be extracted.
| Field | Description |
|---|---|
| Filter parameter 1, 2...9 | In each field, you can select one of the parameters created in the ETL domain |
IMPORTANT: only From CCH Tagetik, From Dimension Dictionary and Free type parameters can be used.
Note: If the user has also specified one of the two ETL filters, the system will concatenate the conditions with the logic operator AND.
Automatic dimensions enhancement tab
This tab allows you to define up to nine dimensions, automatically, in the execution step, by setting the Dimension 1...9 / Value 1...9 pair as indicated in the following example:
| Field I | Field II |
|---|---|
| Dimension 1 | Value 1 |
| Dimension 2 | Value 2 |
Note: These dimensions cannot also be specified in the data source fields definition. Data extraction will only take place using one of the methods defined by the data source selected in the execution step.
IMPORTANT: If several extraction tasks are required, for each task the system will insert the extracted data into the staging table in addition to those extracted from any previous loading tasks.