Transform maps

A transform map is a set of field maps that determine the relationships between fields in an import set and fields in an existing ServiceNow table, such as Incident [incident] or User [sys_user].

Figure 1. Import process transform

After creating a transform map, you can reuse it to map data from another import set to the same table.

The Transform Maps module enables an administrator to define destinations for imported data on any tables. Transform mapping can be as simple as a drag and drop operation to specify linking between source fields on an import set table and destination fields on any table. Use transform mapping to map source and destination fields dynamically.

Using multiple transform maps

Multiple transform maps can be applied to a single data source.

One import set row is created per transform map. This behavior can cause a large number of temporary records to be generated.

Run multiple transforms off a single import set

Users can select multiple transform maps during data import.

The selected transform maps will be executed on the same import set in the order specified.

Figure 2. Multi Map Transform

Transform map scripts

Transform Map scripts allow you to customize import operations using a robust programming interface to introduce advanced logic.

A transform map script executes as events occur while an import set is being transformed onto a ServiceNow table. Transform Map scripting is fully integrated into the ServiceNow scripting environment. There are two types of Transform Map scripts:
  • Explicit Transform Map scripts, which explicitly define mapping relationships
  • Transformation Event scripts, which modify the processing of events at different stages of a transformation