ETL Domains
Definition¶
An ETL domain is presented as a container macro containing an entire setup that allows the user to define the following rules:
- extract data from various types of source
- transform them using configurable logics
- load them either to CCH Tagetik or to other target types
ETL domain types: standard and custom¶
In CCH Tagetik, there are two types of domain:
| Element | Description |
|---|---|
| Standard ETL domain | Domains that are pre-existing by default. These allow you to load both standard data (amounts, intercompany transactions, journals and FX rates) and metadata (elements of dimensions, hierarchies and groupings). |
| Custom ETL domain | Domains which can be created as fully configurable, and can meet specific business needs. |
ETL: Domain setup restrictions¶
The definition of ETL domains is subject to visibility restrictions. If the user is subject to restrictions, this page will only show the ETL domains for which they have visibility rights and the user will not be able to add or clone new records. vedi User Rights: Other Restrictions.
Staging tables¶
In the execution step, the ETL populates a temporary table (“Staging “ Table) by extracting the data from one or several external sources, transforming it with a series of rules and then loading it onto CCH Tagetik or other destinations such as files of custom tables. In the window accessible from the Dimension and Dictionaries link, you must create alignment between the following structures:
- the structure of the data to be extracted and that of the “Staging ” table;
- the structure of the “Staging table” and that of the target table or file