You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-11-01 13:50:48

Linge
Member
14 posts

Linge said:

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

Last edited by Linge (2016-11-01 14:08:31)

Offline

#2 2016-11-02 04:36:57

xdshi
Talend Team


xdshi said:

Re: tServiceNow speed

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-11-02 07:48:52

Linge
Member
14 posts

Linge said:

Re: tServiceNow speed

Its included in Studio ESB 6.2.1 
/Paul

Offline

#4 2016-11-02 07:58:20

xdshi
Talend Team


xdshi said:

Re: tServiceNow speed

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


What we can do is to make sure that Talend will be your best choice!

Offline

#5 2016-11-02 08:44:58

Linge
Member
14 posts

Linge said:

Re: tServiceNow speed

mini_job.png  
here is a screenshot of my job.

/Paul

Last edited by Linge (2016-11-02 08:45:40)

Offline

#6 2016-11-02 10:20:53

xdshi
Talend Team


xdshi said:

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


What we can do is to make sure that Talend will be your best choice!

Offline

#7 2016-11-02 11:16:25

Linge
Member
14 posts

Linge said:

Re: tServiceNow speed

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

/Paul

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy