Aurum — Unify
Move Data Between Your Systems
Without Writing Custom Integration Code.
Unify is a self-hosted data pipeline builder for SQL Server environments. Build modular pipelines that query, transform, validate, enrich, and write data across your systems — triggered on a schedule, by an API, or automatically by a Resolve Initiative.
The Problem with Custom Integration Code
Every organization that runs multiple systems eventually builds integrations between them. Data needs to move from one system to another — from an ERP to a reporting database, from an acquired company’s system into the enterprise, from a source to a destination that needs it formatted differently.
The typical answer is custom code: a script someone wrote, a SQL Agent job that evolved over years, an ETL package maintained by one person who might leave. These integrations work — until they don’t. They’re fragile, undocumented, invisible, and painful to maintain.
Unify replaces custom integration code with modular, managed, monitored data pipelines. Build pipelines visually using nodes. Each node does one thing. Connect them together and Unify handles the execution, logging, and error handling automatically.
How Unify Pipelines Work
A pipeline in Unify is a sequence of nodes — each performing one discrete operation. Nodes are organized into three types:
Start Nodes
Every pipeline begins with a Start node that provides the initial data set. Sources include scheduled SQL queries, API-injected payloads, or a Resolve Initiative trigger.
Transit Nodes
Data flows through Transit nodes that transform fields, validate records, enrich data with lookups, apply Auric business logic, and normalize formats across systems.
Stop Nodes
At the end of the pipeline, Stop nodes write the processed data to its destination — a SQL Server database, an external API, a message queue, or another connected system.
Key Capabilities
Pipelines are built from modular nodes, each responsible for a single operation. This approach makes pipelines easier to understand, maintain, and modify — compared to monolithic scripts that do everything in one place.
Start Node Types
- SQL Query (Discovery): Runs a SQL query on a schedule to generate the initial data set
- API Injection: Receives data pushed from an external system via API call
- Resolve Initiative: Pipeline triggered by a Resolve Initiative responding to an Intercepts exception
Transit Node Types
- Transform: Modify field values, reformat data, apply calculations
- Validate: Check records against business rules — route or reject invalid data
- Retriever: Enrich records with lookups from other data sources
- Auric Logic: Apply custom business rules using Aurum’s built-in scripting language
- Data Standards: Normalize data formats across heterogeneous source systems
Stop Node Types
- SQL Write-Back: Insert, update, or upsert records into any connected SQL Server database
- API Delivery: Send processed data to an external system via web service
- Message Queue: Route data through Microsoft MQ, IBM MQ Series, or Azure Service Bus
Pipeline Execution
- Scheduled execution (Discovery mode) — runs on a defined interval
- Real-time execution (Injection mode) — triggered by incoming API payload
- Initiative-triggered — started by a Resolve business Initiative
- Per-pipeline execution logging with configurable verbosity
- Error handling and alerting built in
Unify connects to your existing systems as data sources and destinations — without requiring you to replace or migrate them. Your ERP, EMR, financial system, or other data source remains the system of record. Unify reads from it, transforms the data, and writes it where it needs to go.
Data Source Connectivity
- Any SQL Server-accessible database — ERP, EMR, financial, operational systems
- ERP systems including M3, SAP, and others accessible via SQL or web service
- External web service APIs
- Message brokers: Microsoft MQ, IBM MQ Series, Azure Service Bus
Data Normalization
- Data Standards: Define format rules for data moving between systems — normalize field values, date formats, identifiers, and units across heterogeneous sources
- Value Maps: Translate discrete field values between systems automatically — e.g., “Active” in system A maps to “1” in system B
- Auric formulas: Apply custom transformation logic for complex mapping requirements
Unify runs on your Windows Server infrastructure. Data processed through pipelines stays inside your network — it doesn’t pass through any third-party cloud infrastructure. Every pipeline execution is logged.
- Runs on Windows Server with IIS and SQL Server — no cloud dependency
- Per-pipeline execution log with configurable verbosity — see exactly what ran, what it processed, and what it produced
- Error alerting and failure handling built into every pipeline
- Role-based access control — manage who can create, edit, and trigger pipelines
- Active Directory authentication or local accounts
- Full audit trail on pipeline configuration changes
What Teams Use Unify For
ERP Data Integration
- Synchronize data between an acquired company’s systems and the enterprise ERP
- Normalize data formats from multiple source systems to meet ERP data standards
- Automate data imports that currently require manual export/import steps
Exception-Driven Automation
- Triggered by Resolve Initiatives responding to Intercepts exceptions
- Automatically update or correct records when a known exception condition is met
- Route data to downstream systems in response to detected data events
Data Migration & Onboarding
- Move and transform data from legacy systems during migrations
- Validate records against target system standards before writing
- Log every record processed — full traceability for audit and compliance
Operational Data Flows
- Scheduled data synchronization between operational systems
- Real-time data routing via API injection
- Replace fragile custom ETL scripts with managed, monitored pipelines
Works Standalone. More Powerful with Intercepts and Resolve.
Unify is a fully independent product — it delivers significant value as a standalone data pipeline and integration platform. No other Aurum products are required.
When Intercepts and Resolve are also licensed, Unify becomes the action layer in a closed-loop system:
- Intercepts detects — a query surfaces a data exception or trigger condition
- Resolve responds — automatically starts a business Initiative to manage the response
- Unify acts — executes the pipeline that takes automated action on the data
See Unify in Action
Request a demo and we’ll walk through how Unify pipelines would work in your environment — your systems, your data flows, your integration requirements.
Request a Demo See Pricing