AL Synchronize Databases

Overview

AL Synchronize Databases connects Microsoft Dynamics 365 Business Central to external databases (PostgreSQL and Microsoft SQL) with a real two-way sync. It is not dumb one-way replication: outbound changes flow from BC to your external database, and inbound rows flow back into BC through its own business logic - so returning data respects your validation and business rules instead of overwriting them raw. You configure it with nodes, interfaces and field mapping, and monitor it with a buffer, an SQL log and a Web API.

Key features

• Bidirectional sync - outbound BC to external writes Insert, Update and Delete SQL; inbound external to BC writes rows back into your tables.
• Asynchronous, durable buffer - each change is queued inside Business Central in the same transaction that made it, then applied to the external database by a background node; the buffer entry clears only once the external write is confirmed.
• Business-logic-aware writes - inbound values can pass through BC field validation (OnValidate triggers), configurable per field between validated and raw.
• Configurable model - nodes, node groups and node interfaces with field mapping define what syncs, where and how.
• Pluggable engine - implementations for PostgreSQL and Microsoft SQL, with a synchronize buffer and JSON handling.
• Monitored - SQL log plus node, interface, buffer and NAS Web APIs for orchestration and monitoring.

Business benefits

• Data integrity both ways - external data enters BC under BC's own rules, not as a blind overwrite.
• Resilient delivery - if the target database or the link is down, the change stays queued and is retried until it lands, so nothing is silently lost (at-least-once, eventually consistent).
• Configurable, not coded - replace custom export jobs with a governed model.
• Governed and visible - buffer, log and Web API keep every sync auditable.

Typical scenarios

• BI and datalakes - push BC tables to a reporting database.
• E-commerce and portals - feed an external system and let orders or updates flow back validated.
• Third-party systems - keep a partner database in two-way step with BC.

What makes it different

Other connectors copy data out and stop there. AL Synchronize Databases closes the loop: data coming back into Business Central is validated against your business logic, making it a two-way integration engine rather than a one-way export.