ServiceNow Tableau Integration Guide

Architecture Overview

Implementation Steps

(function process(request, response) {
    var tableName = request.pathParams.table || 'incident';
    var limit = parseInt(request.queryParams.sysparm_limit) || 1000;
    var offset = parseInt(request.queryParams.sysparm_offset) || 0;
    var fields = request.queryParams.sysparm_fields || '';
    
    var gr = new GlideRecord(tableName);
    if (request.queryParams.sysparm_query) {
        gr.addEncodedQuery(request.queryParams.sysparm_query);
    }
    
    gr.chooseWindow(offset, offset + limit);
    gr.query();
    
    var results = [];
    while (gr.next()) {
        var record = {};
        var elements = fields ? fields.split(',') : gr.getElements();
        elements.forEach(function(element) {
            if (typeof element === 'string') {
                record[element] = gr.getDisplayValue(element);
            } else {
                record[element.getName()] = gr.getDisplayValue(element.getName());
            }
        });
        results.push(record);
    }
    
    response.setStatus(200);
    response.setHeader('Content-Type', 'application/json');
    response.getStreamWriter().writeString(JSON.stringify({
        result: results,
        total: gr.getRowCount(),
        offset: offset,
        limit: limit
    }));
})(request, response);

SELECT sys_id, number, short_description, state, priority, 
       category, assignment_group.name as assignment_group_name,
       assigned_to.name as assigned_to_name,
       sys_created_on, sys_updated_on, resolved_at
FROM incident 
WHERE sys_created_on >= DATEADD(month, -12, GETDATE())
AND state IN ('1', '2', '3', '6', '7')
ORDER BY sys_updated_on DESC

// Resolution Time in Hours calculation
IF [State] = 'Resolved' OR [State] = 'Closed' THEN
    DATEDIFF('hour', [Sys Created On], [Resolved At])
ELSE
    DATEDIFF('hour', [Sys Created On], NOW())
END

// SLA Compliance indicator
IF [Resolution Time Hours] <= 24 AND [Priority] = '1 - Critical' THEN 'Met SLA'
ELSEIF [Resolution Time Hours] <= 72 AND [Priority] = '2 - High' THEN 'Met SLA'
ELSEIF [Resolution Time Hours] <= 168 AND [Priority] = '3 - Moderate' THEN 'Met SLA'
ELSE 'Missed SLA'
END

Common Use Cases

Troubleshooting

Pro Tips

• →Implement data extracts with incremental refresh using ServiceNow's sys_updated_on field as the refresh key, combined with a rolling 13-month window to balance historical analysis needs with performance optimization. This approach reduces extraction time from hours to minutes for large incident tables while maintaining sufficient historical context for trend analysis.
• →Create parameterized custom REST API endpoints that accept dynamic field lists and encoded queries, allowing Tableau users to modify data extraction scope without requiring ServiceNow admin intervention. Use URL parameters like sysparm_fields and sysparm_query to enable self-service analytics while maintaining security through proper role-based access controls.
• →Leverage ServiceNow's database views feature to pre-aggregate complex ITSM metrics like MTTR, SLA compliance, and assignment group performance, then connect Tableau directly to these views for near real-time dashboard performance. This approach offloads computational overhead to ServiceNow's database layer where it can be optimized and cached effectively.
• →Implement data quality monitoring by creating Tableau data sources that specifically track ServiceNow data completeness, accuracy, and freshness metrics, enabling proactive identification of integration issues before they impact business dashboards. Include checks for null values in critical fields, reference field resolution success rates, and extraction timestamp validation.
• →Use Tableau's Context Filters strategically with ServiceNow data by setting assignment group, date range, or priority filters as context to improve query performance and reduce database load on ServiceNow. This is particularly effective for large incident datasets where users typically analyze data within specific organizational or temporal boundaries.
• →Design dashboard actions that write back to ServiceNow through REST API calls, enabling Tableau users to update ticket assignments, add work notes, or change priority levels directly from analytical dashboards. Implement proper error handling and user feedback mechanisms to ensure data integrity and user confidence in the bidirectional integration.

Known Limitations

• —ServiceNow's REST API has default rate limiting of 1000 requests per hour per user, which can restrict large data extractions and require careful scheduling of multiple dashboard refreshes to avoid throttling. Organizations may need to request rate limit increases from ServiceNow support for high-volume analytics implementations.
• —The native Tableau ServiceNow connector doesn't support real-time streaming data and relies on periodic refresh cycles, introducing latency between ServiceNow updates and dashboard visualization that may not meet requirements for operational dashboards requiring immediate data visibility. Live connections can partially address this but impact performance significantly.
• —Complex ServiceNow data relationships, particularly many-to-many relationships through junction tables like task_ci relationships, require careful data modeling in Tableau and may necessitate custom REST API endpoints rather than relying on the standard connector. This increases implementation complexity and maintenance overhead for sophisticated CMDB analytics.
• —ServiceNow's reference field resolution can be inconsistent across different table types and customizations, sometimes requiring manual field mapping or custom scripting to ensure display values appear correctly in Tableau rather than cryptic sys_id values. This is particularly challenging for heavily customized ServiceNow implementations with custom tables and fields.
• —Large ServiceNow tables with millions of records may exceed Tableau's extract size limits or cause memory issues during processing, requiring data partitioning strategies or specialized hardware configurations for Tableau Server deployments. The 15GB extract size limit in Tableau can be reached quickly with comprehensive ITSM historical data.

Frequently Asked Questions