Should You Learn CDS vs. Standard public data entities implementation approach First?

Should You Learn CDS vs. Standard public data entities implementation approach First?

Let's look at some stats.

So you want to get into integration between Dynamics 365 CE or Custom Power Apps and Dynamics 365 FO. The question is, which type of Public Data entities are to be used from Dynamics365 FO?

As someone who's working on a list of integration approaches such as

1. Dual-write
2. Data integrator
3. Connector
4. API

Should I use Customers V2, Customers V3, or Sales Quotation Header CDS entity? What is the difference between these entities and tables?

It is always tricky to make decisions about which data entity to be used for the above-mentioned integration approaches, read on and I'll give you my thoughts.

If you deep dive more into available Dynamics 365 FO Data entities whether named with CDS or not under the hood it is connected with business transactions or master tables such as custtable, salesline etc.

As the world becomes increasingly reliant on digital platforms, it is more important than ever to ensure that application integration plays a vital role.

Integration technology is a vital component of Dynamics 365 FO and Dataverse (Dynamics 365 CE & Power Apps) such as Data connector, API, Dual-write and VirtuEntity.

There isn't a right answer, but there is a better one

Let's deep dive into CDS vs Non- CDS data entities artifacts and understand the purpose build business logic and metadata changes

1. SalesQuotationHeaderCDSEntity: The standard function/method "updatePrices" is used to invoke Odata actions via Dual-write

2. smmContactPersonCDSV2Entity: It has additional fields in comparison with standard public Data entities such as AssociatedContactNumber & AssociatedContactType

After learning the CDS data entities, one might say that it is not recommended to use CDS Data entities when there is no Dual-write infrastructure used and a possible reason may be

  1. Use standard public data entities (non-CDS) as it is

  2. Extend standard public data entities (non-CDS)

  3. Build custom public data entities for tailored-made business processes

A CDS entities are lightweight, performance-optimized entity specially designed to integrate with Dataverse - it need not be done through Dual-write but can be done through other methods such as using Data Integrator or custom integration.

In a nutshell, There is no general best practice that recommends you use CDS vs Non-CDS entities, right? Nevertheless, you may choose the following option based on the fit/gap analysis for each interface:


It is important to note that the performance and effort required for each of these options will vary. Therefore, each entity's decision should be made based on business requirements by the project team.

Thank you for Reading - Let's Connect!

Enjoy my blog? For more such awesome blog articles - follow, subscribe and let's connect on LinkedIn, Twitter, YouTube

Stay tuned!

Published on:

Learn more
Rakesh Darge's Blog
Rakesh Darge's Blog

Rakesh Darge's Blog

Share post:

Related posts

Web resource method does not exist in Dynamics 365 CE

Got the below error while working on Onload of Account record JavaScript in Microsoft Dynamics 365 CE. Script Error One of the scripts for thi...

1 day ago

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

We might have got a scenario to use the Environment Variable Value in the JavaScript in Dynamics 365 CE. In this article, will explain about r...

2 days ago

Build intelligent and scalable solutions with Microsoft Power Apps and Microsoft Power Platform 

In this blog post and the accompanying demo video, we want to highlight what is possible with Microsoft Power Apps and Microsoft Power Platfor...

3 days ago

Power Platform & M365 Dev Community Call – July 18th, 2024 – Screenshot Summary

Call Highlights   SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...

3 days ago

Dynamics 365 & Power Platform 2024 Release Wave 2 Overview

As Microsoft have unveiled their planned improvements for October 2024, we take a look at the key innovations and changes. The release plans, ...

3 days ago

Microsoft Reactor: Activate contextualised data with Microsoft Graph, Power Platform & Copilot

Hey Friends! 👋So, we're already two weeks into this, but I wanted to tell you about a series running this month which I'm sp...

3 days ago

Enhancing Business Efficiency with Dynamics 365 CE/CRM AI Capabilities

Artificial intelligence (AI) is a vital catalyst for business transformations in this digital era. A leading player in this revolution

4 days ago

Power Platform – July 2024– Screenshot Summary

Community Call Highlights   Quicklinks: Power Platform Community: Power Apps Power Automate Power BI Power Pages M365 Platform Community: http...

4 days ago

Dynamics 365 and Power Platform – 2024 release wave 2 plans available now

Exciting news for Dynamics 365 and Power Platform users! Microsoft has unveiled the 2024 release wave 2 plans for these applications, which wi...

4 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy