transform-maps

Automate ServiceNow data imports by connecting CSV data sources to target tables through import sets, transform maps, and field mappings. You configure the import set staging table, define a transform map, and map fields directly or via script.

A ServiceNow transform map defines how imported data moves from an import set staging table to a target production table. You need one for any data-loading scenario requiring field mapping, data cleaning, or coalescing to update existing records.

Yes, ServiceNow transform maps support onBefore and onAfter scripting to customize data transformation. OnBefore scripts modify field values before mapping, while onAfter scripts execute logic after the record is committed to the target table.

Yes, the transform map workflow supports CSV, JDBC, and REST data sources for ServiceNow import sets. Data flows from these sources into staging tables, then transform maps apply field mappings to push records into target tables.

To update existing records without duplicates during a ServiceNow data import, use coalescing on your transform map. Coalescing specifies one or more fields to match incoming data against existing target records, triggering an update instead of an insert.