Create Extract Transform Load (ETL) definitions
-
- UpdatedAug 1, 2024
- 2 minutes to read
- Xanadu
- Data Management
Create Extract Transform Load (ETL) definitions
Create ETL definitions to extract data from a source table, transform the data as desired, and load the data into multiple target tables. ETL definitions also support nested data structures.
Before you begin
Procedure
Example
In this example, the ETL Definition for Worker has both an onBefore and onAfter script. In the onBefore script, the source record with an id of 124 is ignored because that worker has already resigned. The source data and target data are both written to the import log. Finally, the script iterates through the transformed values of the sn_etl_demo_worker table to get each worker's ID and name and record them in the import log.
In the onAfter script, the source and target data are both written to the import log. The script again iterates through the transformed values of the sn_etl_demo_worker table. Now that the data has been inserted into the target table, each record has a sys_id. The script records each worker's Sys ID, ID, and name in the import log.

- For creating these definitions and mapping using a guided or step-by-step experience, refer to Integration Hub - Import.
- If your target table or application is related to CMDB, use the IntegrationHub ETL (3.2) guided experience.
Related Content
- Define ETL entities
Define the Extract Transform Load (ETL) entities used by the Robust Transform Engine.
- Define ETL entity mappings
Map the source entity to a target entity.
- Create ETL entity field definitions
Define the entity fields mapped for Extract Transform Load (ETL) operations.
- Define Robust Transform Engine operations
Define the operations the Robust Transform Engine (RTE) should perform.