tServiceNow speed

Highlighted
Five 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
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.
Five 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.
Five 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.
Five Stars

Re: tServiceNow speed

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

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch