Importing Data Flashcards
What are the import sets used for?
They are user to import data from various sources of data and them map that data into ServiceNow tables
From what sources can you import data?
Local source file
A network server by providing a path and authentication information
LDAP connection
JDBC connection
What roles do you need to manage aspects of import sets?
admin
import_admin
What is the import set table?
It is a staging area for records imported from a data source. Fields are generated automatically based on imported data and should not be modified manually
How the import set table is named?
By the imported file label
Are created import sets table reusable?
Yes, you can use a previously created import set table with the same source or data that contains the same field/columns designations.
What is transform map for?
To provide a guide for moving data from import set tables to “Target” tables. It determines the relationships between fields in an import set table and fields in an existing ServiceNow table.
What is Automatic mapping utility?
When all the fields from the imported set table matches with the SN table, simply click on Auto Map Matching Fields in the related list
What is Mapping Assist utility for?
Provides a visually intuitive environment for specifying mapping between import set fields and target table fields.
What are the first things you should to, as best practice, before importing data?
- Understand what data you are bringing in and where that data should go
- Verify and clean it if needed
- Don’t import data with extremely large import sets to avoid extensive delays
What is data policy?
It is a rule that enforces data consistency by setting fields as mandatory and/or read-only.
Where can you create data policies?
You can create data policies only for tables and database views that are in the same scope as the data policy and for other tables that have at leas one field in the same scope as the data policy.
True or false - Data Policy is NOT about security
True - they are about managing the integrity of the information stored in the database
