Detect. Respond. Act.

Aurum is a suite of self-hosted products — Intercepts, Resolve, and Unify — that work together to find what matters in your data, respond to it, and do something about it. Automatically.

Products

Three Products. One Data Operations Platform.

Aurum is a suite of self-hosted products built to work together. Use one, use all three — each is independently licensed and delivers standalone value.

Detects
Intercepts
→
Responds
Resolve
→
Acts
Unify

Intercepts finds data of interest → Resolve manages the business response → Unify executes automated actions

Detects

Intercepts — SQL Query Library & Exception Management

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.

Learn More About Intercepts

Responds

Resolve — Business Initiative Automation

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.

Learn More About Resolve

Acts

Unify — Data Pipeline Builder

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.

Learn More About Unify

Auric — Built-in Scripting Language

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 or additional dependencies.

  • 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

Shared Platform Features

All three products run on the same self-hosted infrastructure and share a common security, logging, and administration layer.

Security & Access Control

  • 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

Deployment

  • 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

Ready to See It in Action?

Request a demo and we’ll walk through Intercepts, Resolve, and Unify — or focus on the single product that solves your most pressing challenge.

Request a Demo See Pricing