Business Central

Business Central Integrations

Business Central integrates through published REST APIs, OData, Power Automate, Dataverse and AppSource extensions.

Reviewed 2026-08-24 by the Machina IT engineering team.

The short answer

Business Central integrates through published REST APIs, OData, Power Automate, Dataverse and AppSource extensions. The integrations that pay off fastest for manufacturers are shipping and rate quoting, EDI, barcode and shop floor data capture, CAD or PLM item and BOM sync, and Power BI reporting. Direct database writes are not an option in the cloud, which removes the most common source of legacy ERP fragility.

01

Integration methods, ranked by durability

  • Standard and custom APIs — versioned, supported, the default choice
  • AppSource extensions — vendor-maintained, upgrade-tested against each release
  • Power Automate and Dataverse — good for approvals, notifications and low-volume sync
  • File-based transfer — acceptable for batch EDI, needs monitoring and alerting
  • Screen scraping or unsupported hacks — never; they break on the next update wave
02

Integrations worth building first

  • Shipping and freight rating, with tracking numbers written back to the sales order
  • EDI for customer purchase orders, invoices and advance ship notices
  • Barcode scanning for receiving, picking and production posting
  • CAD or PLM sync so item and BOM changes flow one way with revision control
  • Power BI datasets for margin, on-time delivery and inventory turns
03

Design rules that prevent long-term pain

Define one system of record per data element. When both ERP and a satellite system can change an item's cost or a customer's credit limit, reconciliation becomes permanent manual work.

Make every integration observable: log every message, alert on failures rather than on silence, and build a documented replay path for a missed batch.

04

Update-wave discipline

Microsoft ships major updates twice a year plus monthly service updates. Extensions and custom APIs must be validated in a sandbox against the preview release, not discovered broken in production.

That validation cycle belongs to someone by name, on a calendar, as part of managed IT rather than as an occasional project.

Common mistakes

What goes wrong most often.

  • Two systems both authoritative for the same field
  • Integrations with no failure alerting
  • Skipping sandbox validation before update waves
  • Middleware added where a native API would do

Common questions

Straight answers, no sales theater.

Can we write directly to the Business Central database?

No. Cloud Business Central is API-only, which is a durability improvement — extensions and APIs are version-tested, while direct table writes never were.

Do integrations consume user licenses?

Service-to-service connections authenticate differently than people do. Confirm the licensing treatment per integration during design so the model has no surprises.

How do we handle EDI with large customers?

Either an AppSource EDI extension or a managed EDI provider mapped to Business Central APIs. The deciding factor is how many trading partners and how customer-specific their maps are.

Schedule an IT assessment.

We review your network, security posture, cloud tenant and recovery plan, then hand you a plain-language report of what we found and what it means for the business.