Intercepts is Aurum's SQL query automation and exception management engine. Build a library of named, scheduled SQL queries — Intercepts runs them automatically, surfaces exceptions and data of interest, and delivers results to the people or systems that need to act on them.
Every query result is meaningful: a record that doesn't meet a standard, an inventory level that crossed a threshold, a customer field missing a required value. Intercepts finds these exceptions on schedule, without manual effort.
Query Library & Scheduling
- Define and manage a library of named SQL queries
- Schedule on any interval — continuous, hourly, daily, weekly, specific time
- Scope system: same query against multiple environments with independent config
- Configurable result templates with HTML formatting and Auric formulas
- Origination markers to track new vs. previously seen results
Exception Detection & Delivery
- Delivers results via email, web portal, or downstream to Resolve and Unify
- Automatically triggers Resolve Initiatives when exception conditions are met
- Full execution logging — run time, result count, errors
- Automatic error alerting to the query maintainer
Standalone value: Intercepts runs independently as a SQL query automation and exception delivery platform. No Resolve or Unify required.
Resolve automates the business response to data. When Intercepts surfaces an exception, Resolve can automatically start an Initiative — a structured, auditable workflow that manages what happens next. Initiatives can also be started manually for any business process that benefits from tracking, automation, and audit trails.
Initiative Management
- Create and manage Initiatives — structured business response workflows
- Initiatives started automatically from Intercepts results, or manually
- Full audit trail — who created it, what triggered it, every action taken
- Status tracking and management reporting on open Initiatives
Automation & Integration
- Trigger Unify pipelines as part of an Initiative response
- Auric scripting for custom Initiative logic and conditional branching
- Connects Intercepts exception detection to Unify pipeline execution
Standalone value: Resolve works independently as a business initiative and workflow management tool. Intercepts and Unify integration is additive.
Beta program: Resolve is currently in beta testing with select customers. Contact us to request access or to be notified when it's generally available.
Unify is Aurum's data pipeline engine. Build pipelines that move, transform, validate, and write data across your systems — triggered on a schedule, by an API call, or by a Resolve Initiative. A pipeline is a modular sequence of nodes, each doing one thing cleanly.
Pipeline Construction
- Build pipelines using Start, Transit, and Stop nodes
- Start nodes: SQL query, API injection, Resolve Initiative trigger
- Transit nodes: transform, validate, enrich, apply Auric logic
- Stop nodes: SQL write-back, API delivery
- Per-pipeline logging with configurable verbosity
System Integration
- Data standard normalization across heterogeneous systems
- Value Maps for automatic field-level translation between systems
- Supports Microsoft MQ, IBM MQ, Azure Service Bus
- ERP integration (M3, SAP, and others via SQL or web service)
- Scheduled and real-time (injection) execution modes
Standalone value: Unify runs independently as a data pipeline and integration platform. No Intercepts or Resolve required.
Auric is a purpose-built scripting language available across all three Aurum products. Write conditional logic, formulas, data transformation rules, and custom business logic directly in the platform — without an external scripting environment.
- Available in Intercepts result formatting, Resolve Initiative logic, and Unify pipeline nodes
- Access Aurum data objects natively in script
- Pre-compiled for performance
- Supports user-defined functions and classes
- Used in Value Maps, token expressions, form validation, and query conditions
- Active Directory (LDAP) authentication or local accounts
- Role-based access at the transaction, object, and data element level
- Security tag system for group-based permissions
- Full audit logging across all products
- Multi-enterprise and multi-division support
- Windows Server with IIS and SQL Server (2016+, 2017 recommended)
- PHP-based web UI served via IIS
- Windows Service-based scheduler for background automation
- Scales horizontally — multiple instances supported
- Optional: Microsoft MQ, IBM MQ, Azure Service Bus