question How to achieve faster data transfer speed from import set table to target in Developer forum

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

Mite1096 — Thu, 12 Oct 2023 19:35:39 GMT

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.

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

DrewW — Thu, 12 Oct 2023 19:56:36 GMT

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.

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

Mite1096 — Thu, 12 Oct 2023 19:59:28 GMT

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

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

DrewW — Thu, 12 Oct 2023 20:17:39 GMT

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/concept/concurrent-imports.html

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

Mite1096 — Thu, 12 Oct 2023 20:51:55 GMT

Thank you for this.