Book Image

SOA Patterns with BizTalk Server 2009

By : Richard Seroter
Book Image

SOA Patterns with BizTalk Server 2009

By: Richard Seroter

Overview of this book

SOA is about architecture, not products and SOA enables you to create better business processes faster than ever. While BizTalk Server 2009 is a powerful tool, by itself it cannot deliver long-lasting, agile solutions unless we actively apply tried and tested service-oriented principles. The current BizTalk Server books are all for the 2006 version and none of them specifically looks at how to map service-oriented principles and patterns to the BizTalk product. That's where this book fits in. In this book, we specifically investigate how to design and build service-oriented solutions using BizTalk Server 2009 as the host platform. This book extends your existing BizTalk knowledge to apply service-oriented thinking to classic BizTalk scenarios. We look at how to build the most reusable, flexible, and loosely-coupled solutions possible in the BizTalk environment. Along the way, we dive deeply into BizTalk Server's integration with Windows Communication Foundation, and see how to take advantage of the latest updates to the Microsoft platform. Chock full of dozens of demonstrations, this book walks through design considerations, development options, and strategies for maintaining production solutions.
Table of Contents (18 chapters)
SOA Patterns with BizTalk Server 2009
Credits
About the author
About the reviewers
Preface
Index

Polling for data


The original BizTalk Server SQL Server adapter supported polling of databases, but we now have a much more full-featured experience than before. For example, in the classic SQL Server adapter, the server-side stored procedures had to be authored with the BizTalk consumer in mind. A FOR XML clause was required in the procedure in order to force the results into a BizTalk-friendly XML format. To see how that experience has been changed, let's look at how to poll our BatchMaster table and yank the relevant records into BizTalk Server.

Once again we return to the Consume Adapter Service window. If you remember, we access this by right-clicking our project and choosing to Add a Generated Item. However, instead of simply setting the target database and server, we must now classify some additional parameters. First we must set the InboundID as part of the connection properties. This makes the connection string unique to each poller and is a requirement of the adapter for polling...