Configuring a ServiceNow Data Source
Revision as of 14:10, 24 October 2012 by Gadiyedwab (talk | contribs)
Overview
Explore Analytics provides tight integration with ServiceNow to deliver superb data analysis, visualization, and reporting.
- Application-Level Data Access - Explore Analytics connects to your ServiceNow instance using a Web Service interface (aka SOAP). Connecting through the application ensures that you see the familiar data that you know in ServiceNow and respect all the security access control rules that are defined in the application.
- Optimal Performance - Whenever you access data, Explore Analytics pushes 100% of the data filtering, grouping, and aggregation to the ServiceNow application. By performing these operations at the application, Explore Analytics eliminate the need to pull large numbers of records from your ServiceNow instance.
- Friendly Table and Field Names - Explore Analytics shows the friendly labels that are assigned in ServiceNow so that you see names such as "Shopping Cart" and "Catalog Item" rather than "sc_cart" and "sc_cat_item" respectively.
- Friendly Filter Choices - ServiceNow makes extensive use of choice lists and Explore Analytics fully supports them so that you can construct a filter such as "Incident State = Resolved" rather than "state = 6".
- Reference Fields - Explore Analytics understands reference fields and uses them to relate tables to allow views that combine data from multiple tables.
- Display Field - Explore Analytics understands the concept of display field in ServiceNow and uses it in filters to allow you to naturally construct a filter such as "Caller = Beth Anglin" rather than "caller_id = 46d44a23a9fe19810012d100cca80666".
- Default View - ServiceNow defines a default view for each table. This view organizes selected fields in a tabular list. When you create a new view in Explore Analytics, it creates a list view that reflects the fields selected in the ServiceNow default view.