Integrating Business Central with Salesforce: A Practical Guide

The BC-Salesforce integration is one of the most common requirements in our client base. Here's how to approach it correctly.

The combination of Business Central (ERP) and Salesforce (CRM) is extremely common in mid-market organizations, particularly in professional services, manufacturing, and distribution. Integrating them effectively — so that sales has real-time inventory and pricing, and finance has accurate order data — is technically achievable but requires careful design.

What Needs to Be Integrated

The most common integration requirements are: customer master data (bi-directional), product catalog and pricing (BC to Salesforce), sales orders (Salesforce to BC), invoice and payment status (BC to Salesforce), and inventory availability (BC to Salesforce).

Each of these has different synchronization frequency requirements, conflict resolution rules, and error handling needs. Treating the integration as a single project rather than distinct data flows is a common design mistake.

Integration Platform Options

The most commonly used integration platforms for BC-Salesforce are: Microsoft Power Automate (good for simpler, lower-volume integrations), Azure Logic Apps (more robust, better for higher-volume or complex transformations), and purpose-built connectors like Celigo or Boomi (fastest to implement for standard scenarios).

The Data Governance Problem

Bi-directional integrations always create data governance challenges: when the same data exists in two systems, which system wins when they disagree? Defining these rules clearly before development begins prevents significant rework and operational confusion after go-live.