a field, a record, or a transaction.
The InterWeave Integration Engine is the precision layer beneath every SmartFlow and SmartAgent — transforming data, enforcing schema fidelity, logging every sync to IWSyncRegistry, and guaranteeing transactional integrity across your CRM, ERP, and payment stack.
Every InterWeave integration is built on a verified three-layer methodology — ensuring entity fidelity, field accuracy, and end-to-end orchestration integrity regardless of source or destination system.
Authoritative record identification across systems — matching customers, accounts, invoices, and products by canonical keys, preventing duplicates and orphaned records.
FoundationXSLT-powered field-level transformation — data type coercion, value lookup tables, conditional mapping, currency normalization, and date format conversion between any two system schemas.
TransformationEnd-to-end transaction sequencing — managing create/update/delete ordering, retry logic on failure, compensating transactions on rollback, and IWSyncRegistry writes for full audit lineage.
IntegrityThe engine maps every field with verified BOI schema names — Salesforce objects to Sage Intacct entities, Creatio records to QuickBooks transactions — with AI-assisted mapping closing the gap on ambiguous fields.
The engine executes XSLT stylesheets at runtime — converting source XML payloads into destination-ready documents with full support for conditional logic, lookups, aggregation, and nested object traversal.
Mid-market ERP and CRM systems are notoriously inconsistent in data models, API contracts, and field semantics. The engine was designed for exactly this environment.
Record ownership rules prevent write conflicts — each field has a defined system of record. Changes propagate in the correct direction without looping or duplication.
Full XSLT 2.0 stylesheet execution at runtime — supporting conditional branches, lookup tables, string normalization, date format conversion, and nested element traversal.
Credentials and API keys never leave the Security Perimeter. All connector calls are proxied — your data flows through InterWeave's controlled channel, not directly between systems.
Transient failures trigger configurable retry sequences with exponential backoff. On persistent failure, compensating transactions roll back partial writes to maintain system consistency.
Sensitive fields — SSNs, payment tokens, PII — are encrypted in transit and masked in logs. RBAC controls which roles can view, decrypt, or modify protected fields.
Every transformation, every write, every retry is logged with a unique syncId, source and destination record IDs, timestamp, duration, and status — queryable for SOX and SOC 2 compliance.
IWSyncRegistry is the canonical audit store for the entire platform — a tamper-evident ledger of every integration event, transformation outcome, and escalation action.
| Sync ID | Flow / Agent | Source | Destination | Status | Duration | Timestamp |
|---|---|---|---|---|---|---|
| IW-2025-88441 | sf-intacct-sync | SF · OPP-10042 | Intacct · INV-10042 | Completed | 142 ms | 2025-05-14 14:22:03 |
| IW-2025-88440 | AR-Agent-01 | Intacct · INV-10039 | Escalation · ESC-00091 | Escalated | 38 ms | 2025-05-14 14:22:08 |
| IW-2025-88438 | payment-sync | Stripe · pay_3Nx... | SF · OPP-10038 | Completed | 89 ms | 2025-05-14 14:21:55 |
| IW-2025-88435 | creatio-sage100 | Creatio · ORD-8821 | Sage 100 · SO-8821 | Completed | 211 ms | 2025-05-14 14:21:41 |
| IW-2025-88430 | qbo-intacct-sync | QBO · INV-4490 | Intacct · APBILL-4490 | Retry · 2/3 | 504 ms | 2025-05-14 14:21:19 |
| IW-2025-88427 | onboard-flow | SF · CON-7712 | Intacct · CUSTOMER-7712 | Completed | 163 ms | 2025-05-14 14:21:08 |
A SmartFlow trigger fires — or a SmartAgent initiates a read — and the engine receives the source payload as raw XML from the originating connector.
The engine resolves canonical record identifiers — matching source keys to destination system IDs using IWSyncRegistry lookups and configured entity match rules.
The XSLT stylesheet executes — mapping fields, coercing types, applying conditional logic, and producing a validated destination payload ready for the target API.
The destination API call is made through the Reverse API Proxy. On success, a complete IWSyncRegistry entry is written. On failure, retry logic and compensating transactions engage.
SmartIntegration is the data and transaction layer — every SmartFlow and SmartAgent relies on it to move, transform, and persist records correctly.
See the Integration Engine map your Salesforce, Sage, or Creatio schema to your target system — live — in a 30-minute technical demo with our integration team.