ServiceNow Integration with GRC Library with Demonstration Records
ServiceNow Application: Policy and Compliance Management
This guide provides a demonstration of integrating the GRC Library with ServiceNow to access Authority Documents with Citations and Control Objectives.
The target audience for this setup requires knowledge of ServiceNow Data Source, Transform Map, Import Set, and Data Load administration.
3 Demo data sets are available.
- Demo = 0, MAS - Technology Risk Management Guidelines Jan 2021
- Demo = 1, EU - European Commission Digital Operational Resilience Act (DORA)
- Demo = 2, SG Cybersecurity Act 2018
This setup involves configuring 2 data sources:
Part 1: Import Authority Document
Create Data Source
- Name: GRC Library Authority Document
- Import set table label: GRC Library Authority Document
- Import set table name: (auto-completion by system)
- Type: File
- Format: XML
- XPath for each row: /items/item
- File retrieval method: HTTPS
- Server: grclibrary.com
- File path: xml_demo_sn_auth_doc.php?demo=1 (demo can be set to 0 or 1, two demo sets of data are available)
- Username: (No authorization required)
- Password: (No authorization required)
Click "Submit".
Test Load Records
Return to Data Source: GRC Library Authority Document. Click "Test Load 20 Records" to test loading data from GRC Library.
Create Transform Map
Return to Data Source: GRC Library Authority Document.
Under the "Transforms" tab, click "New".
- Name: GRC Library Authority Document Map
- Source table: (auto-completion by system)
- Target table: (select the Authority document table)
- Active: (checked)
- Run business rules: (unchecked)
- Enforce mandatory fields: No
- Copy empty fields: (unchecked)
- Create a new record on empty coalesce fields: (unchecked)
- Order: 100 (default)
- Run script: (unchecked)
Map fields using "Auto Map Matching Fields". Then, compare the mapping with the provided screenshot.
Set "u_source_id" coalesce to true. Ensure all fields are mapped.
Click "Update" to save the configurations.
Load Authority Document Data
Import set table: Existing table, GRC Library Authority
Source of the import: Data Source, GRC Library Authority Document
Click "Submit".
After completion, click "Run Transform". Select the transform map. Click "Transform".
Authority Document import completed.
Part 2: Import Citation and Control Objective
Create Data Source
- Name: GRC Library Citation Mapping
- Import set table label: GRC Library Citation Mapping
- Import set table name: (auto-completion by system)
- Type: File
- Format: XML
- XPath for each row: /items/item
- File retrieval method: HTTPS
- Server: grclibrary.com
- File path: xml_demo_display_sn.php?demo=1 (demo can be set to 0 or 1, two demo sets of data are available)
- Username: (No authorization required)
- Password: (No authorization required)
Click "Submit".
Test Load Records
Return to Data Source: GRC Library Citation Mapping. Click "Test Load 20 Records" to test loading data from GRC Library.
Create Transform Map
Return to Data Source: GRC Library Citation Mapping.
Important Notes:
These 3 Transform Maps will be used to:
Map1: GRC Library: 1-Create Citation and Link to Authority Document
Return to Data Source: GRC Library Authority Document.
Under the "Transforms" tab, click "New".
- Name: GRC Library: 1-Create Citation and Link to Authority Document
- Source table: (auto-completion by system)
- Target table: (select the Citation table)
- Active: (checked)
- Run business rules: (unchecked)
- Enforce mandatory fields: No
- Copy empty fields: (unchecked)
- Create a new record on empty coalesce fields: (unchecked)
- Order: 100 (default)
- Run script: (unchecked)
Map fields using "Auto Map Matching Fields".
Set "u_source_id" and "u_source" coalesce to true.
Change "u_description" to "u_reason".
Add a new mapping:
- Source field: parent_source_id
- Target field: Authority document
- Reference value field name: source_id
- Coalesce: (checked)
Compare the mapping with the provided screenshot. Ensure all fields are mapped.
Click "Update" to save the configurations.
Map2: GRC Library: 2-Create Control Objective and Link to Citation
Under the "Transforms" tab, click "New".
- Name: GRC Library: 2-Create Control Objective and Link to Citation
- Source table: (auto-completion by system)
- Target table: (select the Control objective table)
- Active: (checked)
- Run business rules: (unchecked)
- Enforce mandatory fields: No
- Copy empty fields: (unchecked)
- Create a new record on empty coalesce fields: (unchecked)
- Order: 101
- Run script: (unchecked)
Map fields using "Auto Map Matching Fields". Ensure all fields are mapped.
Click "Update" to save the configurations.
Map3: GRC Library: 3-Link Citation and Control Objective
Under the "Transforms" tab, click "New".
- Name: GRC Library: 3-Link Citation and Control Objective
- Source table: (auto-completion by system)
- Target table: (select the Control objective to Citation table)
- Active: (checked)
- Run business rules: (unchecked)
- Enforce mandatory fields: No
- Copy empty fields: (unchecked)
- Create a new record on empty coalesce fields: (unchecked)
- Order: 102
- Run script: (unchecked)
Create a new field mapping 1:
- Map: GRC Library: 3-Link Citation and Control Objective (Default)
- Source table: (default)
- Source field: source_id
- Choice action: ignore
- Application: (default)
- Target table: (default)
- Target field: Citation
- Referenced value field name: source_id
- Coalesce: (checked)
Create a new field mapping 2:
- Map: GRC Library: 3-Link Citation and Control Objective (Default)
- Source table: (default)
- Source field: source_id
- Choice action: ignore
- Application: (default)
- Target table: (default)
- Target field: Control Objective
- Referenced value field name: source_id
- Coalesce: (checked)
Ensure all fields are mapped.
Click "Update" to save the configurations.
Load Citation and Control Objective Data
Import set table: Existing table, GRC Library Citation Mapping
Source of the import: Data Source, GRC Library Citation Mapping
Click "Submit".
After completion, click "Run Transform".
Select all 3 transform map and make sure their running order (ascending order). Click "Transform".
Citation and Control Objective import completed.