AL Synchronize Databases

AL Synchronize Databases synchronizes the data of Microsoft Dynamics 365 Business Central with external databases (PostgreSQL, Microsoft SQL) in both directions: Business Central changes flow out to the external database, and rows written there by external systems flow back into Business Central. Configurable nodes and interfaces, a buffer, logs and a Web API - a data integration engine for BI, datalakes, e-commerce and third-party systems.

Key capabilities

• Two-way flow - Business Central changes flow out to the external database; rows written there by external systems are flagged through a simple protocol and imported back into Business Central.
• Validated, extensible import - incoming data goes through the standard BC validation (table triggers and, per field, the field validate); once the data is safely in, the OnPostAfterImport business event runs interface-specific custom logic (e.g. posting a document).
• Decoupled by design - user work in Business Central never waits for the external database: changes feed a persistent buffer, row by row, and the service executes and realigns, even after downtime.
• Nodes and interfaces - node, node group and node interface (with fields and a log) define which data/tables to synchronize, to which external database and with which field mapping.
• Pluggable engine - an AL interface with implementations for PostgreSQL and Microsoft SQL, JSON handling, a synchronize buffer and an SQL log.
• Table setup - which tables, with synchronization and action types and an SQL status.
• Web API - node, node interface, buffer and NAS APIs for orchestration and monitoring.

Why it matters

• BC data where you need it - replicate or expose Business Central data on external databases, and bring external writes back into BC.
• Configurable, not coded - nodes, interfaces and field mapping instead of custom export jobs.
• Monitored - a buffer, logs and a Web API for governance.
• BI and integration ready - feed datalakes, BI and third-party systems.
• "Real-time" shop floor - interface production-progress systems, consumption tracking, scales and automated warehouses, with post-import logic posting what each interface requires.

Built for

IT and integration teams that need to exchange data between Business Central and external systems - for BI, datalakes, e-commerce, shop floor data collection or third-party integrations - in a configurable, monitored way.

What makes AL Synchronize Databases different

• Two directions, one model - the same nodes and interfaces govern export and import.
• A configurable sync model - nodes, interfaces and field mapping.
• Pluggable database engine - PostgreSQL and Microsoft SQL implementations.
• Monitored - buffer, SQL log and a Web API for orchestration.

How it works

Set up the nodes (external databases), the interfaces (tables and field mapping) and the synchronization type. As data changes in Business Central, the buffer is fed and the engine writes to the external databases (PostgreSQL/Microsoft SQL) per the interface, with logging. On the way back, triggers on the external database mark rows written by external systems and the import service brings them into Business Central; you monitor through the logs and the Web API.

Requirements

• Microsoft Dynamics 365 Business Central, version 25.0 or higher, online (SaaS) and on-premises. AppSource covers online environments; on-premises is distributed and installed directly by AppLibra, through the AppLibra License Manager.
• Languages - English (en-US) and Italian (it-IT).
• Targets - PostgreSQL and Microsoft SQL external databases; confirm the connection channel and security for your scenario.
• Dependencies (installed automatically) - AL License and Trial Management and AL Role Center, from AppLibra.