How To Create A D365 Data Entity

Learn how to create a D365 Data Entity in Visual Studio. Then, see it within the Data Management workspace.
#Dynamics365 #Dynamics365Musings #MSDyn365 #MSDyn365Community #DYN365O #D365FO #Microsoft #d365ug #xppgroupies #D365 #DataEntity #DataEntities #Integration

Subscribe to my channel:

00:00 - Intro
00:08 - How To Create A D365 Data Entity
01:43 - Example Data Entity
04:18 - Create A New Project
04:46 - Set Model
06:35 - Synchronize Database On Build
07:16 - Add New Data Entity
08:33 - Set data source and public entity name
11:06 - Add Fields
14:26 - Data entity properties
16:14 - Entity Key
16:51 - Modifying A Data Entity
17:19 - Update Staging Table
18:21 - Regenerate Staging Table
18:48 - Build Solution
19:36 - Data Management Workspace
20:41 - Conclusion
21:01 - Outro

[froggio]

Thank you Peter Ramer
for awesome video !

[Unkown-w]

Please keep doing more videos on D365 FO

[kagiv]

Shared with colleagues - great tutorial. I'm new in d365 entity world, this is huge help. Thanks!!

[qamarabbas]

@Peter Ramer Thank you so much for awesome video

[JocRaptor]

Please do examples with Computed columns and multiple companies. Thanks a lot!

[ManishRaj-iqtp]

Great, Could you please create a playlist including
1. Create a project
2. Create a model
3. Create a submenu and table
4. Build a package
5. Deploy a package in different environments.
6.Integration with azure blob storage.

[fusionermx]

Great Work... Any plans on how to develop Composite Data Entities. The Topic of BYOD is also part of Data Entities.

[dhanushr]

Can you post videos on Computed Column and Virtual field peter. That would be really helpful

[andreslopez]

This is my first time creating data entities in Dynamics 365 F&O.

I have created a customized model, then a project, and my customized table.

I created the data entity, however, when I compile I'm getting errors: dataAreaId is reserved for system fields.
To name one amongst several errors of the same kind.

What I did just about creating the entity was also selecting the following fields: dataAreaId, createdBy, createdDateTime, modifiedBy, and modifiedDateTime.

In order to solve this issue I had to delete all the objects related to the entity I created including the entity as well, then recreate the entity without selecting the mentioned fields above.

I rebuild again my whole project, and this time I got no compile errors.

In short, system fields cannot be used in data entities?

Another question:
As a prerequisite, does the table serving as the datasource for the entity must have a unique key? and the unique key must be selected in the primary index and cluster index properties for the table?

[abbasthegreat]

How to publish this data entity from dev environment to test environment or production?

[SebTheChosen]

I am trying to create a data entity for an extended table i have created (I have extended HcmWorker). But i can´t choose my extended table as data source master and it is not showing as related if i choose hcmWorker. Do you know what i am doing wrong?