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)
Last edited by Linge (2016-11-01 14:08:31)
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?
What we can do is to make sure that Talend will be your best choice!