Aurum — Intercepts

Your Data Knows When Something Is Wrong.
Intercepts Makes Sure You Do Too.

Intercepts is a SQL query library and exception management engine. Define your queries once, set a schedule, and Intercepts finds what matters in your data — automatically, every time — and gets it to the people who need to act on it.

The Problem with Manual Query Execution

Most data operations teams have a library of SQL queries they run regularly — compliance checks, exception reports, operational dashboards, data quality validations. The queries are well-defined. The schedule is understood. But someone still has to run them.

When that person is busy, distracted, or out of office, the queries don't run. Exceptions go undetected. Data problems that could have been caught on Monday get discovered on Friday — or at the worst possible moment, like during an ERP migration.

Intercepts eliminates the dependency on manual query execution. Your queries run on schedule. Results reach the right people. Exceptions get flagged the moment they appear — not when someone remembers to look.

How Intercepts Works

1. Build Your Query Library

Define named SQL queries that encode your business rules, compliance checks, and exception conditions. Each query lives in Intercepts — versioned, documented, managed in one place.

2. Schedule Automatic Execution

Set each query to run on any interval — continuous, hourly, daily, weekly, or at a specific time. Intercepts handles execution automatically across any connected database server.

3. Surface Exceptions Automatically

When a query returns results, Intercepts delivers them to the right people or systems. Every time, without manual effort.

SQL Query Library

Intercepts gives your team a single, managed library of SQL queries — replacing scattered scripts, undocumented SQL Agent jobs, and queries that live only in someone's head.

Library Management

  • Define and name queries with descriptions and ownership
  • Configurable result templates with HTML formatting and Auric formula support
  • Origination markers: track new vs. previously seen results across runs

Scheduling

  • Continuous, hourly, daily, weekly, or specific time/day scheduling
  • Built-in Windows Service scheduler — no third-party job scheduler required
  • Full execution logging: run time, result count, truncation status, errors

Exception Detection & Delivery

Every Intercepts query result is an exception — a record, condition, or data point that warranted attention. Intercepts delivers that exception to the people or systems that need to act on it.

Delivery Options

  • Email delivery — formatted results to recipients or distribution lists
  • Web portal — results surfaced to management and operational teams
  • Downstream to Resolve — automatically trigger a business Initiative
  • Downstream to Unify — trigger a data pipeline to act on the exception

Monitoring & Alerting

  • Automatic error alerting to the query maintainer when execution fails
  • Execution history for every query run
  • Truncation warnings when result sets exceed configured limits
  • Scheduler health monitoring with automatic restart on failure

Multi-Environment Support with Scopes

The Scope system lets you run the same query against multiple database environments — production and test, multiple sites, different divisions — each with its own connection settings, schedule, and delivery configuration. Define the query once. Run it everywhere it applies.

  • One query definition, multiple independent execution environments
  • Per-scope connection settings, delivery, and schedule
  • Reduces maintenance overhead for organizations managing multiple environments or acquired companies
A global manufacturer with over $1 billion in annual revenue uses Intercepts to run more than 10,000 automated SQL queries per month across 5 database servers — validating acquired companies' data against ERP compliance standards every single day. By migration time, they know the data is ready.
10,000+queries automated/month
5database servers
Dailyvalidation cadence
0manual query runs

Works Standalone. More Powerful with Resolve and Unify.

Intercepts is a fully independent product — it delivers significant value on its own. When Resolve and Unify are also licensed, Intercepts becomes the detection layer in a closed-loop system:

  • Intercepts detects — a query returns results flagging a data exception
  • Resolve responds — automatically starts a business Initiative to track and manage the response
  • Unify acts — executes a data pipeline to take automated action on the exception

See Intercepts in Action

Request a demo and we'll walk through how Intercepts would work in your environment — your query types, your data sources, your delivery needs.