Data Source Fields Definition window
Admin | 
ETL > ETL Domains > Data Sources > Fields Definition link
Note: if the ETL domain is locked, the window will open in read-only mode.
Purpose of window¶
This window allows you to define alignment between the information present in the data sources to be extracted and the dimensions of the ETL domain, so as to process mapping between the source fields and the fields of the staging table.
Actions on this page
| Element | Description |
|---|---|
| This filters the data shown on the page. | |
| This adds a row in order to insert a new Data Source | |
| This duplicates the selected row with all the information inserted, except for the code. | |
| Deletes the element contained in the selected row. | |
| Enables/Disables the grid modify function. This allows you to change the characteristics of the selected elements directly in the table, and to hide the configuration tabs. | |
| Enables multi-row selection to allow mass changes. | |
| Selects the columns to be shown/hidden in the table and those to be locked when scrolling the table. | |
| Exports the data in Excel format so they can be edited and reimported into CCH Tagetik. | |
| Imports data from a previously prepared Excel file. |
Attributes tab
Please find below the most important fields.
| Field | Description |
|---|---|
| Dimension | Dimension of the ETL domain whose value, extracted from the source data, will be saved in the relative field of the Staging table. |
| Extraction type | Field option active |
| Depending on the extraction type managed in the Data source, the system will show different fields which allow you to define alignment between the Dimension and the values present in the various data sources: | |
| Excel (xls) | Excel (xls) column name indicates the value present in one of the cells of the header record present in the xls file to define the column from which to extract the values. |
| Excel (xlsx) | Excel (xlsx) column name indicates the value present in the xlsx file in one of the cells of the header record to define the column from which to extract the values. |
| CCH Tagetik database | CCH Tagetik database column name indicates the name of the column of the table/view or the query run on the CCH Tagetik database from which to extract the values |
| Other database | Other database column name indicates the name of the column of the table/view or the query run on another database from which to extract the values |
| Fixed Length | Text Fixed column position: indicates the index of the initial character of the value to be extracted from every record of the file Text Fixed Length column length: indicates the length in characters of the value to be extracted from every record of the file. Record: indicates a Recordto define the extraction of the value from a specific record of the file. (see Record types) |
| Text Delimited | Text Delimited column position indicates the number of the column of the file from which to extract the values. |
| Text Tab Delimited | Text Tab Delimited column position indicates the number of the column of the file from which to extract the values. |
| Xml | Xml column name: indicates the name of the tag from which to extract the values |
| Xbrl | Xbrl column name: indicates the name of the information returned by the (parser) of the Xbrl file from which to extract the values |
| OData service | OData service column name: indicates the name of the property belonging to the entity displayed by the service from which to extract the values |
| REST API | REST API column name: name of the property of the object displayed by the service from which to extract the values. For compound objects, the name can be indicated with the properties separated by the “.” character. E.g. employee.address.cap |
IMPORTANT: If new types of data source are being added to the Data Source, you must access this window to complete the setup; otherwise, an error will be returned during the execution of the extraction task which uses that Data Source.
The following Dimensions cannot be related:
- Dimensions used in the Dimensions from 1 to 9 fields of extraction tasks
- Dimensions which have a set Identity whose type is Num. Record which automatically defines the field of the Staging table related to the dimension with a progressive number for every extracted record.