How-ToIntegrations

How to Set Up Data Replication in Business Central

Keep data consistent across companies or systems using APIs, Azure integrations, and data exchange frameworks in Business Central.

Daxly

Replication refers to synchronizing data between systems or companies. In most Business Central environments, this is handled through integrations, APIs, or partner solutions.

Replication is commonly used when data must remain consistent across environments.

Typical replication scenarios

Examples include:

  • Synchronizing items between companies
  • Replicating customer records
  • Sharing price lists
  • Updating product data across environments

Replication avoids maintaining the same records in multiple places.

Step 1: Identify the Data to Synchronize

Start by deciding which tables must remain aligned.

Common examples:

  • Items
  • Customers
  • Vendors
  • Price lists
  • Dimensions

Clearly defining the scope prevents unnecessary data transfer.

Step 2: Choose a Replication Method

Business Central supports several integration approaches:

  • Web services (OData or API pages)
  • Azure integrations
  • Data exchange frameworks
  • Partner integration apps

The best method depends on whether replication is:

  • Company to company
  • Tenant to tenant
  • External system integration

Step 3: Configure Data Mapping

When replicating data, fields must match between systems.

Mapping ensures:

  • Field values are transferred correctly
  • Data formats are compatible
  • Conflicts are handled properly

This configuration is normally done within the integration layer.

Step 4: Define Filters

In many scenarios only a subset of data should replicate.

Examples:

  • Only items from a certain category
  • Customers in a specific region
  • Active products only

Filters reduce system load and avoid unnecessary updates.

Step 5: Monitor Synchronization

After replication is configured, monitor the process regularly.

Check:

  • Integration logs
  • Failed records
  • Duplicate data issues

Scheduled monitoring prevents synchronization errors from building up over time.

To manage which users have access to integration and replication features, see How to Configure Security Groups in Business Central.