Data mapping for SolarWinds

Data from the SolarWinds data sources is mapped and transformed into the ServiceNow CMDB Configuration Item (CI) class definitions using the Robust Transform Engine (RTE). Data is inserted into the ServiceNow CMDB using the Identification and Reconciliation Engine (IRE).

Data mapping for SolarWinds

When you complete setting up the connection, you can configure the integration to periodically pull data from SolarWinds.

The following table lists the data sources, the staging tables, and the target tables as CMDB CI classes for SolarWinds.

Table 1. Data mapping for SolarWinds

Data source	Staging table	Target tables
SG-SolarWinds MS SQL Servers	sn_solarwinds_inte_solarwinds_cmdb_ms_sql_servers	Hardware MS SQL Database MSFT SQL Instance
SG-SolarWinds CPU	sn_solarwinds_inte_solarwinds_cmdb_cpu	Computer
SG-SolarWinds Hardware	sn_solarwinds_inte_solarwinds_cmdb_hardware	Software Package Hardware
SG-SolarWinds Software	sn_solarwinds_inte_solarwinds_cmdb_software	Software Package Computer
SG-SolarWinds IIS	sn_solarwinds_inte_solarwinds_cmdb_iis	Hardware IIS Virtual Directory Microsoft IIS Web Server
SG-SolarWinds Disk	sn_solarwinds_inte_solarwinds_cmdb_disk	Hardware Disk
SG-SolarWinds Network Adapter	sn_solarwinds_inte_solarwinds_cmdb_network_adapter	Hardware Network Adapter IP Address
SG-SolarWinds Cloud Volumes	sn_solarwinds_inte_solarwinds_cmdb_cloud_volumes	Storage Volume Logical Datacenter VM Instance
SG-SolarWinds Cloud	sn_solarwinds_inte_solarwinds_cmdb_cloud	Image Hardware Type Availability Zone Logical Datacenter Computer Cloud Network VM Instance Cloud KeyPair Cloud Subnet Cloud Service Account

You can use the IntegrationHub ETL app to view the data maps. See IntegrationHub ETL for more information.