Common data model overview (Previous Version)


This topic is about the previous version of Common Data Model, and is no longer updated or maintained. For information about the new Common Data Model, see Common Data Model Overview.

At the core of the Common Data Service is the common data model. The common data model comes pre-populated with many business entities that are useful across a variety of business and application domains. These entities can be used by apps built atop the Common Data Service via PowerApps or the Common Data Service SDK, or by the integration capabilities that the Common Data Service provides customers. The common data model is fully extensible - you can add fields to any of the entities that come with the Common Data Service, or create your own. The benefit of the common data model is that applications can work against data without needing to explicitly know where that data is coming from.

The common data model provides a rich and productive development platform through the following features:

  • Common data model – The common data model is a library of entities that represent the most commonly used entities across business and productivity applications. The library is organized for simplicity and rapid discoverability. Typical solutions will revolve around core elements of enterprise data – for example, a worker, an account, a product, or a vendor. Applications across the enterprise will drive updates to that data. The common data model is implemented to simplify the challenges of data management.
  • Data import – You can quickly and easily import data from your existing systems. The Common Data Service rapidly establishes trusted connections for IT-managed tenants. The trusted connections continually synchronize the data between your existing systems and your platform solutions.
  • Simple, but rich – The common data model balances the richness to be useful and the simplicity to be usable.
  • Extensibility – You can extend the entities without breaking data sharing with other apps.
  • Robustness – Because you can depend on common entities, you can build reusable components that are bound to the entities. The Common Data Model includes a design for extensibility and versioning that protects your development investment.
  • Unification – Your solutions can connect information from productivity platforms with data from business applications. For example, you can connect a calendar appointment or a Microsoft Outlook task with a sales opportunity. The Common Data Service connects through standard interfaces, such as the Microsoft Graph application programming interface (API), and maps entities to the productivity platform objects to enable the join relationships with business data.

Additionally, the Common Data Service provides several key capabilities over the common data model including:

Download the documentation

To download the Common Data Service documentation as a single file, see Microsoft Common Data Model, Entity Reference.

See also

Standard entities

Entity field data types

Entity relationships

Entity field properties

System fields

Naming conventions

Entity versioning

Privacy notice

Foundation entities

Foundation reference

People, organizations, and groups entities

People, organizations, and groups reference

Purchasing entities

Purchasing reference

Sales entities

Sales reference

Customer service entities

Customer service reference

Standard picklists