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

Role required: import_transformer

Procedure

  1. Navigate to All > System Import Sets > Administration > ETL Definitions.
  2. Click New.
  3. Complete the form.
  4. Click Submit.

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.

ETL Definition example with onBefore and onAfter scripts.
Note: