Please use docs.servicenow.com for the latest documentation.

This site is for reference purposes only and may not be accurate for the latest ServiceNow version

Incident Ticketing Integrations

From Wiki Archive
Jump to: navigation, search
Note
Note: This article applies to Fuji and earlier releases. For more current information, see Incident Ticketing Integrations at http://docs.servicenow.com

The ServiceNow Wiki is no longer being updated. Visit http://docs.servicenow.com for the latest product documentation.

Overview

An incident ticketing integration exchanges ticket data between your ServiceNow instance and a third party system. The level of data and the direction of the data that is exchanged categorizes the integration as uni-directional or bi-directional.

The advantages of an incident ticketing integration include:

  • Establishing a ticket number that provides a unique key between systems
  • Synchronizing the systems so that notifications can be triggered
  • Transforming data for more uniform processing
  • Tracking ticket activity for accurate reporting


Integration Implementations


In a uni-directional integration, a third party system creates an incident ticket, passes data to ServiceNow, and receives a ticket ID back as confirmation. In a bi-directional integration, incident data is exchanged, synchronized, and updated while data is sent between the systems. For both integration types, ServiceNow recommends implementing a record-based log of the individual transactions for a given time period. In the event of an outage, a record-based log can tell you what data was exchanged, how it was transformed, when processing occurred, and if there were any errors. Record-based logs also allow you to run all the validation and transformation logic away from the main form, helping performance.

Before implementing your project, develop an Integration Plan in which all of the implementation aspects and requirements are defined. Developing the Integration Plan will help you review the current data, plan for future requirements, and identify and sequence project tasks.


Uni-directional Integration

Consider the requirements for an external, third party system to create tickets. Define what data needs to be sent (as a minimum) to create a ticket, and what validation is required. This way, a standard web service interface can be created and published. This integration responds with a ticket number on success, or with a structured error message for validation failures and processing issues. An advantage of this implementation is that you can publish once and reuse for multiple applications, provided the additional integrations follow the integration specifications. ServiceNow recommends creating a dedicated account for each interface to provide accountability and report user statistics, and using a simple connectivity Point of Contact (POC).

Integration Plan Contents

  • Firewall requirements
  • Protocols to be used
  • Required Middleware (for example, MS Biztalk)
  • Error messages
  • Validation Rules

Example Using Basic Authentication

This implementation responds to the third party system with the ticket ID. The Import Set tables function as a staging area for your data.

graphic depicting a uni-directional integration.

Example Using Import Sets

An implementation variation for the inbound path would be to use the Import Set Tables as interface tables. In this example, the Incident_Interface Table stores a history of data as it was received and before the data was transformed. The destination Incident Table could store a history of how the incident has changed over time and who changed it. The transform scripts would process the import set and the Business Rules would run on the target table.


graphic depicting a uni-directional integration.



Bi-directional Integration

A bi-directional integration exchanges data between your ServiceNow instance and a third party system so that incident ticket information is synchronized between the systems. This integration is more complex than a uni-directional integration because it requires comprehensive definitions of field mappings, the standardization of where transformations takes place (inbound, outbound, or both), consideration of the ownership of reference data, and how updates are done on an ongoing basis. Error handling must also be implemented. All of these implementation aspects would be included in the Integration Plan.

While bi-directional implementations are developed on their own merits, it is possible to develop a framework in ServiceNow that can be reused (for example, data driven validation rules).

Integration Plan Contents

  • Plan contents for all the aspects needed for a uni-directional integration
  • State models for each organization
  • Business Rule definitions for keeping the tickets synchronized
  • Requirements to store history of individual transactions. If this is a requirement, consider creating a interface table which is populated prior to creating and updating the destination table.
  • Transformation rules for all data elements
  • Time lines for when reference data is transported to the information system. Include requirements to do any transformations before sending the data to and from each system.
  • Statement of reference data ownership at all stages
  • Update schema definitions


Example Using Import Sets and Web Services

In this implementation, data authentication is done before insertion into the import set. Transform maps and scripts execute before the data reaches the Incident Table. The Incident Table is used to store the history of the incident records. For the outbound data path, the target table could trigger Business Rules before the data is queued in the outbound Web Service.


graphic of a bi-directional integration without an Interface Table.


Example Using Import Sets and the ECC Queue

An implementation variation for the inbound path would be to use an import set table (in our example, the Incident Interface Table) to store historical data. Data validation is also done at this time, and you can clear exceptions with processing or manual intervention. The Incident Table uses a Third Party Information table as a reference, and messages are generated based on Business Rules.

Implementing this type of integration involves a web-service component for third-party applications for inbound data. The ECC Queue is recommended for outbound data.


graphic of a bi-directional integration using an Interface Table and ECC Queue.