ServiceNow CSA Online Access

InServiceNow,System Import Setsis the primary application used toimport and transform datafrom external sources into the platform. It provides a structured way toload data into tableswhile allowingdata transformation and mappingbefore final insertion.

Data Loading from External Sources:

Supports imports fromCSV, Excel, XML, JSON, and JDBC databases.

Allows data fromexternal systemsto be brought into ServiceNow.

Staging Area for Data Processing:

Imported data first enters atemporary staging table(Import Set Table).

Data can then betransformedbefore being committed to the target table.

Data Mapping and Transformation:

UsesTransform Mapsto map fields from theImport Set Tableto theTarget Table.

Supportsautomatic field mappingandscripted transformations.

Data Cleansing and Validation:

Duplicate records can bedetected and removed.

Invalid or missing data can becorrected before insertion.

Navigate to System Import Sets(All → System Import Sets → Load Data).

Upload the data file(CSV, XML, JSON, etc.).

Create a Transform Mapto define how data is mapped to the target table.

Run the transformationto move data from the Import Set Table to the final table.

Verify the datain the target table.

A company importsemployee recordsfrom an externalHR system (CSV file).

TheSystem Import Setsmodule loads this data into astaging table.

ATransform Mapmoves the data into theUser [sys_user]table.

Key Features of System Import Sets:Steps to Load Data Using Import Sets:Example Use Case:

Why Option C (System Import Sets) is Correct?System Import Sets is the primary tool for loading data into ServiceNow from external sources.

Why Other Options Are Incorrect?A. Service Level Management→ Incorrect

Service Level Management (SLM)is used to trackService Level Agreements (SLAs), not to import data.

B. Configuration→ Incorrect

Configuration Management (CMDB)helps trackconfiguration items (CIs)but does not handle data imports.

D. System Update Sets→ Incorrect

Update Setsare used tomove configurations and customizationsbetween instances,not to import data.

ServiceNow Docs – Importing Data with System Import

ServiceNow Learning – Data Import & Transformation Best Practices

ServiceNow Developer Portal – Using Import Sets Efficiently

References from Certified System Administrator (CSA) Documentation:

In ServiceNow,UI PoliciesandData Policiesserve different but complementary purposes in controlling data behavior and enforcing business rules.

UI Policies are client-side rules that dynamically change form behavior based on user interactions.

They enable administrators to show/hide fields, make fields read-only, or set fields as mandatory dynamically.

UI Policies only apply when a user is interacting with a form through the ServiceNow UI (Client-side execution).

These policies do not enforce rules if data is added via an Import Set, API, or background script.

Data Policies enforce rulesserver-side, meaning they applyregardless of how data is entered(e.g., form submission, Import Sets, SOAP/REST API calls, or Business Rules).

They ensure data integrity by making fields mandatory, setting read-only properties, or applying other restrictions.

Data Policies can apply conditions globally, unlike UI Policies, which work only in the UI context.

UI Policies:Data Policies:Key Differences:Feature

UI Policy

Data Policy

Scope

Affects only forms (Client-side)

Affects all data entry points (Server-side)

Execution Location

Runs in the browser

Runs on the server

Triggers

User interaction on the form

Any data entry method (Forms, Import Sets, API, etc.)

Enforcement

Works only when using the UI

Applies even when data is added outside the UI

"Data Policies run regardless of how data is entered into ServiceNow"→Correct, because Data Policies enforce rules whether the data is entered via UI, API, Import Sets, or other means.

"UI Policies are used for form interactions"→Correct, because UI Policies apply only to client-side form behavior.

Option A: Incorrect. UI Policies are not set by web services; they are applied when interacting with forms.

Option B: Incorrect. While some Data Policies can be converted into UI Policies, the reverse is not true in all cases.

Option D: Incorrect. UI Policies and Data Policies operate independently, and Data Policies do not depend on UI Policies running first.

Why Option C is Correct:Why Other Options are Incorrect:

TheApplication Integration and Plugin Delivery (A1PD) SpokeBatch Installplugin inServiceNowallows users to installmultiple applications, customizations, and pluginsat once.

Batch Installation

Enables administrators to install multiple applications or pluginssimultaneously, reducing manual effort.

Automated Delivery

Facilitatesautomated deploymentof related applications and customizations.

Improved Instance Management

Ensures consistent configurations across multiple instances (e.g.,Dev → Test → Prod).

B. Continuous Integration and Continuous Delivery (CICD) SpokeBatch Install

Incorrect: CICD is used forversion control and automated deployments, not plugin installation.

C. Multiple Integration and Process Delivery (MIPD) SpokeBatch Install

Incorrect: No such ServiceNow plugin exists.

D. Quick Integration and Multiple Delivery (QIMD) SpokeBatch Install

Incorrect: No such ServiceNow feature exists.

Key Features of A1PD SpokeBatch Install:Why Other Options Are Incorrect?

A1PD Plugin Overview

ServiceNow Plugin Installation

Application Integration Best Practices

Managing Installed Applications

References from ServiceNow CSA Documentation:Final Verification:Answer is 100% correct and aligned with official ServiceNow Certified System Administrator (CSA) documentation.

ATransform Mapin ServiceNow is a tool used to define relationships betweenfields in an import set tableandfields in a target table. It helps map incoming data to the appropriate fields within the ServiceNow database when importing data from external sources.

Data is loadedinto anImport Set Table.

ATransform Mapis created to define how fields from the import set correspond to fields in the target table.

TheTransformation Processis executed, applying the mapping rules.

The data is stored in theTarget Tablewith any specified transformations applied.

Supportsfield mapping,scripted transformations, andcoalesce fields(for avoiding duplicate records).

Allows fordata cleansing and standardizationduring the transformation process.

Can be reused for multiple data imports.

A. Transform Schema→ No such concept exists in ServiceNow.

B. Schema Map→ Provides a visual representation of table relationships but does not define field mappings for imports.

C. Dictionary Map→ Used for mapping between dictionary definitions, not for transforming import set data.

E. Field Transformer→ Not a ServiceNow tool.

F. Import Designer→ No such module in ServiceNow.