Possible workaround to extract data from ServiceNow

pablor
Kilo Expert

‎09-04-2015 04:59 AM

Hi all,

Could somebody advice how to face the extraction of huge amount of data from ServiceNow?


When trying to query tables with more than 200k records (including joins), our ODBC connector is not working as expected.


We have come with 4 different ideas how to get the data, but I will like to hear from you. Thanks in advance

 

  • Possibility of getting database backup from SNOW?
  • Snow Mirror tool
  • Find a way how to use ODBC on tables with more than 200k records?
  • How to raise limit of exported data from ServiceNow GUI?

   

Labels:
0 Helpfuls
  • 2,750 Views
12 REPLIES 12

tony_barratt
ServiceNow Employee
ServiceNow Employee
In response to garrett_prochno

‎12-23-2015 01:22 AM

Hi Garrett,



You could have one MID-Server for discovery and another different MID-Server for export sets.



Best Regards



Tony


0 Helpfuls

AnoopDK
Kilo Explorer

‎11-08-2018 01:30 AM

Folks, I can build this data extraction from SN to DB or excel/CSV. Can provide end-to-end solution. For consultation please contact anoopdk@gmail.com, Thanks!

0 Helpfuls

Community Alums
Not applicable

‎11-08-2018 02:00 AM

Hey Pablo,

For that amount of records, I would recommend you to do an API rest call. I've done it before, you just need to build an #c application that retrieves data from specific tables in SNOW and populates into database. I would recoomend to use a "schema" file where you define the "table & fields" in SNOW and respective table and fields in "SQL". I can share some details if you want. 

Thanks,
RMC

0 Helpfuls