How to import data from third party to CMDB router table?

[jyothi priya2]

Hi Team,

While importing data from our source table to CMDB table through API, Able to insert and update records for some CMDB classes like computer, Linux Server, Windows Server....

But not able to create and update for some classes like router , switches ,networks.....

Getting Misssing dependancy

dentification_engine : logId:[07768fd92ffc] MISSING_DEPENDENCY In payload no relations defined for dependent class [cmdb_ci_router] that matches any containment/hosting rules: [cmdb_ci_router >> Hosted on >> cmdb_ci_logical_datacenter]. Add appropriate relations in payload for '{"className":"cmdb_ci_router","values":

Provide the solution as soon as possible

@Chuck Tomasi , @Steven bell

[Community Alums]

Hi @jyothi priya ,

Use Service Graph Connectors to import and integrate third-party data into CMDB classes and properties. You can use predefined Service Graph Connectors for common applications from the ServiceNow Store. You can also use IntegrationHub ETL to create new ETL transform maps or edit existing ones.

Related ServiceNow® Store apps and reference information:

• CMDB schema model: A collection of class diagrams and class attributes for key CMDB classes.
• CMDB tables descriptions: Descriptions of key CMDB tables in the base system.
• CMDB CI Class Models: A ServiceNow Store app that adds class models that extend the base CMDB class hierarchy. This includes class descriptions, identification rules, identifier entries, and dependent relationships if applicable. You can then use the added classes as any other CMDB base class.
• Populating the CMDB: Information about the various options for populating the CMDB.
• Discovery patterns: A ServiceNow Store app that provides a library of Discovery patterns for discovering specific devices and applications in the industry.

• IntegrationHub ETL (2.2.1)

  Use the IntegrationHub ETL store app to create and manage ETL transform maps, which integrate third-party data into the CMDB without compromising the integrity of the CMDB. IntegrationHub ETL provides a simplified user interface that guides you through the integration process end-to-end, including a test integration run of sample data.

• Integration Commons for CMDB (2.8.0)

  The Integration Commons for CMDB store app contain a set of RTE (Robust Transform Engine) transforms and script includes. Use these transforms and script includes to standardize the values stored in the CMDB by different data integrations or by changes.

• Service Graph connector for Observability AppDynamics (1.1.0)

  Use the Service Graph connector for Observability AppDynamics to ingest CMDB data from an AppDynamics installation using REST APIs. Push events from AppDynamics into ServiceNow with Event Management.

• Service Graph connector for AWS (1.4.2)

  Use the Service Graph connector for Amazon Web Services (AWS) to securely bring in AWS data into your ServiceNow instance.

• Service Graph connector for Observability Dynatrace (1.4.0)

  Use the Service Graph connector for Observability Dynatrace to ingest CI data, events, metrics, and logs from Dynatrace into your ServiceNow instance.

• Service Graph connector for ExtraHop (2.0.3)

  Use the Service Graph connector for ExtraHop to pull data from the ExtraHop application into your ServiceNow instance.

• Service Graph connector for Microsoft Intune (2.1.2)

  Use the Service Graph connector for Microsoft Intune to pull data from the Microsoft Intune application into your ServiceNow instance.

• Service Graph connector for Jamf (2.10.0)

  Use the Service Graph connector for Jamf to pull data from Jamf into your ServiceNow instance.

• Service Graph connector for Microsoft SCCM (3.2.1)

  Use the Service Graph connector for Microsoft System Center Configuration Manager (SCCM) to pull data from SCCM into your ServiceNow instance.

• Service Graph connector for SolarWinds (2.3.0)

  Use the Service Graph connector for SolarWinds to pull in data from the SolarWinds software into your ServiceNow instance.

• Service Graph connector for Tanium (1.3.1)

  Use the Service Graph connector for Tanium to bring in hardware, software, and software usage data from a Tanium environment into your ServiceNow instance.

• Service Graph connector for VMware Workspace ONE UEM (1.5.0)

  Use the Service Graph connector for VMware Workspace One UEM to pull data from Workspace One into your ServiceNow Instance.

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[jyothi priya2]

Hi Sandeep,

Thank you very much for your quick response, But can you please tell exactly what will be the exact attributes passed through CMDB instance API to insert record into CMDB Router class.

Regards, 

Jyothi.

[Scott Halverso1]

I'd recommend using the Identification Simulation from the left nav to test single payloads and troubleshoot the results.

In your screenshot the error is from the Identification and Reconcilation engine as a value for discovery_source is required.   

For the router CI, my guess is you would want to use the cmdb_ci_ip_router class rather than the cmdb_ci_router class.

Using the CI class manager you can see the cmdb_ci_router class has a required relationship