Power Platform Community Forum Thread Details

Hello,

As CDS is becoming more and more rich and powerful day by day with many features and soon will provide the tsql support - I am little confuse on when to choose CDS and when to consider SQL database.

Can anyone please clarify this ?

Thanks,

Categories:

Microsoft Dataverse with Power Apps

Hi @dave8,

CDS is much more than just a database. It comes with a rich set of features that are usually common to any type of system/application especially in the enterprise space. If we were to compare to traditional software design, with a database, you'll need to develop a data access layer and all, however with CDS all that is taken care of out-of-the-box and the developers just need to focus on the business and presentation layer. We can refer to CDS as a platform and even SDaaS (Software Dev as a Service). Here are just a few examples of these capabilities that you would have to custom build yourself or use custom frameworks with SQL: