question

AB-3336 avatar image
0 Votes"
AB-3336 asked AB-3336 answered

SQL server 2019 Master data services: avoid record creation

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft edited

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AB-3336 avatar image
0 Votes"
AB-3336 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.