The ServiceNow Data Mart Loader (a.k.a. ServiceNow DataPump) is a Java application which uses ServiceNow’s Web Services (SOAP) API to extract meta-data and data from ServiceNow. The Loader automatically creates tables in an SQL database based on meta-data extracted from ServiceNow. It supports a variety of load and synchronization operations including
- back-loading of historical data
- "refresh" which inserts/updates any records which have been inserted/updated in ServiceNow since the last run
- "prune" which deletes any records which have been deleted in ServiceNow since the last run
This program is freely distributed software. You are welcome to redistribute and/or modify it. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY, explicit or implied.
The current version supports Oracle and MySQL. The application has only been lightly tested with MySQL. The Quick Start Guide assumes that you will be using Oracle.