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
dynamics365musings.com/create...
Subscribe to my channel:
/ @peterramer
Related Blog: dynamics365musings.com
LinkedIn: / peter-ramer
Twitter: / peter_ramer
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 !

[@peterramer]

My pleasure!

[@dineshbollineni]

Please keep doing more videos on D365 FO

[@juanjo29786]

Thank you Peter, you are the best.

[@JocRaptor]

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

[@ManishRaj-iq2tp]

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.

[@bichnguyen1517]

❤ thank you

[@qamarabbas9921]

@Peter Ramer Thank you so much for awesome video

[@peterramer]

My pleasure!

[@fusionermx]

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

[@dhanushr2748]

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

[@JocRaptor]

I was about to comment the same, that would be great. I have an issue, my entity only exports the data of the computed column for the company assigned to the user at the moment, I need to download the data of all the companies at the same time.

[@abbasthegreat5]

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

[@MrRedk1ng]

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?

[@andreslopez5962]

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?

[@peterramer]

Hi. Thank you for your questions. You can add the system fields to your data entity. However you need to name them something slightly different because those names are already being used by the system fields on the data entity. So you can’t both have a data entity DataAreadID that is hidden and a field named DataAreaID that reads from the table. So you need to name the fields you create with a different name and then in the properties you can still point it to the underlying table’s DataAreaID. Same with the other system fields. In regards to you unique key question: Yes, you typically want to have a table with a unique index and add that same index to the data entity. You don’t always have to. But most of the time you will want to. I recommend looking at some of the existing data entity indexes and follow what they do.

[@andreslopez5962]

@@peterramer Thanks, I will.