cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jesenavaranjan
Level: Powered On

CDS VS.SQL

Hi!

 

In general is CDS better at delegating or SQL?

 

& any other pros and cons I should be aware of?

 

Jese

3 REPLIES 3

Re: CDS VS.SQL

Can you give more detail on what you're trying to achieve, and also what you mean by 'better at delegating' ?

Many factors affect the choice between CDS and SQL, including license costs, ease of development (which depends on the developers' knowledge), functionality, performance (though this is less likely to be a main factor)

Super User
Super User

Re: CDS VS.SQL

Hi Jese,

In general, SQL Server is better. According to the help, here are the functions/operators that are delegable with SQL Server.

 

image.png

 

With the CDS, there are fewer options...

image.png

With SQL Server, we can overcome delegation problems by creating SQL Views. For example, take the non-delegable example of filtering on datetime. In this example, we can create a view and cast the day/month/year components to integers.  We now have a data source that is delegable.

With SQL Server, we can also call stored procedures with Flow (Power Automate). This helps us overcome delegation issues when updating data (for example, when calling the UpdateIf function in PowerApps).

So in my opinion, SQL Server is the better data source out of the two.

Community Support Team
Community Support Team

Re: CDS VS.SQL

Hi @jesenavaranjan ,

Actually, the delegation advance between CDS and SQL is based on which delegable functions or operators you used in your app. More details about the delegable functions supported in CDS and SQL, please check the following article:

https://docs.microsoft.com/en-us/connectors/commondataservice/#powerapps-delegable-functions-and-ope...

https://docs.microsoft.com/en-us/connectors/sql/#powerapps-delegable-functions-and-operations-for-sq...

 

In terms of data processing speed in PowerApps app, I think the CDS would be better than SQL Server. The CDS is an built-in database in PowerApps, which would have data process speed advance than other data sources.

 

More details about the CDS in PowerApps, please refer to the following article:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-intro

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,875)