Watching Microsoft Common Data Model (CDM), it makes you feel it will be the "future" of database. Let's see.
While Relationships between two Entities exist via the Lookup function, Entities need (similar to Access) On Insert, On Update, On Delete ETC Macros, so to be able achieve data integrity at the DB level.
Unless Flow is meant to do this job, then Flow needs to be finetuned to be able doing it.
Thank you for your feedback. We have data integrity in CDM. For composition relationships - we have cascade delete actions implemented and for association relationships - restricted delete actions.
Hi. But if CDM Entities (tables) are the future of Microsoft database (said to be enhanced SQL), then macros are really needed. I work with Access Web Apps which use SQL Azure database and table macros there are really efficient, what replaces macros in CDM?
"We have data integrity in CDM. For composition relationships - we have cascade delete actions implemented and for association relationships - restricted delete actions."
Are you saying this is built into standard entities? How do we configure referential integrity on custom entities? All I see for relationships are lookup columns. Are you saying a required lookup column is handled as a bidirectional relationship with cascade delete enabled? What if we want to prevent delete?
We really need 'table macros' aka INSERT UPDATE DELETE triggers in SQL Server.
It's called Common Data Model, not Common Spreadsheets. Entities (table) macros are not a luxurious feature. it is a must, otherwise, better kill CDM before we get excited more than necessary. Excel is enough, we do not need another Excel.
Thanks everyone for your feedback! This idea of being able to run pre-determined control flows which could act on data, update data, etc. is an interesting and important one. We're exploring what the right features to expose here are. If you have thoughts, please post them on the Ideas forum so people can vote!
here is the link in Ideas forum.
but this does not need votes to be considered. CDM without macros (like macros in Access web apps at least) will be no more than spreedsheets. thinking of Flow, flow cannot replace Macros since Flow is paid service, and macros are macros.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand