topic Re: Pulling data from ServiceNow to QlikSense in App Development

Pulling data from ServiceNow to QlikSense

Mon, 22 May 2017 13:20:06 GMT

Hi,

I need to connect ServiceNow to QlikSense and need to develop reports on ServiceNow data. When I searched for proper connections I came across few solutions.

1. Using REST Connector and pulling data in xml file format and working on that (not sure about limitations and xml format)

2. Using ODBC connection and writing queries to pull data (we can pull only limited rows at a time thru this and not sure about connection configuration)

Can someone please suggest the better way to pull data from ServiceNow to QlikSense.

Thanks in Advance!

Re: Pulling data from ServiceNow to QlikSense

duffman1968 — Tue, 23 May 2017 21:09:58 GMT

Hey Kumari,

I have used your option 1, you are on the right path.

Below are some points that helped me with method 1:

Acquire a 'service' account credential from you ServiceNow admin. This credential should have access to all data.
Use this credential to configure the REST connector(s).
I created multiple connectors for what entities I wanted in my data model.
- i.e. URL for Incident https://<your Service-Now site>/api/now/table/incident (We use ServiceNow express edition)
I then created scripts in the Data Load Editor (DLE)
- I inserted scripts from each connectors select data, data preview
- I then modified these scripts accordingly to complete my data model
Created some visualizations around the data model

This worked well for me. Let the REST connector(s) do the work, they are powerful. Just data preview and see what it did for you. Hope this helps!

Best Regards,

Patrick

Re: Pulling data from ServiceNow to QlikSense

Wed, 24 May 2017 18:38:17 GMT

Thank You so much Patrick.

Re: Pulling data from ServiceNow to QlikSense

duffman1968 — Fri, 26 May 2017 19:09:23 GMT

You are welcome!

Regards,

Patrick

Re: Pulling data from ServiceNow to QlikSense

madan0717 — Mon, 30 Oct 2017 19:13:27 GMT

Hi Patrick,

I'm using ServiceNow Rest API to pull the data. It seems there is a limit on Data extraction from servicenow to QLIK. How did you create multiple connections to pull the entire data set from a table( Example: Incident Table).Please let me know.

Thanks,

Madan

Re: Pulling data from ServiceNow to QlikSense

Demlet — Mon, 11 Dec 2017 21:57:13 GMT

Hi Patrick,

Thanks for the useful information. Do you have any information regarding what pagination type ServiceNow uses?

For example lets say I am using i.e. URL for Incident https://<your Service-Now site>/api/now/table/incident

Which pagination type do you use for more results to return? Any tips for setting this up would be greatly appreciated.

Thank You.

Derek

Re: Pulling data from ServiceNow to QlikSense

Deanbrian1976 — Thu, 10 Jan 2019 19:18:37 GMT

Do we know what type of Role Access an account would need to pull the data from servicenow to Qlik.

Re: Pulling data from Service Now to Qlik

Deanbrian1976 — Thu, 10 Jan 2019 19:19:11 GMT

Do we know what type of Role Access an account would need to pull the data from servicenow to Qlik.

Re: Pulling data from ServiceNow to QlikSense

pateldixitj1986 — Tue, 15 Jan 2019 18:37:47 GMT

You will need account with the itil role. Thats what we are using.

Re: Pulling data from ServiceNow to QlikSense

pavelmuller — Mon, 04 Feb 2019 09:09:58 GMT

Hi,

I think that it is not a good idea to connect the reporting tool directly to a live ServiceNow instance. Not only it can affect the production environment but it will be simply too slow to download high volumes of data for each report execution.

The preferred way is to build an on-premise read-replica (i.e. a mirror database) and connect QlikSense to this local database. It will be much faster and your ServiceNow won't be affected.

You could use tools such as SnowMirror to extract the data from ServiceNow (or Salesforce).

http://www.snow-mirror.com/

Kind Regards,
Pavel

Re: Pulling data from ServiceNow to QlikSense

srilakshmi_as — Sat, 13 Jul 2019 02:51:23 GMT

i am getting the service now data with the same procedure in to qliksense.

But then it works in qliksense desktop.

When i am trying to create a connection in actual application it wont allow me.

Re: Pulling data from ServiceNow to QlikSense

jonathanhvid — Thu, 06 May 2021 13:32:56 GMT

Hi,

I know this might be somewhat late, but the company I work for, has developed a connector specifically for this, which you might want to check out:

ServiceNow Connector | Stretch Qonnect

Hope this helps.