| Info |
|---|
This article instructs you on how to set up and automate Cloudaware CMDB data import into ServiceNow CMDB using a Google BigQuery table. |
| Table of Contents | ||||
|---|---|---|---|---|
|
Prerequisites
1. Ensure you have sufficient permissions to operate in ServiceNow or contact your ServiceNow administrator for assistance.
...
*If you have a Google BigQuery table preconfigured, Cloudaware will provide you with the resulting file. Otherwise, Cloudaware provides a path to the file stored in Cloudaware's BigQuery table.
1 - Create Data Source
Create a data source in ServiceNow to store the imported Cloudaware data as the import set table (check ServiceNow Documentation). Fill in the form and click Submit:
...
Click Load All Records to load data into the import set table:
...
2 - Create Target Table
The target table stores ServiceNow CMDB data. If you use ServiceNow as CMDB and have a target table already to import external data, skip to step 3.
Manually
Check ServiceNow Documentation for instructions.
| Note |
|---|
Use consistent field names in both the target table and the import set table (stage table) to ensure automated mapping of matching fields. |
Automatically using a custom script
To use this option, create the import set table (stage table) first as the script checks field names and uses them to create a target table to automatically map fields while transforming.
...
This script must be run before transform map creation in step 3.
3 - Create Transform Map
Set up a transform map to define and automate field mapping. Click Create transform map:
...
The data will be loaded to the target table:
...
4 - Schedule Data Import
Once data tables are managed and mapping is set up, schedule data import runs - check ServiceNow Documentation for instructions.
...