(this post was contributed by Brian Barnett, Senior Software Engineer on the MDS Team)
In Part 1 you made the necessary model changes. In Part 2 you made the security changes to give the new groups the required security access and permissions . In this post we will continue with Step 7, configuring MDS to send out email notifications.
*Note - This post references some features that are forthcoming in the future release of MDS and not available in the CTPs. It gives you an early look at what is coming to help plan for workflow scenarios such as this.
Step 7: Configure MDS to send email notifications
Select the Start | Programs | Microsoft SQL Server 2008 R2 | Master Data Services | Configuration Manager menu item.
Select Databases in the left panel. Then select Create Profile…
On the Create Database Mail Profile and Account screen fill in the information based on your environment. The Profile name and the Account name shown below are simply suggestions I've supplied but you are free to enter different names if you choose.
There is a System Setting called "Master Data Manager URL for Notifications". The URL for your MDS application should be specified here. Once the screen is completed click the OK button. Then click the Apply button. Database Mail should be set up and ready to use.
If desired, you can test it out in SQL Server Management Studio. Expand Management then right-click Database Mail. Select Send Test E-Mail…
In Part 4 we will wrap things up by creating the business rules that drive the human workflow.