How data gets in and out

Data entities, OData, business events, dual-write and the analytics estate — what each pattern is for, how to choose between batch and real time, and why direct database access is not on the list.

What you will be able to do

Introduction

No ERP stands alone. There is a warehouse system, a bank, a payroll provider, an e-commerce front end, a customer relationship system, a reporting stack, and a handful of things nobody documented that quietly keep the business running.

Data entities

A data entity is a published, business-shaped view over the underlying tables. "Customer" is an entity; behind it sit party records, address book entries, customer accounts and payment defaults, and the entity presents them as one coherent thing.

Choosing a pattern

Most integration mistakes are pattern mistakes rather than technical ones. Match the pattern to the need.

The analytics estate

Reporting deserves its own section because putting it in the wrong place is a decision that only hurts later.

The questions to settle before build

Integration design fails on governance far more often than on technology. Answer these before anyone writes an interface:

Security and access

Integrations authenticate as identities with security roles, and those roles should be scoped to exactly what the interface needs.

Knowledge check

Summary

Integration in D365 is a set of published contracts, and choosing the right one is a design decision rather than a technical preference.