Extract incremental data from ServiceNow

[mallik3]

We have a requirement to set up an extraction process that would execute daily to extract incremental data from Service-Now. We were able to get initial data extract from Service-Now using the approach mentioned in the wiki Exporting Data - ServiceNow Wiki. However, we are stuck in identifying an approach to implement incremental extract to capture changed data.

1. What are the different approaches available to extract incremental data from Service-Now?

2. How does Service-Now interpret the date values while passing it through URL query? For eg., https://demo.service-now.com/incident.do?XML&sysparm_query=sys_updated_on%3E%3D2015-01-01 00:00:00^O...

Does it consider the date as UTC? OR Does it convert the date from user specific timezone to UTC before querying Service-Now?

Thanks in advance.

- Mallik

[tony_barratt]

Hi Mallik,

With regards to Q 1. ODBC can be deployed to extract incremental data.

ODBC Driver - ServiceNow Wiki

Best Regards

Tony

[pavelmuller]

Hi Mallik,

I think SnowMirror (www.snow-mirror) is the tool you are looking for. It allows you to schedule incremental extracts from ServiceNow into a database of your choice.

I hope it helps, please feel free to download a trial version and give it a try.

Kind Regards,

Pavel

[AnoopDK]

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!