Denodo ServiceNow Templates - Quick guide

Last modified on: 07 Jan 2019

Download original document


Overview

ServiceNow is an IT management tool that allows organizations to manage all aspects of their IT infrastructure including asset management, IT Service Management (Incident management, problem management, change management, etc.), CMDB (component management database) management of IT assets and devices, etc.

You can configure Denodo to retrieve data from ServiceNow by creating JSON data sources and base views in Denodo using the ServiceNow REST API.

As ServiceNow manages a very large amount of data and views, it may be a hard work to add all the required data sources and base views into Denodo. In order to make this process easier and faster, we distribute a template: a set of predefined VQL and properties files. You just have to configure a few parameters in the properties file and import these files in your Denodo server to get access to ServiceNow.

ServiceNow templates

The ServiceNow template: the VQL and properties files, configures the access for the following functionalities of ServiceNow:

  • Incident

  • Problem

  • Product Catalog

Incident in ServiceNow

Import VQL

Before importing the VQL in Denodo, you have to set the following parameters defined in the SERVICENOW.properties file:

  • User: the username in ServiceNow

  • Password: the password in ServiceNow

  • Encrypted: write ENCRYPTED if you have set an encrypted password. Otherwise, leave this field empty.

  • BaseUrl: fill the name of your ServiceNow instance.

Configuration properties

Once you have set the properties file, you only have to import both the properties and the VQL files using the Import option of the VDP Administration Tool:

Import option in VDP

Import wizard in VDP

Refresh

After the importation finishes, refresh the Server Explorer by selecting File > Refresh and you will be able to see the data sources and base views for accessing to ServiceNow:

ServiceNow data sources and base views

Query

Now, you can execute queries over the ServiceNow base views that have been created:

        ServiceNow query

ServiceNow results