topic Re: tServiceNow speed in Talend Studio

tServiceNow speed

Anonymous — Sat, 16 Nov 2024 10:17:11 GMT

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

Re: tServiceNow speed

Anonymous — Wed, 02 Nov 2016 03:36:57 GMT

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

Re: tServiceNow speed

Anonymous — Wed, 02 Nov 2016 06:48:52 GMT

Its included in Studio ESB 6.2.1
/Paul

Re: tServiceNow speed

Anonymous — Wed, 02 Nov 2016 06:58:20 GMT

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

Re: tServiceNow speed

Anonymous — Wed, 02 Nov 2016 07:44:58 GMT

here is a screenshot of my job.
/Paul

Re: tServiceNow speed

Anonymous — Wed, 02 Nov 2016 09:20:53 GMT

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

Re: tServiceNow speed

Anonymous — Wed, 02 Nov 2016 10:16:25 GMT

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