How to achieve faster data transfer speed from import set table to target

[Mite1096]

Hi Guys,

Currently, we have this requirement to import 6 Million records into servicenow, and to achieve this we have split these records into 100,000 per file. We tried to import these 100k records in servicenow but it is taking around 3 hours to transfer data from the Import set table to the Target table. SO How can we achieve faster data transfer from the import set table to the target? 

While doing research I came to know the multithreading approach, If you guys have any ideas regarding this please share.

Thank you.

[DrewW]

Have you looked at Concurrent Imports.  It allows the system to process the data in chunks where each node handles an equal amount of the data.

[Mite1096]

Can you share any documents or steps to check/implement this?

[DrewW · Accepted solution]

Google is your friend on that one.  So is the search box on the ServiceNow Docs site.

https://docs.servicenow.com/bundle/vancouver-integrate-applications/page/administer/import-sets/conc...

[Mite1096]

Thank you for this.