CMDBTransformUtil Help

[Ram117]

Experts,

I have a requirement to populate CMDB from a third party application.I am using import set API to do this.

I have 2 different classes of CI's coming in.

1. Switch 

2. Load Balancer

I have created 2 transform maps, one is to cmdb_ci_netgear and other to cmdb_ci_lb . 

Now, I have CI's which are already existing in ServiceNow CMDB  and want to make sure the identification and reconcilation process works correctly inorder to avoid duplicates. 

I also have to make sure, I do not update any values which are already existing on a record while making CI updates.

My Transform Map for Netgear CIs mapping looks as below,

Field Maps : ( Do I need to still specify the coalesce while using the CMDBTransformUtil API call ? )

To compare existing values, i have the field level script on each row map

Transform Scripts

• CMDBAPI Call ( Identify and reconcile )
• Ignore =true , if CI Class is not switch

Question

1. CMDBTransformUtil fails with the below error while trying to test the update of an existing record

Test Payload :

  {
    "u_name": "jen002-wlc-001",
    "u_site_code": "",
    "u_discovereddescription": "DMPU2016 1.22.5.23556",
    "u_ci_type": "switch",
    "u_discoveredcontact": "supportt@test.com",
    "u_domainname": "",
    "u_vendor": "",
    "u_nodefamily": "Test Corporation",
    "u_primarydnsname": "",
    "u_primarymacaddress": "137.x.x.x",
    "u_sys_object_id": ".1.3.6.1.4.1.10418.18.1.101",
    "u_discovered_os_version": ""
  }

Any guidance is appreciated .

thx

ram

[Patrick DeCarl1 · Accepted solution]

If you are doing this on Orlando use the new feature call "Use IntegrationHub ETL to Import Data Lab". Link below is free training. This is the new way to import data into the CMDB. 

https://nowlearning.service-now.com/lxp?id=overview&sys_id=a4c0965adbc81810785e2a59139619ad&type=course

[Ram117]

I am able to complete my requirement with the help of transform maps, but didnt use CMDBTransformUtil.

@Patrick DeCarlo  Thank you for pointing me to Integration Hub ETL, was able to take a look at it and complete the learning.