Connecting to ServiceNow

The Sisense ServiceNow connector is a standalone connector that allows you to import data from ServiceNow’s API into the ElastiCube Manager. After you have downloaded and installed the connector, you can connect through a connection string you provide Sisense in the ElastiCube Manager. The connection string is used to authenticate users who connect to the ServiceNow APIs. To obtain a connection string, you will need to register a ServiceNow app.

Once you have connected to ServiceNow, you can import a variety of tables from the ServiceNow API.

This page describes how to install the ServiceNow connector, how to connect to ServiceNow with a connection string, and what tables you can import into the ElastiCube Manager:

Installing the ServiceNow Connector

Sisense provides the ServiceNow connector as a standalone connector that you can download and add to your list of default Sisense connectors.

To install the ServiceNow connector:

  1. Download the ServiceNow installation file.
  2. Open the installation file and click Install.
  3. After the installation process is complete, click Close.
    The ServiceNow connector is displayed in the ElastiCube Managerunder Add Data > Web Services.

Connecting to the ServiceNow REST API

To access ServiceNow’s REST API from the ElastiCube Manager, you must provide valid Oauth ServiceNow credentials through a connection string. These credentials are provided by ServiceNow when you create an application.

After you receive your credentials from ServiceNow, you can create the connection string and provide Sisense with it to connect to your data.

Registering an App

Follow the steps below to obtain the OAuth client credentials, the OAuthClientId and OAuthClientSecret:

  1. In the Navigator, click System OAuth > Application Registry.
  2. Click New and then click Create an OAuth API Endpoint for External Clients.
  3. Select the Active check box and enter the details for your app.

Adding ServiceNow Tables to your ElastiCube

Sisense uses connection strings to connect to ServiceNow and import data into the ElastiCube Manager. Each connection string contains authentication parameters that the data source uses to verify your identity and what information you can export to Sisense.

The connection string to ServiceNow is in the following format:

jdbc:servicenow:APIKey=xxxxxxxxxxxxxxxxxxxxxx;

For example:

jdbc:servicenow:InitiateOAuth=GETANDREFRESH;Instance=xxxxxxxxxx;OAuthClientId=xxxxxxxxxxxx;

OAuthClientSecret=xxxxxxxxx;Username=xxxxxxxxxx;Password=xxxxxxxxxxxxxxx;

Your ServiceNow connection string should include the following parameters, separated by a semicolon ';'.

If you have any issues connecting to your data source, see Troubleshooting JDBC Data Connectors.

To add ServiceNow data:

  1. In ElastiCube Manager, click Add Data and then, ServiceNow. The Connect to ServiceNow window is displayed.
  2. In Datasource Connection String, enter your connection string.
  3. Click Connect to Server. ServiceNow is displayed in the Select Database list.
  4. Click OK. Sisense connects to ServiceNow and displays a list of tables available for you to import.
  5. Select the relevant tables and click Add. The tables are displayed in the ElastiCube Manager.

ServiceNow Tables

ServiceNow’s RESTful APIs expose the following ServiceNow tables that you can import into the ElastiCube Manager through the Sisense ServiceNow connector:

Available Tables

Name Description
ast_contract The ServiceNow table ast_contract.
ast_license_base The ServiceNow table ast_license_base.
change_request The ServiceNow table change_request.
cmdb_ci The ServiceNow table cmdb_ci.
cmdb_metric The ServiceNow table cmdb_metric.
cmn_building The ServiceNow table cmn_building.
cmn_context_help The ServiceNow table cmn_context_help.
cmn_cost_center The ServiceNow table cmn_cost_center.
cmn_department The ServiceNow table cmn_department.
cmn_location The ServiceNow table cmn_location.
cmn_map_page The ServiceNow table cmn_map_page.
cmn_notif_device The ServiceNow table cmn_notif_device.
cmn_notif_device_variable The ServiceNow table cmn_notif_device_variable.
cmn_notif_grmember The ServiceNow table cmn_notif_group.
cmn_notif_group The ServiceNow table cmn_notif_message.
cmn_notif_message The ServiceNow table cmn_notif_message.
cmn_notif_service_provider The ServiceNow table cmn_notif_service_provider.
cmn_other_schedule The ServiceNow table cmn_other_schedule.
cmn_relative_duration The ServiceNow table cmn_relative_duration.
cmn_schedule The ServiceNow table cmn_schedule.
cmn_schedule_blackout The ServiceNow table cmn_schedule_blackout.
cmn_schedule_condition The ServiceNow table cmn_schedule_condition.
cmn_schedule_maintenance The ServiceNow table cmn_schedule_maintenance.
cmn_schedule_page The ServiceNow table cmn_schedule_page.
cmn_schedule_span The ServiceNow table cmn_schedule_span.
cmn_timeline_page The ServiceNow table cmn_timeline_page.
cmn_timeline_page_style The ServiceNow table cmn_timeline_page_style.
cmn_timeline_sub_item The ServiceNow table cmn_timeline_sub_item.
diagrammer_action The ServiceNow table diagrammer_action.
expert_panel The ServiceNow table expert_panel.
item_option_new The ServiceNow table item_option_new.
question The ServiceNow table question.
sc_category The ServiceNow table sc_category.
sc_cat_item The ServiceNow table sc_cat_item.
sla The ServiceNow table sla.
sysauto The ServiceNow table sysauto.
sysauto_script The ServiceNow table sysauto_script.
syslog The ServiceNow table syslog.
sysrule The ServiceNow table sysrule.
system_db_object The ServiceNow table system_db_object.
system_dictionary The ServiceNow table system_dictionary.
system_documentation The ServiceNow table system_documentation.
system_import_set_row The ServiceNow table system_import_set_row.
system_script_client The ServiceNow table system_script_client.
system_ui_policy The ServiceNow table system_ui_policy.
system_ui_policy_action The ServiceNow table system_ui_policy_action.
task The ServiceNow table task.
v_field_creator The ServiceNow table v_field_creator.

Versions

Version Release Date Improvements
6.6.1.47 June 15, 2017 400 Bad Request error has been fixed
6.6.0.23 March 16, 2017 General Release
6.5.1.17 January 16, 2017 General Beta release