agenda introduction to business rules simple in concept/ internal vs external workflow workflow...
TRANSCRIPT
![Page 1: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/1.jpg)
Business Rules and Workflow
Tyler GrahamSenior Program ManagerMaster Data ServicesMicrosoft Corporation Microsoft
SQL Server 2012®
®
![Page 2: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/2.jpg)
Agenda
Introduction to Business Rules
Simple in Concept/
Internal vs External Workflow
Workflow Extender
![Page 3: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/3.jpg)
What is a Business rule?
• Allows Data Owners to validate data without writing T-SQL
• Compiled into Stored Procedures• Uses IF..THEN Structures• Can use AND & OR Logical Operators, to
create Complex Rules up to 7 levels• Rules using OR Logical Operator can be
broken down into simpler rules• Applied to Attribute Members for it’s
validation• Can Trigger Email Notifications• Created through the MDS WEB UI
![Page 4: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/4.jpg)
Simple in Concept
Assign attribute values
• Equals or defaults to a specific value or another attribute value
• Generated number
• Concatenation of attribute values or extracts of values combinedwith text strings
Specify validation criteria
• Mandatory (required) attributes
• Set to invalid
• Ensure uniqueness in specific attributes or attribute combinations
• Valid attribute values, ranges
• Minimum or maximum length
![Page 5: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/5.jpg)
Supports Business Complexity
Business rules accommodate various requirements
• Connecting data sources; overrides
• Multi-level processes
• Workflow and approval – internal (Master Data Services) and external (e.g., SharePoint)
Multiple or compound business rules provide for more complex requirements
• Logical operators• AND• OR
Control priority of activation; enable/disable rules
![Page 6: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/6.jpg)
Internal vs. External Workflow
Simple Approval workflows do not require external actions
Use internal functions to create the approval workflows
• Change Tracking Group
• Approval Columns
• Notifications
Complex Rules or cross member analysis must use external .dll or SharePoint integration.
![Page 7: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/7.jpg)
Workflow Extender
MDSMDS WF
Listener
Service Broker Queue
SharePoint Workflow
Custom dll
Get Next Record
(Stored Procedure)
SPWF
Custom Tag
![Page 8: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/8.jpg)
Workflow Extender
![Page 9: Agenda Introduction to Business Rules Simple in Concept/ Internal vs External Workflow Workflow Extender](https://reader035.vdocuments.us/reader035/viewer/2022062423/5697bfe91a28abf838cb6d52/html5/thumbnails/9.jpg)
© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.