Export bulk data out of ServiceNow

Hemachithra
Tera Contributor

‎08-01-2024 11:11 PM

Hi Experts,

 

We have a scenario where we need to export 40 millions of record from software Installations table in real time dynamically for external reporting purpose. If anyone have worked on this, please share your inputs.

 

Thanks in advance.

 

0 Helpfuls
  • 408 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎08-02-2024 12:24 AM

Hi @Hemachithra 

 

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

 

https://www.servicenow.com/community/developer-forum/best-way-to-export-more-than-1-million-data-fro...

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727636

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Mark Manders
Mega Patron

‎08-02-2024 12:43 AM

Real time export of 40M+ records for reporting purposes? 

The links Atul shared should get you going, but I would start by challenging this requirement. Real time export of 40M+ records means that the 1st record is no longer 'real time' when the last one is exported (next to possible performance issues. And just for reporting? What information is needed that the report can't be truly real time shown in ServiceNow?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
0 Helpfuls