Home

The ServiceNow Data Mart Loader is a Java command-line application which uses the ServiceNow REST API to extract meta-data and data from ServiceNow. The Loader creates tables in an SQL database based on ServiceNow meta-data. It supports a variety of load and synchronization operation.

Contents

Tutorial

• About
• Getting Started - Install and test the application using a MySQL database
• YAML Configuration

Reference

• Connection Profile
• Global Settings
• Table Settings
• Dates and Date Ranges
• Time Zone
• Templates
• Bash Scripts
• JUnit

Use Cases

• Actions - Insert, Update, Prune, Sync
• Partition - Loading historical data from large tables
• Metrics - Incremental loads since the last run
• Non-admin - Using a ServiceNow account that does not have admin role
• Domain Separation - Using a domain separated ServiceNow instance
• FAQ - Frequently Asked Questions

Disclaimer

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.