Best way to Export More than 1 Million data from ServiceNow table.?

Ratan B
Tera Contributor

Hi All,

Have a requirement to export 1Million+ data from Servicenow, is there any way to export the data in faster way..?

 

Thanks in advance..

1 ACCEPTED SOLUTION

Maik Skoddow
Tera Patron
Tera Patron

Hi

ServiceNow has exports limits you shouldn't increase as you would risk the health of your instance!

But breaking up your exports in chunks of 10000 records as ServiceNow recommends, would mean a lot of manual work (several hours I guess).

Therefore have a look on the following solution which automates the process of exporting the batches and merging the pieces into one result file.

https://davidmac.pro/posts/2021-07-02-sn-bulk-export/

Maik

View solution in original post

4 REPLIES 4

Aman Kumar S
Kilo Patron

Check out below articles:

Break up a large export

Best Regards
Aman Kumar

Jaspal Singh
Mega Patron
Mega Patron

Hi Ratan,

By export you mean export in excel OR you want it to be shared via APIs?

Hi Jaspal, Thanks for your reply Anything is fine, could you please explain both the options..???

Maik Skoddow
Tera Patron
Tera Patron

Hi

ServiceNow has exports limits you shouldn't increase as you would risk the health of your instance!

But breaking up your exports in chunks of 10000 records as ServiceNow recommends, would mean a lot of manual work (several hours I guess).

Therefore have a look on the following solution which automates the process of exporting the batches and merging the pieces into one result file.

https://davidmac.pro/posts/2021-07-02-sn-bulk-export/

Maik