The Active integration method is the default and most established method. It monitors data changes in real time using Business Central's database trigger mechanism.
How it works
- Whenever a record is inserted, modified, deleted, or renamed in a monitored table, Commerce 365 intercepts the change immediately via database triggers.
- The change is registered in an internal Integration Entry table, which marks the record for synchronization.
- When the synchronization job queue runs, all pending Integration Entries are transferred to the Synchronization Queue and then processed, sending updates to Magento via the Commerce 365 API.
Characteristics
| Aspect | Detail |
| Change detection | Real-time (during the user's database transaction) |
| Performance impact | Moderate, a small amount of processing occurs in the user's session for every monitored insert, modify, delete, or rename |
| Queue population | At sync time, pending entries are transferred to the queue when the job queue runs |
| Monitoring options | Monitor Insertions, Modifications, Deletions, Renames (all configurable per entity) |
| Inventory triggers | Supported, triggers inventory recalculation immediately when monitored records change |
Setup
- Open the Commerce 365 Setup page.
- Set Integration Method to Active.
- Open the Table Setup page to review or configure monitored tables.
- For each entity, configure:
Active: Enable for entities that should be monitored.
Monitor Insertions / Modifications / Deletions / Renames: Enable the operations you want to track.
Queue Changes: Enable to include the entity in the polling cycle.
Job Queue Category Code (optional): Assign a category code to group entities for a specific job queue entry. This allows you to split synchronization across multiple job queue entries for better performance.
Priority: Controls the order in which entities are synchronized (lower = earlier).
Inventory Update Trigger: When enabled with field mappings and filters, inventory will be recalculated for any polled record that matches the filter criteria.