wcf - Use SQL Server Master Data Services to validate a record without creating it

Question

We are looking at SQL Server MDS (2019) as a potential solution to manage our master data. One of the use cases we are interested in is having a "central" validation service. We write quite a bit of custom code, and it would be useful to be able to validate data that we create centrally.

MDS provides the business rules for any entities in MDS, but so far I've only been able to validate records that were actually created in MDS. We would like to be able to validate a record/object based on the business rules in MDS, but not create it (yet). This would, for example, allow us to inform the user in the UI while they are creating the record. It would also allow business to create and manage the validation rules instead of us having to change code.

I've created a prototype using the MDS WCF service which creates a new object, validates it, and removes it. This works but if MDS provides such functionality out of the box, it would be worth looking at that instead.

Is this functionality available out of the box? If not, is there a 3rd party solution available or is the method described (create, validate, delete) a reasonable solution? I've not been able to find anything on the internet that does what we have in mind, but I might not know what to search for.

Any help or pointers are greatly appreciated.

question from:https://stackoverflow.com/questions/65860691/use-sql-server-master-data-services-to-validate-a-record-without-creating-it

Answer 1

Waitting for answers