Introduction

This document describes how to connect to ServiceNow from Denodo Virtual DataPort.

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.

Denodo also provides a ServiceNow data source type to allow for quick access to ServiceNow; in particular to Product Catalog, Incident, and Problem information.

Using a ServiceNow data source

• In the Denodo Web Design Studio, click on “File > New ”.

• Then, the Denodo Web Design Studio will display the dialog for which type of data source to create. Type “servicenow” and click on the option for ServiceNow.

• The below tab will appear for inputting the ServiceNow information.

• Put in the correct information and then click  “Execute Import”.

• After this, the views for pulling the information particular to Product Catalog, Incident, and Problem information will be created.

Using a JSON data source

• From the Denodo Web Design Studio, create a new JSON data source by navigating to  “File > New”.

• Then, the Denodo Web Design Studio will display the dialog for which type of data source to create. Type “json” and click on the option for HTTP/OpenAPI.

• The created data source can be seen below.

• In the “Authentication” section, choose the authentication as “Basic” in the drop-down list and specify the login and password to connect to the ServiceNow.

• Then, click on ‘Test Connection’ and if the connection is successful, click on “Save”.

• Once the data source is created, click “Create base view” to create a base view to introspect source metadata available through the Data Source.

• The below popup will appear where you can place a relative link if needed.

• Then the Denodo Web Design Studio will display the section where you can change the “tuple root” of the base view if you only want to access a portion of the JSON document. We recommend leaving the JSON root checkbox selected. Click the “Create Base View” button to create the base view.

• Click the “Create Base View” button to create the base view.

• Once the base view is created, you are able to select the data from ServiceNow through the base view.

References

JSON Sources

REST API Reference