Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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.
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?
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
Once you have the access,
open script editor, Connect to the desired database,once connected,load table using the regular methods.
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?
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);