Define the Extract Transform Load (ETL) entities used by the Robust Transform Engine.

Before you begin

Role required: import_transformer

Procedure

  1. Navigate to All > System Import Sets > Administration > ETL Definitions.
  2. Select an ETL definition.
  3. On the ETL Entities tab, click New.
  4. Complete the form.
    FieldDescription
    Name Name of the ETL entity.
    Table Target table for the ETL entity.
    Path Unique path for this entity. Should not specify any path for the entity representing the import set table. When an entity represents a collection, the path must end with [*]. This requirement applies to intermediate entries and the target table entity.
    Synchronize Inserts Selected to guarantee only one record with unique coalesce field values by synchronizing record inserts. Unselected if you don't want to synchronize record inserts.
    Run business rules Selected to run business rules. Unselected if you don't want to run business rules.
    Application Application scope for this record.
    Definition Selected ETL entity.
  5. Click Submit.