{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":22207,"path":"integrate-applications/system-import-sets/define-etl-entities.md","title":"Define ETL entities","bundle":null,"doc_type":null,"release":"australia","body":"\n# Define ETL entities\n\nDefine the Extract Transform Load \\(ETL\\) entities used by the Robust Transform Engine.\n\n## Before you begin\n\nRole required: import\\_transformer\n\n## Procedure\n\n1.  Navigate to **All** > **System Import Sets** > **Administration** > **ETL Definitions**.\n\n2.  Select an ETL definition.\n\n3.  On the ETL Entities tab, click **New**.\n\n4.  Complete the form.\n\n    |Field|Description|\n    |-----|-----------|\n    |Name|Name of the ETL entity.|\n    |Table|Target table for the ETL entity.|\n    |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.|\n    |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.|\n    |Run business rules|Selected to run business rules. Unselected if you don't want to run business rules.|\n    |Application|Application scope for this record.|\n    |Definition|Selected ETL entity.|\n\n5.  Click **Submit**.\n\n\n"}}