ServiceNow Data Mart Loader Wiki

ServiceNow Data Mart Loader (a.k.a. ServiceNow Data Pump)

Brought to you by: gflewis, giles3

GUI

Overview

GUI mode allows the application to be configured and monitored using ServiceNow. In order to use GUI mode you must install an Update Set in your ServiceNow instance. The Update Set creates three tables

u_datapump_jobset
u_datapump_job
u_m2m_datapump_jobs

Use the following command to execute a Jobset which has been configured in the ServiceNow instance, where jobsetname is the name of the u_datapump_jobset entry.

java -jar servicenow-sql-pump.jar -p datapump.properties -js jobsetname

This will cause the application to process all u_datapump_job records which are attached to the specified jobset via the many-to-many table u_m2m_datapump_jobs.

GUI mode is especially useful for Refresh and Prune jobs. Each u_datapump_job record is updated as it is processed. When the Refresh or Prune job is run again, it will only process records which have been updated (or deleted) since the last execution.