Last modified on: 07 Jan 2019
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.
The ServiceNow template: the VQL and properties files, configures the access for the following functionalities of ServiceNow:
Incident in ServiceNow
Before importing the VQL in Denodo, you have to set the following parameters defined in the SERVICENOW.properties file:
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
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
Now, you can execute queries over the ServiceNow base views that have been created:
ServiceNow query
ServiceNow results