Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have REST Connection from ServiceNow (SN) to Qlik Sense. The source table on SN has got only 10K rows. however when I am loading data in qlik it is taking more than 30 minutes. I have setup all pagination information to load 5K instance at a time. Also one more thing the JASON script created to load data is taking creating cross table with every field I am trying to load from data.
Example :
I have EMP table in SN with 10K records with 10 fields:
When jason script is created in QS, it has got 10 select statement. like
RestConnectorMasterTable:
SQL SELECT
"__KEY_result",
(SELECT
"display_value",
"value",
"__FK_u_EMPID"
FROM "u_EMPID" FK "__FK_EMPID"),
Similarly, 10 selects statements are created to load data. This is creating cross joins and impacting the load. so wanted to know is there any way to reduce load time.
Hello there,
This question seems to be unrelated to Qlik Application Automations. Could you please post your question again in the Connectivity & Data Prep forum (https://community.qlik.com/t5/Connectivity-Data-Prep/bd-p/qlik-sense-data-connectivity)?