Create the New CDW Connections

1. Create new embrace connection
2. Select ServiceNow tables on the cloud data warehouse
3. Tables from the ServiceNow schema that are required for Spotapps

Required:

• task
• incident
• incident_task
• problem
• Problem_task

Optional:

• cmn_location
• core_company
• sys_user
• sysusergroup

Note: These are the original table names from ServiceNow

Export Connection YAML File and TML Files

• Select new Embrace Connection with ServiceNow tables
• Remap Connection
• Download YAML file
• Navigate to the Data Tab
• Select the ServiceNow tables
• Click on Export TML

Run Script

• Unzip the spotapp zip file
• Copy the connection yaml file into the folder titled “InputConnectionYAML”
• Copy the table TML files into the folder titled “InputTableTML”
• Run the script through the terminal For macOS, copy folder to ‘Documents’ folder cd ~/Documents/Spotapps python3 spotapps.py

Column Description from the Mapping CSV

• A - User friendly column names in the Spotapp worksheet.
• B, C, D, E - Original table and columns, join table and column names are listed from the original ServiceNow schema.
• F, G - Details about the joins in the Spotapp worksheet (join type and join required for spotapp to work).
• H, I - Shows the Table and Column names from the user’s CDW.
• J, K - Shows the tables and columns that are required for spotapp to work; these tables and columns should be present in the user’s CDW.
• L, M - the tables and columns that are missing in the user’s CDW are indicated by Y. If column value is Y, then it indicates that our script did not find the table/column in the user’s connection.
• N, O - Mapping table and mapping column to be set by the user. When we find a missing column and indicate it in L, M by setting it to Y, we expect a value in these columns to point us to the corresponding columns in the user’s CDW.
• Example: we did not find ‘task’ table in the user’s CDW connection, user has renamed table to ‘servicenowtask’; then we need the value in column N to be set to ‘servicenowtask’ wherever we see a Y for the task table (screenshot on the next slide).

Import TML Files

• Import the files containing TML for the worksheets and verify that it has all been imported without any errors.
• Import the files for the liveboards and verify that it has all been imported without any errors.

Liveboard Screenshots

Significant Events Examinations

Incident Management Overview

Incident Management Performance