Data Management & Integration Using Data Entities – Part 1

Data Management 300x225 Data Management & Integration Using Data Entities – Part 1

Today we will review data management and integration using Data Entities in the Dynamics 365 for Finance and Operations application.

Modern enterprise organizations have interconnected devices with systems and processes that collaborate with each other and users across business functions. This helps provide an exceptional user experience and supplies the data and information to ensure the correct business decisions are being made while aiding productivity – that is where integration plays a vital role.

Dynamics 365 for Finance and Operations offers both real time (synchronous) and batch driven (asynchronous) data management and integration options depending upon user requirements. Most commonly, Data Entities are used for data management and integration. A data entity provides
conceptual abstraction and encapsulation of underlying table schemas to represent key data concepts and functionalities

These Data Entities are grouped into five types that are based on their functions and the type of data that they provide.

Data Entity Type Features Example
Parameter Based Pre-requisite setup data specific to industry and or business functional and deployment parameters for modules. Consists of tables that contain only one record where columns are value for settings. AP / AR / GL / Inv. Setups, etc.
Reference Based Setup reference data specific to industry or business processes in small quantities to enable transactions. Units, dimensions, and tax group / codes, etc.
Master Large amounts of data required for business operations that are critical for transactions Customers, Vendors etc.
Documents Business Operational Data having complex structures including header and line items. Sales Order, Purchase Order, Journals, etc.
Transaction Operational transactional data such as posted transactions which are considered as record. Pending Invoices

How to build a data entity in Dynamics 365 for Finance & Operations

Option 1: building an entity by using a wizard

The easiest way to build an entity is to start the Wizard, add a new item of type Data entity
to the project. When building an entity, start with a root data source. However, you can add additional data sources either manually by adding new data sources or by selecting a surrogate foreign key field in the root data source to automatically expand the required data sources. When the Wizard is completed it creates following:

  • Data entity
  • Staging table (optional, if data management was enabled)

Here is a step-by-step illustration:

110917 1830 DataManagem1 Data Management & Integration Using Data Entities – Part 1

110917 1830 DataManagem2 Data Management & Integration Using Data Entities – Part 1

110917 1830 DataManagem3 Data Management & Integration Using Data Entities – Part 1

110917 1830 DataManagem4 Data Management & Integration Using Data Entities – Part 1

110917 1830 DataManagem5 Data Management & Integration Using Data Entities – Part 1

Option 2: Building an entity from a table

Developers can quickly create an entity from a table, and then customize the properties, data sources, and fields later.

Right-click the table, and then select Addins > Create data entity.

110917 1830 DataManagem6 Data Management & Integration Using Data Entities – Part 1

Output:

110917 1830 DataManagem7 Data Management & Integration Using Data Entities – Part 1

In previous versions of Microsoft Dynamics AX, there were multiple ways to manage data, such as Microsoft Excel Add-ins, AIF, and DIXF. The concept of data entities merges different ways into one.

Here is a summary of the Data Entity Management Integration Scenarios:

Type of Integration

Where Used

Synchronous Integration using OData Office Integration and Third Party Mobile Apps Integration
Asynchronous Integration Interactive file-based import/export

and Recurring integrations (file, queue, and so on)

Business Intelligence Aggregate data

And Standardized key performance indicators (KPIs)

Application Life Cycle Management Data Migration using Packages (exporting and importing data packages)
The Dynamics 365 Data Integration using Common Data Services Integration and flow of data between various MS Dynamics 365 products

Stay tuned for part 2 of this series, where we will look into each of the data management and integration options in detail. Don’t miss out, be sure to subscribe to our blog!

Happy Dynamics 365’ing!

Let’s block ads! (Why?)

PowerObjects- Bringing Focus to Dynamics CRM