Integration of Tableau and Qlikview With ServiceNow Using Snow-Mirror

Introduction

• Many business organizations have successfully made use of ServiceNow to automate their IT operations and planning to integrate ServiceNow with external BI reporting solutions for better reporting experience.
• Standard ServiceNow platform has basic reporting capabilities and need is to utilize external reporting to get deeper analytics and drill down insight into the business with appropriate and required metrics.
• ServiceNow has Performance Analytics application, which is capable of much more than the general out-of-box reporting. It does produce fairly good reports but also has its limitations like Data outside of ServiceNow cannot be included directly into the reports, you need to create tables or applications within ServiceNow and implementing different integration methods to migrate or import external data into ServiceNow Platform.

Benefits of External Reporting in Tableau OR Qlikview

• Customized, Colorful, Dynamic and Interactive Visuals
• Drill Down Analytics In Single Click
• Operational & Analytical Insights
• Blend Diverse Data Sets
• Architecture Agnostic Reports
• Time Reduction in Report Development

Integration Methods

Snow-Mirror Data Replication Process

Replicate the ServiceNow data into a traditional database and connect Application to that database.

1. Create a Database
2. Install SnowMirror
   
3. Configure and Test Database
   
4. Select Table to Mirror in DB
   
5. Synchronize the Tables
6. 
7. Synchronization Status
8. Data from ServiceNow in Mirrored Database

TABLEAU with ServiceNow using Different Connection Methodologies

1. ServiceNow via ODBC connection

The CData ODBC drivers for ServiceNow enables you to integrate ServiceNow data also enable you to access live ServiceNow data in Tableau.

2. ServiceNow ITSM Connector

Start Tableau and under Connect, select ServiceNow ITSM.

Then do the following:

• Specify Login credentials of your ServiceNow instance, user-name and password for a local ServiceNow account.
• Sign In and apply filter type to filter relative Date range or fixed date range, and then specify the range and connect to the instance.

3. SnowMirror | The Smart Data Replication Tool For ServiceNow

Replicate the ServiceNow data into a traditional database like SQL Server and connect Tableau to that database using MS-SQL Server Connection.

1. Using ServiceNow ITSM Connector
   
2. Specify Login Credentials
   
   
   

QLIKVIEW with ServiceNow using Different Connection Methodologies

1. Connect to and Query ServiceNow Data in QlikView over ServiceNow ODBC Driver
2. Connect to ServiceNow as an ODBC Data Source

Configure the database using ODBC driver administrator provide database credentials and build connector, using ODBC connection Qlikview will automatically generate connection string and then select tables to fetch data in Qlikview.

3. SnowMirror | The Smart Data Replication Tool For ServiceNow

Replicate the ServiceNow data into a traditional database like SQL Server and connect QlikView to that database using MS-SQL Server Connection.

SnowMirror Core Features:

• ServiceNow Data Synchronized In Traditional Database
• Synchronize Relevant Data Required For Reporting
• One Can Perform ETL Operations on Mirrored Database
• Fast Response Time