How To Guide: ServiceNow Connector Plugin

 

November 25, 2016  |  By Dale Rankine

ServiceNow is a cloud-computing company that specializes in IT Service Management and provides forms-based workflow application development.

Reekoh has developed the ServiceNow Connector Plugin that enables you to integrate with ServiceNow using the Table REST API to synchronise device records and device/sensor data to ServiceNow seamlessly.

Let’s go through the guide below to see how this plugin works.
 
To start off, login to your Reekoh account and then navigate to Devices > Register New Device. Complete the form that comes next. You can also use any existing registered device in your instance, if you have one.
 
N1
 
After registering your device, search and install the plugins you will be using by navigating to Plugins > Plugin Store. For this demo, we’ll be using ServiceNow Connector and MQTT Gateway (this will enable you to ingest device data via MQTT protocol).
 
N1
 
Next is to create your topology by navigating to Topologies > Build New Topology. Complete the form that comes next.
 
N1
 
Once your topology is set, configure your installed plugins by locating their respective categories in your topology. For example, the ServiceNow plugin should be configured under the Connector category. Click Configure New, and then complete the form that comes next.
 
N1
 
N1
 
Upon reaching the Configure Plugin page, you will be required to provide the following: Instance URL, Username, Password, Device Table Name, and Data Table Name. To get these details, you need to create an account in the ServiceNow Developer console.
 
N1
 
Once your account is active and you’re logged in, navigate to Manage > Instance and then click Request Instance. Complete the wizard that comes next.
 
N1
 
N1
 
Once your request has been processed and completed, it will automatically generate the Instance URL, Username, and Password.
 
N1
 
You will be required to change your password upon initial access to your instance. To do this, click the generated instance url and then complete the wizard that comes next. Take note of the new password since this will be the one you’ll use when you configure your plugin.
 
N1
 
After you’ve changed your password, you need to create a table for your data and device. Let’s create the Data Table first. Type tables in the Filter Navigator and then click the corresponding result.
 
N1
 
Click New, and then complete the form that comes next. Note that your table name will be prefixed with u_. For example, if you enter Data as the table label, the table name defaults to u_data.
 
N1
 
N1
 
You should be able to see your data table once the form is submitted. Do the same procedure for Device Table.
 
N1
 
Once your data and device tables are ready, next is to create a column for your table. Let’s start first with data table. Navigate to your data table, and then click New in the Table Column section. Complete the form that follows.
 
N1
 
Similar with table name, the column name will be prefixed with u_. For example, if you enter Description as the column label, the column name defaults to u_description.
 
N1
 
You should be able to see your added column once the form is submitted. Do the same procedure for the column(s) of your device table.
 
N1
 
Once your ServiceNow settings are complete, go back to the Configure Plugin page of your ServiceNow plugin to continue with completing the form.
 
N1
 
After you’ve configured both plugins, you should be able to see them in your topology.
 
N1
 
Next, download or install any MQTT simulator from the Chrome Web Store to be able to send device data to the ServiceNow platform. We’ll be using MQTTLens for this example. Open the application, and then create a connection for your device by completing the form that comes next.
 
N1
 
N1
 
Once connection has been established, enter or paste your JSON data in the Message field; then supply any Topic for your data. Click Publish to send it to the ServiceNow platform.
 
N1
 
To check if your data has been received, go back to your ServiceNow instance and then search for the data table you’ve created earlier. You should be able to see the data you’ve sent.
 
N1
 
For more info on how to customise your Reekoh topology, you can check out our Starter Guides in the Reekoh Help Center.