Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Overview of this book

Table of Contents (18 chapters)
Microsoft SQL Server 2008 R2 Master Data Services
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

SharePoint workflow integration


This section looks at extending the SharePoint 2010 workflow created in Chapter 7, Business Rules and Workflow, to allow data to be written back to MDS. In this example, we will return the approval status for a new store back to MDS, demonstrating that we can automatically update members in MDS directly from SharePoint. To get started with this example we will need the completed exercises from Chapter 7, which we will then extend.

To begin, we must understand the XML that MDS sends to an external workflow. The following shows an example of this structure:

<ExternalAction>
  <Type>SPWF</Type>
  <SendData>1</SendData>
  <Server_URL>http://localhost:8888/</Server_URL>
  <Action_ID>StoreApprovalWorkflow</Action_ID>
  <Model_ID>5</Model_ID>
  <Model_Name>Store</Model_Name>
  <Entity_ID>12</Entity_ID>
  <Entity_Name>Store</Entity_Name>
  <Version_ID>5</Version_ID...