Four Stars

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
6 REPLIES
Moderator

Re: tServiceNow speed

Hi,
It seems that something is wrong with this component tServicenowOutput.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tServiceNow speed

Its included in Studio ESB 6.2.1 
/Paul
Moderator

Re: tServiceNow speed

Hi,
How did you set this tServiceNowOutput component? Could you please show us your setting screenshot?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tServiceNow speed

 
here is a screenshot of my job.
/Paul
Moderator

Re: tServiceNow speed

Hi,
Could you please use tmssqlinput-->tmap-->tServiceNowOutput 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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tServiceNow speed

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