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

Delivering master data using BizTalk


Now that we have created our Subscription Views we will see how BizTalk can be used to synchronize our changes to a subscribing system.

As mentioned at the beginning of the chapter, one of the main reasons to use BizTalk is its ability to transfer data in near real time. Other advantages of BizTalk that can be useful in an MDM scenario are:

  • Once master data has been delivered to one target system, less effort is required to deliver data to additional systems, versus a tool such as SSIS

  • Data transfer can be configured to automatically retry sending if a failure occurs

  • A wide range of out-of-the-box and third party connectors are available to products like SAP, Oracle, PeopleSoft, and Salesforce.com, for example

The examples that we will go through are entirely optional, given that not everyone will have a BizTalk server available.

The pre-requisites for this exercise are:

  • Visual Studio 2010 Professional or higher installed

  • BizTalk Server 2010 Standard Edition...