| Info |
|---|
Cloudaware can import CMDB data into the Google BigQuery for a temporary storage, 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. |
| Table of Contents | ||||
|---|---|---|---|---|
|
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 to ServiceNow CMDB 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.
Prerequisites
1. Ensure you have sufficient permissions to operate in ServiceNow or contact your ServiceNow administrator for assistance.2Define the scope of data to import from Cloudaware CMDB 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. Ensure you have sufficient permissions to operate in ServiceNow or contact your ServiceNow administrator 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:
...