Import Sets

Import Sets

an Import set is a tool used to import data from various data sources, and map that data into sn tables

Pull data into SN

• Import sets provide a mechanism to pull data into servicenow.
• import sets styore data in import set tables
• Any user logged in with the admin or import admin role can manage all aspects of import sets

What are Data Sources

• Data sources are records in servicenow that contain information regarding an import set data source.
• you can import a file from a local source or from a network server by providing a path and authentication information
• a data source can come from a file, an ldap connection or jdbc connection

Staging Area for records

• The import set table acts as a staging area for records imported from a data source

Guide for moving

• Transform Maps provide a guide for moving data from import set tables to target tables
• Field mapping provides direct field to field data moves

What is a Transform Map?

• 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.

Reusing for Mapping Data

• Transform maps can be reused for mapping data from an import set

Define destinations for imported data on any servicenow tables

• Transform map module enables an admin to define destinations for imported data on any servicenow tables.

Dragging and dropping

• Transform mapping can be as simple as dragging and dropping to specify linking between source fields on an import set table and destination fields on any servicenoew table

Target Table

• The target table is an existing table in where the data will be placed, post-transformation.