Creating a Dynamics 365 Business Central Change Data Source

Published: Mar 14, 2023

Creating a Dynamics 365 Business Central Change Data Source

Published: Mar 14, 2023
Configuration in Business Central
  1. Install the SmartConnect Change Tracking Extension from AppSource.
  2. In the Global Search in Business Central search for “Change Log Setup”.
  3. Change Log Activated – Verify flag is turned on.
  4. Then navigate to Setup > Tables
Change Log Setup

  1. On the ‘Change Log Setup (Table) List’ page, turn logging on for any tables that will be used as a Change data source.
63c6fac0b259d72d832a8e0e 02 image 2

Configuration in SmartConnect
  1. From the main Navigation Menu, select Data Sources > Change Triggers > Trigger.
63c6fae0e410a88111f035c8 03 image 2
  1. On the Change Triggers page, click the “Create Change Trigger” button.
  2. On the New Change Trigger page, Select Dynamics 365 Business Central Odata Change Data Source.
  3. Description – Friendly for the Dynamics 365 Business Central Change Data Source.
  4. Connection – select a Dynamics 365 Business Central connection.
  5. Click Validate.
  6. Company – Select a Dynamics 365 Business Central Company.
  7. Table – Select the table to monitor for changes.
  • Note: The source will include all fields on the tracked source table.
  1. Restrictions – Optionally add filters based on source table fields.
  2. Link Services – Optionally add detail from a related web service.
  • Click Add Service.
  • Select the Service URL to return data from.

Note: The services in this list will match the published page and query services that exist within the Dynamics 365 Business Central environment. Additional web services can be published as outlined in this Microsoft Article.

  • Link the web service to a field(s) on the tracked table.
  • Click Update to save the join.
63c6fb35335084c376e95f81 04 image 1
  1. Click Save.
63c6fb4be8dfe2146ded4ca9 05 image 1

  1. Navigate to Processes > Integration Processes and click ‘Add New’.
  2. Provide a name and description for the integration.
  3. Click on the Source tab.
  4. Source Type – Select ‘Changes Only’.
  5. Source – Select ‘Dynamics 365 Business Central Change Data Source’.
  6. Data Source – Select the previously defined data source.
  • Preview – Preview first 5 records from the change table for this integration.
  • Company – Read-only view of company defined on the data source.
  • Table – Read-only view of tracked table defined on the data source.
  • Link Services – Read-only view of linked web services on the data source.
  • Restrictions – Read-only view of restrictions defined on the data source.
  1. Group By – SmartConnect will automatically add the ‘eOneUniqueId’ field to the Group By list. This field will already be unique for each record so it is not required to add additional fields to this list.
  2. Track Changes – Select the type of events to track by checking the Create/Update/Delete boxes.
  • Note: Changes are tracked at the integration level. These flags can only be set on the integrations.
63c6fb792d5b92046fc31a81 06 image 1

  1. Map at least one field to the desired destination then save the integration.
  2. The integration is now registered and tracking changes.

*If you need help troubleshooting a Dynamics 365 Business Central change data source please reference this help article.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters