SQL server 2019 Master data services: avoid record creation

Question

Dear all,
we are using MDS 2019, and I create a Business Rules of kind "xxx attribute is required".
Problem, is that the record, even if the concerned attribute is not filled, is created (with message validation failed, and a red exclamation point)

Is there a way to totally avoid record creation depending of this kind of business rules ?

hope I'm clear
thank you in advance.
Regards

Answer 1

Hi,

Welcome to Microsoft Q&A!

Business rules are If/Then/Else statements that you create in Master Data Manager. If an attribute value meets a specified condition, then an action is taken, otherwise a Else action is taken. Possible actions include setting a default value or changing a value. If a user attempts to add an attribute value that doesn't pass business rule validation, the value can still be saved. You can review and correct validation issues, which are displayed in Master Data Manager.

You can create a business rule to enforce uniqueness of other attributes, but business rules will not prevent data loading.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3d44e28a-1291-456b-8269-5368b5f21d17/preventing-duplicate-inserts?forum=sqlmds

Answer 2

thank you Criszhan.
This option should be appreciate I think, in order to have a lot of record with a Validation status failed
regards