Qlikview & Service now connection

[Anonymous]

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;keyGenerationStra...";

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....

[krishna_2644]

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.

[Anonymous]

@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?

[Anonymous]

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

[krishna_2644]

Once you have the access,

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

[johnca]

Maybe this...first your connection;

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://xxx.service-now.com/web/;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStra...

// Then, add your sql...

Temp_Data:

Select * From sc_req_item;

Have you tried this?

[waszcma1]

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);