O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required