ServiceNow IMPORT SET | Import DATA into ServiceNow | Data source, Mapping Assist and Transform Map
LIKE, COMMENT, SHARE
SUBSCRIBE CHANNEL
CIELO ServiceNow, AWS, Networking
/ @cieloservicenowawsnetworking
Import sets
--Import sets allow administrators to import data from various data sources, and then map that data into ServiceNow tables.
Import sets key concepts
--The Import Sets table acts as a staging area for records imported from a data source.
Import Set table
A table that acts as a staging location for records imported from a data source before transforming those records. Fields on these tables are generated automatically based on imported data and should not be modified manually
Data source
A record that defines where to get the data to import. A data source may point to a file, a JDBC-compatible database, or an LDAP organizational unit
Transformation
The conversion of data from an import set table to another table according to the rules defined in a transform map.
Transform map
A set of field maps that define the relationships between fields in an import set and fields on a table, such as Incident.
During transformation, data is copied from the Import Set table to the destination table based on the transform map.
A single import set field may be mapped to multiple fields on other tables.
Coalesce
Lets you update existing target table records when transforming import data.
You can specify whether a Target field should be used to coalesce on when import set records are transformed. If the field map Coalesce check box is selected, when the import set row is transformed, the instance checks for an existing record in the target table that has the same value in the Target field as the import set row Source field.
If an existing record with a matching value in the target table is found, that record is updated. If no matching record is found, then a new record is created in the target table.
#Import_sets
#Import_Set_table
#Data_source
#Transform_map
#Servicenow
#ITSM
