| Info |
|---|
Cloudaware can import CMDB data into the Google BigQuery and then automatically upload the data to ServiceNow on a regular basis. This article instructs you on how to set up and automate import of Cloudaware CMDB data import into ServiceNow CMDB using a Google BigQuery table. |
.png?version=1&modificationDate=1725038829473&cacheVersion=1&api=v2)
To see how Cloudaware seamlessly integrates with ServiceNow in action, request a demo.
Use case: Using Cloudaware and ServiceNow for asset management, a customer would like to download their app inventory or the list of AWS-related resources from Cloudaware CMDB to ServiceNow to enrich the existing data. Cloudaware uses Google BigQuery as temporary storage for the imported CMDB data file. The customer should set up data import in their ServiceNow to get data uploaded and mapped correctly. The data upload can be scheduled as one-time or recurrent (automated) action.
| Table of Contents | ||||
|---|---|---|---|---|
|
Prerequisites
1. Ensure you have sufficient permissions to operate in ServiceNow or contact your ServiceNow administrator for assistance.2Define the scope of Cloudaware CMDB data for download into ServiceNow. Contact your dedicated account manager or tam@cloudaware.com to specify what data the data scope.
2. Define whether you would like to import* from Cloudawareuse your Google BigQuery* or a Cloudaware-managed** one.
*If you have a Google BigQuery table preconfigured , Cloudaware will provide you with the resulting file. Otherwise, Cloudaware provides in your Google environment, contact your dedicated account manager or tam@cloudaware.com to get the resulting file.
**Contact your dedicated account manager or tam@cloudaware.com for Google BigQuery table configuration. Once the table and the file are prepared, Cloudaware will provide a path to the file stored in Cloudaware's BigQuery tablefor further setup.
3. You must be ServiceNow Admin to run a Cloudaware script required for data import automation. Otherwise, contact your organization’s ServiceNow Admin for assistance.
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:
...
Check ServiceNow Documentation for instructions. Fill in the form:
...
| Note |
|---|
For one-time data import, values in the column Coalesce must be set to false. If you would like to import data and update records on a regular basis, define the unique field and set Coalesce to true for it. Learn more : https://www.servicenowelite.com/blog/2014/3/30/coalesce-methods here. |
Click Transform.
Specify Import set and Transform map values. Сlick Transform to proceed.
...
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.
...