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 or a management review.
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, and 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 on schedule, across any connected database server.
3. Surface Exceptions Automatically
When a query returns results — records that don’t meet your standards, thresholds crossed, conditions triggered — Intercepts delivers them to the right people or systems. Every time, without manual effort.
Key Capabilities
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
- Organize queries by category, data domain, or business function
- Configurable result templates — control how results are formatted and delivered
- HTML table formatting with column-level control and Auric formula support
- Origination markers: track which results are new vs. previously seen across runs
Scheduling
- Continuous, hourly, daily, weekly, or specific time/day scheduling
- Multiple schedule configurations per query using Scopes
- Queries run across any connected SQL Server database
- Built-in Windows Service scheduler — no third-party job scheduler required
- Full execution logging: run time, result count, truncation status, errors
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 individual recipients or distribution lists
- Web portal — results surfaced to management and operational teams on demand
- Downstream to Resolve — automatically trigger a business Initiative
- Downstream to Unify — trigger a data pipeline to act on the exception
- Configurable per query — different queries can use different delivery methods
Monitoring & Alerting
- Automatic error alerting to the query maintainer when execution fails
- Execution history for every query run — when it ran, how long it took, what it returned
- Truncation warnings when result sets exceed configured limits
- Scheduler health monitoring with automatic restart on failure
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 — each Scope points to a different database or server
- Per-scope delivery — production results go to management, test results go to the development team
- Per-scope schedule — production checks daily, test environment checks on-demand
- Reduces maintenance overhead for organizations managing multiple environments or acquired companies
What Teams Use Intercepts For
ERP Data Quality Validation
- Daily compliance checks on acquired company data before ERP migration
- Validate customer records, inventory fields, and sales quotes against ERP business rules
- Surface non-compliant records to the onboarding team every day throughout the process
Operational Exception Monitoring
- Inventory below reorder threshold
- Open quotes with no activity beyond a defined period
- Production records that failed quality checks
- Customer records missing required fields
Management Reporting
- Scheduled operational reports delivered automatically by email or portal
- Management receives formatted data on schedule — no manual report runs
- Replace ad-hoc “can you pull that report” requests with automated delivery
Database Automation
- Replace fragile SQL Agent jobs with managed, monitored Intercepts queries
- Consolidate scattered query scripts into a single auditable library
- Get automatic alerts when a query fails — before the business notices
Works Standalone. More Powerful with Resolve and Unify.
Intercepts is a fully independent product — it delivers significant value as a standalone SQL query automation and exception management platform. No other Aurum products are required.
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.
Request a Demo See Pricing