CMDB import integrations

A class of integrations with existing configuration management databases (CMDB) that imports CIs into ServiceNow CMDB.

CMDB import integrations use a combination of Import Sets, JDBC data sources, and a MID server (JDBCProbe). Example integrations that fall into this category include:
  • Altiris
  • Microsoft SCCM / SMS
Figure 1. CMDB Import

Import set data

This section of the application lists the import set tables that have been predefined for the external CMDB we are integrating with.

Selecting the tables will display the data already retrieved from a JDBC data source import, including the import set it is associated with, its state, as well as any information related to the transformation of the import set table data row.

Configuration

After enabling the plugin for an integration of this type, you will have a new application that consists of the following common modules. Next, install a MID Server in your environment that will be used to execute JDBC queries connecting with your database. This MID server will require port level access to your database. For example, SQL Server port 1433.

Figure 2. CMDB Import JDBC Integration
Table 1. CMDB Import JDBC Integration
Module Description
Setup
  • Configure the data sources from one form
  • Specify Database server settings and MID server
  • Test configuration
Scheduled Import Schedule the execution of the import or import immediately
Data Sources A list of the pre-configured data sources defining the external CMDB database
Progress A historical list of progress on scheduled imports
Transform History A historical list of transformations performed during scheduled imports

Setup

The Setup module allows the administrator to configure the JDBC data sources for the external CMDB tables. When you save the form, it will apply the changes to all data sources under this integration.
Figure 3. Integration Setup form
Table 2. Integration Setup form
Field Description
Database Server The database server host name of IP address, if executed via a MID server you have installed, this server needs to be accessible via your MID server
Database Name The database name for your CMDB
Database User ID The user ID used to connect to your CMDB database, it must have sufficient privileges to access data defined by your data sources. ServiceNow only supports SQL account credentials, you cannot authenticate using a domain user.
Database User Password The user password for the database user ID
MID Server The MID server to use for executing the database query on. You will want to install your own MID server behind your firewall if your ServiceNow instance does not have a direct JDBC connection to your database server
Status The current status of the MID server: Up or Down

Test Data Source Connections

After your setup values are inputted and saved, a Test data source connections UI action is available. Executing this action will perform a database table row count on each table and query configured in each data source. The following image shows a successful test.
Figure 4. Successful Test