How to Populate UCMDB with Data from ServiceNow

1. Prerequisites

   Install the ServiceNow_pull_integration_patch.zip patch on the Data Flow Probe. Note the address and port of the HTTP/HTTPs proxy server between the Probe machine and the ServiceNow instance.

   To install the patch, extract the patch archive into the Probe installation folder. As a result, the folder <probe_installation_folder>/jython/lib/suds is created, and two files, <probe_installation_folder>/jython/lib/httplib.py and <probe_installation_folder>/jython/lib/urllib2.py should be updated. If UCMDB is on version 10.22 or later, make sure that these two files are not overwritten. You do not need to restart the Probe.

   Patch content:

   • jython/lib/suds – a library to work with WSDL-based web-services.
   • jython/lib/suds/mx/appender.py – this script is modified to properly handle ServiceNow query parameters, such as _use_view,and _encoded_query. See line 191.

   • jython/lib/httplib.py, jython/lib/urllib2.py – modified Jython 2.5.3 scripts, the following patch is applied:

     http://bugs.python.org/issue1424152

2. Create XML Mapping Files.

   The XML mapping file describes the topology that should be pulled from the ServiceNow instance and how it should be mapped to the UCMDB class model. Place one or more mapping files into the folder <probe_installation_folder>\runtime\probeManager\discoveryConfigFiles\ServiceNow on the Probe.

3. Create credentials for the ServiceNow Protocol.

   Create entries only for the username and password fields.

4. Create the Integration Point.

   Define the integration point as follows:

   1. In UCMDB, go to Data Flow Management > Integration Studio.

   2. Click the New Integration Point button.

   3. In the New Integration Point dialog box, enter a name and description for the integration point.

   4. In the Adapter field click the Select Adapter button.

   5. In the Select Adapter list, select ServiceNow to UCMDB and click OK.

   6. In the Adapter Properties section, enter the following required properties:

      Field	Value
      Chunk size	The number of record to pull from ServiceNow per web service call. Default: 200. It is not recommended to change this value. Changing this value may affect the performance.
      Credentials ID	Select the credential entries you created in step 3 for the ServiceNow Protocol.
      HTTPs Proxy	Enter the IP address of the proxy server used to connect to the ServiceNow instance. If you are not using a proxy, leave this field empty.
      Mapping File	The name of the XML mapping file you created in step 2, located in the \discoveryConfigFiles\ServiceNow folder. Leave blank if you want all the mapping files in this folder to be processed.
      Remote JVM Class Path	The Remote JVM Class Path. Default: %minimal_classpath%;../content/lib/nnm/ucmdb_wrapper.jar;../runtime/probeManager/discoveryResources/IntegrationAPI.jar
      Run in Separate Process	Indicated whether to run in a separate process. Default: true.
      ServiceNow Instance URL	The address where the ServiceNow instance can be reached, including the protocol prefix and port. For example, https://demo.service-now.com.
      Data Flow Probe	Select the Probe on which the integration will run.
      Default owner name	The name of the owner to be used for CIs from population and federation when no owner is defined.
      Trigger CI Instance	Select the DataFlowProbe CI, which refers to the same Probe as Data Flow Probe property above.

   7. Click OK to save the integration point. At this point, a default integration job definition is automatically created.

5. Define a synchronization schedule for the integration job, if desired.

   Jobs can also be run manually, without a schedule.

6. Run full data synchronization.

   Click to synchronize all data.