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.
| Data source | Staging table | Target tables |
|---|---|---|
| SG-SolarWinds MS SQL Servers | sn\_solarwinds\_inte\_solarwinds\_cmdb\_ms\_sql\_servers | HardwareMS 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 PackageComputer |
| SG-SolarWinds IIS | sn\_solarwinds\_inte\_solarwinds\_cmdb\_iis | HardwareIIS Virtual Directory Microsoft IIS Web Server |
| SG-SolarWinds Disk | sn\_solarwinds\_inte\_solarwinds\_cmdb\_disk | HardwareDisk |
| SG-SolarWinds Network Adapter | sn\_solarwinds\_inte\_solarwinds\_cmdb\_network\_adapter | HardwareNetwork Adapter IP Address |
| SG-SolarWinds Cloud Volumes | sn\_solarwinds\_inte\_solarwinds\_cmdb\_cloud\_volumes | Storage VolumeLogical Datacenter VM Instance |
| SG-SolarWinds Cloud | sn\_solarwinds\_inte\_solarwinds\_cmdb\_cloud | ImageHardware 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.