topic Re: Qlikview & Service now connection in QlikView

Qlikview & Service now connection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I use this for my connection & it says it connects successfully

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://xxx.service-now.com/web/;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=UYLHbAZGQRNITcAHWRLA;XPassword=JdDMdSUEQLYGXZdOPTcIWSIGTKYYWSNOGbbEXRVMVJJKSSUEFJMQM;";

Use the url & windows authentication but how can I see the tables to pull from ServiceNow into Qlikview to make a chart. What am I doing wrong or not doing or whatever....

Re: Qlikview & Service now connection

Qrishna — Sat, 17 Mar 2018 01:25:34 GMT

Hey thats just the connection string to a datawarehouse/database.

Again, even though you are connected,you might not have access to all the tables.check with admin if you have access to all tables.For pulling data in qlik you might just need READ access.

Re: Qlikview & Service now connection

Anonymous — Thu, 22 Mar 2018 19:15:05 GMT

@Krishna Nagulapally

I confirmed I have read access to the table but once I connect to the db with my connection how do I pull in that table, a load statement? Do you have any examples?

Re: Qlikview & Service now connection

Anonymous — Thu, 22 Mar 2018 20:36:58 GMT

How can I connect to a table named “sc_req_item”

Jude Shoop

Sr. Analyst – Technical Information Applications

Arkema Inc.

900 First Avenue

King Of Prussia, PA 19406

Office: 610.205.7194

Mobile: 610.304.5608

Re: Qlikview & Service now connection

Qrishna — Tue, 03 Apr 2018 15:38:47 GMT

Once you have the access,

open script editor, Connect to the desired database,once connected,load table using the regular methods.

Re: Qlikview & Service now connection

johnca — Tue, 03 Apr 2018 20:54:40 GMT

Maybe this...first your connection;

// Then, add your sql...

Temp_Data:

Select * From sc_req_item;

Have you tried this?

Re: Qlikview & Service now connection

waszcma1 — Tue, 30 Oct 2018 11:18:43 GMT

Hi,

I am strongly recommend to use dedicated connector for SNC

The latest version I know is: ServiceNow-ODBC-64-bit_1.0.13

It is really simple to configure then you have access to all data:

Please be aware that tables such as metric_instance, task, task_sla, incident could be really heavy so the best way is to set up daily incremental load into QVD and use QVD to fetch data into QVW.

Please also be aware that many tables can have same filed names (sys_id, opened_at, number ... etc.) so to avoid synthetic keys and have better control over the data modelling process I used Qualify command.

example how you can extract data from ServiceNow database

ODBC CONNECT TO InstanceName (XUserId is ARAAAANJbaMX1VMXbXeGYVOTTZYWXdOOA, XPassword is CLbOAAAAAaEDYEGUAAAAJD);

let vTableName ='sc_req_item';

QUALIFY *;

$(vTableName):

load * ;

SQL SELECT *

FROM "SCHEMA".OAUSER."$(vTableName)";

UNQUALIFY *;

store $(vTableName) into QVD\$(vTableName).qvd(qvd);