How to Push Data from UCMDB to ServiceNow

1. Configure queries

   The CIs and relationships to be pushed to ServiceNow have to be queried from UCMDB using TQL queries. Create integration type queries to query the CIs and relationships that have to be pushed to ServiceNow.

   For the details of Push Query, you can refer to UCMDB Help > Developer Reference > Creating Discovery and Integration Adapters > Developing Push Adapters > Build an Adapter Package.

   An example of such a query, ServiceNowSampleQuery, is included with this integration package, and can be viewed in the Modeling Studio. For details on viewing queries in the Modeling Studio, see the Modeling section of the UCMDB Help.

2. Create XML mapping files

   For every query created in the step above, create an XML mapping file with exactly the same name (case-sensitive) as the integration query in the following directory:

   <UCMDB>\UCMDBServer\runtime\fcmdb\CodeBase\ServiceNowPushAdapter\mappings

   A sample mapping file for this integration, ServiceNowSampleMapping.xml, is provided out of the box with the package.

   For more information about mapping files, see the Developer Reference section of the UCMDB Help.

3. Create the integration point

   Define the integration point as follows:

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

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

      Ensure the Is Integration Activated option is enabled.

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

   4. In the Select Adapter list, select Push to Service-Now and click OK.

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

      Field	Value
      Service-Now Domain	Domain name used to access the ServiceNow instance. Usually service-now.com.
      Service-Now Instance	The ServiceNow instance being used. For the demonstration instance, enter demo.
      Port	Default: 443, for HTTPS.
      Protocol	HTTP or HTTPS.
      Proxy Server Name/IP	If an HTTP(S) proxy service is used to access the Internet, enter the proxy server name.
      Proxy Server Port	HTTP(S) proxy server port.
      Credentials ID	Define the ServiceNow instance user name and password in the Generic Protocol. For the demonstration website, use admin/admin. For credential information, see Supported Protocols.
      Retry Count	The retry count when the push failed. Default: 3.
      Retry Delay Seconds	The retry delay seconds when the push failed. Default: 5.
      Fail Bulk	Indicates whether to discard the whole bulk when there is inconsistent data. Default: True.
      Insert Multiple	Indicates whether to use the Insert Multiple function of ServiceNow. Using this function can accelerate the push integration. Default: False. If you want to use this function, first activate the API in ServiceNow, and then regenerate all JAR files that need the API from the new WSDL. For details, see How to generate JAR files for ServiceNow SOAP APIs.
      Insert Multiple Bulk Size	The Bulk size of the Insert Multiple. Default: 100.
      Data Flow Probe	Select the name of the Data Flow Probe to run this integration.

   6. Test the connection to the target CMDB server. If the connection fails, verify that the information provided is correct.

   7. Click OK to save the integration point.

   8. Add a new job definition to the integration point. Provide a name for the job definition and select the queries to use to synchronize data from UCMDB to ServiceNow. Define a synchronization schedule if required.

      Note Jobs can also be run without a schedule.

   9. Save the job definition, and then the integration point.
   10. Click to run a full synchronization for each job at least once.