Skip to content

About

Jump to bottom
Giles Lewis edited this page Jul 20, 2024 · 16 revisions

SNDML (ServiceNow Data Mart Loader) evolved from a project started in 2012 to create a Java application that could load data from ServiceNow into an SQL database. Work on version 3.x begin in 2017. The application uses the REST and SOAP APIs to extract meta-data and data from ServiceNow. It creates tables in an SQL database based on ServiceNow meta-data.

This site provides pre-built JAR files for Oracle, Microsoft SQL Server, MySQL, PostgreSQL and SQLite. Because sndml3 relies on JDBC for database interaction, it should work with any relational database.

The Java program can be run in several different modes.

  • --table - Simple table load. The name of a ServiceNow table is passed as a command line argument.
  • --yaml - YAML configuration. The name of a YAML file is passed as a command line argument. For details refer to YAML Configuration.

The following modes are available beginning with version 3.4 and require installation of the DataPump Scoped App 1.1 or greater in the ServiceNow instance.

  • --scan - Connect to ServiceNow and query the DataPump Application for any jobs in "Ready" state. If jobs are found then process them and terminate.
  • --daemon - Same a "scan" except that the program runs in an endless loop periodically polling the DataPump application for jobs ready to run.

The following modes are available beginning with version 3.5 and require installation of the DataPump Scoped App 3.5 or greater in the ServiceNow instance.

  • --jobrun - Execute a single Job Run. The sys_id is passed in as a command line argument.
  • --server - Run as an HTTP server, listening on the port specified in the Connection Profile.

SNDML supports several different load operations. For details refer to Actions. The different actions are not available for simple table load. If the mode is --table then action: update is implied.

The DataPump scoped application can be downloaded from the ServiceNow Developers Share Site.

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.

Next

Getting Started

Clone this wiki locally