Import Sets Flashcards
What roles are required to manage aspects of import sets?
admin role or import_admin role
What is the use of an Import Set?
Import data from various data sources then map that data into ServiceNow tables
How can I import data?
- Local source file (xml, csv, excel)
- Network server by providing path and authentication info
- LDAP connection
- JDBC connection
- OIDC
- REST (Integration Hub)
- Data Stream Integration Hub
- Custom (load by Script)
Which label is used to name the Import Set table?
The Import Set table is named with the imported file label
What is a Transform map used for?
- Move data from an Import Set table to a Target table.
- Transform map determines the relationships between the fields in the import set table and the fields in the SN target table
Can a single field in the import set table be mapped to multiple fields in the target table?
Yes
Which tables are a potential destination for transformation of an Import set?
Any table
We can only select:
- tables within the currently selected application scope
- tables in the global scope
- tables that grant write access to other applications
Which fields in a destination table can serve as potential destination fields for transformation from an Import Set?
Any field
Can a transform map be reused after it has been defined?
Yes
What is the Automatic Mapping Utility used for?
Used when the fields in the Import Set table match all the fields in the target table.
Press Auto Map Matching Fields in the related list in the table transform maps form (??)
What is data transformation?
The conversion of an Import Set table into its target table according to rules defined in the transform map
What is a target table?
An existing table in the platform where the data will be placed post-transformation
What happens during data transformation when the coalesce checkbox is selected in the field map?
The instance checks for existing records in the target table with the same value as the one in the import set field
What happens if a match value (import set - target table) is found when the coalesce option has been selected?
The record is update with the imported data
What happens when the value of the coalesce field in the target table does not match the value in the import set table?
A new record is inserted with the new data
Why do we use coalesce fields?
In order to avoid duplicate records.
The coalesce field indicates to update records.
If no coalesce is defined, all imported records are treated as new records, and are inserted.
How many configurations are there to coalesce imported data?
- No coalesce
- Single-field coalesce
- Multiple- field coalesce
- Conditional coalesce
What happens if we choose the “No coalesce” option?
Every imported record is treated as a new record and is inserted.
No records are updated
What happens if we choose “Single-field coalesce” option?
If a record in the target table exists with the same field value as in the import set table coalesce field, then the record is updated with the new record data.
What happens if we choose “Multiple-field coalesce” option?
If a record in the target table exists with the same valueS as in in the import set coalesce fieldS, then the record is updated.
All the fields values in the target table must match the field values in import set for the record to be updated.
What is conditional coalesce?
Conditional coalesce script defined in the field map for the sys_id field.
To update a record using the import table record values, the script must return the target table record sys_id
What is a data policy?
A rule used to enforce data consistency by setting fields as mandatory and/or read-only
How does data policies apply to tables and db relative to scope?
Can create data policies
- only for tables and db views that are in the same scope as he data policy
- for tables that have at least 1 field in the same scope as the data policy
- if the table is not in the same scope as the data policy, we can create data policy rules for fields that are in the same scope but cannot make a field mandatory
Where to go to configure data policy?
All > System Policy > Rules > Data Policies
Data policies can be applied to what type of data?
All data entered into the system, including,
- import sets, web services, data entered through UI Mobile
Can data policies be opted out for import sets and web services?
Yes
What happens when a data policy is applied to a list view to make a field read-only?
The field will appear to be editable but the update will fail.
Where do we create an Import Set in the All menu?
All > System Import Sets > Load Data
What role is required to populate the Load Data form in order to create an Import Set?
import_admin
OR
import_set_loader
OR
import_transformer
Where to go in the All menu to create a Transform Map?
All > System Import Sets > Create Transform Map
Where to go in the All menu to define a Coalesce field?
All > System Import Sets > Administration > Transform Maps
Where to navigate in order to clean up an import set table?
All > System Import Sets > Import Set Tables > Cleanup
