Use Data Entities for Data Management and Integration(2)

Categories of entities

Entities are categorized based on their functions and the type of data that they serve. The following are five categories for data entities:​

  1. Parameters
    •Functional or behavioral parameters.
    •Required to set up a deployment or a module for a specific build or customer.
    •Can include data that is specific to an industry or business. The data can also apply to a broader set of customers.
    •Tables that contain only one record, where the columns are values for settings. Examples of such tables exist for Accounts payable (AP), General ledger (GL), client performance options, workflows, and so on.
  2. Reference
    •Simple reference data, of small quantity, that is required to operate a business process.
    •Data that is specific to an industry or a business process.
    •Examples include units, dimensions, and tax codes.
  3. Master
    •Data assets of the business. Generally, these are the “nouns” of the business, which typically fall into categories such as people, places, and concepts.
    •Complex reference data, of large quantity. Examples include customers, vendors, and projects.
  4. Document
    •Worksheet data that is converted into transactions later.
    •Documents that have complex structures, such as several line items for each header record. Examples include sales orders, purchase orders, open balances, and journals.
    •The operational data of the business.​
  5. Transactions
    •The operational transaction data of the business.
    •Posted transactions. These are non-idempotent items such as posted invoices and balances. Typically, these items are excluded during a full dataset copy.
    •Examples include pending invoices.

Configuration keys and data entities
Before you use data entities to import or export data, we recommended that you first determine the impact of configuration keys on the data entities that you are planning to use.

To learn more about configuration keys in finance and operations apps, refer to the License codes and configuration keys report.

Supported integrations

Data management by using data entities can support the following integrations:​

  1. Synchronous service (OData) – Data entities enable public application programming interfaces (APIs) on entities to be exposed, which enables synchronous services. This method is used for Office integration and third-party mobile app integrations
  2. Asynchronous integration – Data entities also support asynchronous integration through a data management pipeline. This enables asynchronous and high-performing data insertion and extraction scenarios. This method is used for interactive file-based import/export and recurring integrations.
  3. Business intelligence – By using the aggregate measures available in finance and operations apps, built-in controls such as charts and integration with Microsoft Power Platform, provides reports to offer insights to business data.

Data migration from legacy or external systems
​The data management framework allows you to:
Move data between two similar systems.

  1. Discover entities and dependencies between entities for a given business process or module.
  2. Maintain a reusable library of data templates and datasets.
  3. Use data packages to create incremental data entities. Data entities can be sequenced inside the packages. You can name data packages, which can be easily identifiable during import or export. When building data packages, data entities can be mapped to staging tables in grids or by using a visual mapping tool. You can also drag-and-drop columns manually.
  4. View data during imports, so you can compare data and ensure that it is valid.