Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tServiceNow speed

Hi
I have a job that should insert data from mssql to an custom table in servicenow with tServiceNowoutput
The speed when i insert is 3-4 rows/s whitch is slow, is there any tricks to make it faster?
Has anyone used the Component can't find much about it.
tMSSQLinput -> tmap -> tServicenow output
its not SQL that is slow (if i make it tMSSQLinput -> tmap -> tlog it is 2200 rows/s)
/Paul

Labels (2)
6 Replies
Anonymous
Not applicable
Author

Hi,
It seems that something is wrong with this component tServicenowOutput.
Best regards
Sabrina
Anonymous
Not applicable
Author

Its included in Studio ESB 6.2.1 
/Paul
Anonymous
Not applicable
Author

Hi,
How did you set this tServiceNowOutput component? Could you please show us your setting screenshot?
Best regards
Sabrina
Anonymous
Not applicable
Author

0683p000009MBlq.png  
here is a screenshot of my job.
/Paul
Anonymous
Not applicable
Author

Hi,
Could you please use tmssqlinput-->tmap-->t ServiceNowOutput directly without t<DB>Connection components in job design to see if the speed is normal? Is there any error message printed on console?
Best regards
Sabrina
Anonymous
Not applicable
Author

Changed job
About the same speed 1,78 row/s, if i send 100 rows 2,66 rows/s
/Paul