This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 42%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Hello,
As I have been following Upload by Script method to load data into SQL Server MDS but unable to achieve the last and the foremost step that is how to apply MDS Business Rule Validations step from SQL backend after data load in SQL Server MDS.
I've followed multiple blogs to implement but I'm unable to find any proper solution for the above scenario.
Does anyone have any thoughts of what could be the correct approach to apply Business Rule Validations from SQL that could directly reflect to MDS frontend UI ?
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Prateek Gupta,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @Prateek Gupta,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
I have referred to your solution - https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/
Unfortunately it didn't resolve my query.
Good Day !
Apologies for delay in response.
I have referred to your solution - https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/
Unfortunately it didn't resolve my query.
My task is to load the data from SQL Server MDS Backend database which should result and reflect data to MDS Frontend UI (~ I have achieved this step), my main concern is I'm unable to achieve the last and the foremost step that is how to apply MDS Business Rule Validations step from SQL backend after data load in SQL Server MDS Backend database.
Let me know if anything is unclear.
Best regards,
Prateek
Hi @Prateek Gupta,
Please refer to this blog:
https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".