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

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

Re: tServiceNow speed

Its included in Studio ESB 6.2.1 
/Paul
Highlighted
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.
Highlighted
Five Stars

Re: tServiceNow speed

 
here is a screenshot of my job.
/Paul
Highlighted
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.
Highlighted
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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read