Microsoft BizTalk 2010: Line of Business Systems Integration

Microsoft BizTalk 2010: Line of Business Systems Integration
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Deliver integrated Line of Business solutions more efficiently with BizTalk Server 2010 using this book and ebook.
  • Obtain pre-requisite ERP and CRM knowledge that will make your integration project successful.
  • Examine ways to integrate with leading Enterprise Resource Planning (ERP) systems like SAP and Microsoft Dynamics AX 2009.
  • Study techniques used to integrate with leading Customer Relationship Management (CRM) systems like and Dynamics CRM 2011.
  • Expand your integration capabilities into the cloud by exploring the AppFabric Service Bus. Send and receive messages via the Microsoft Cloud securely.
  • Learn from distinguished authors with hands on experience. Utilize their step by step solutions to reduce the amount of time it takes to integrate Line of Business systems using BizTalk Server 2010.

Book Details

Language : English
Paperback : 536 pages [ 235mm x 191mm ]
Release Date : July 2011
ISBN : 1849681902
ISBN 13 : 9781849681902
Author(s) : Kent Weare , Richard Seroter, Sergei Moukhnitski , Thiago Almeida, Carl Darski
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Servers, Enterprise, Microsoft

Table of Contents

Chapter 1: Consuming ASDK-based Adapters
Chapter 2: WCF LOB SQL Adapter
Chapter 3: Integrating BizTalk Server and Microsoft Dynamics CRM
Chapter 4: WCF SAP Adapter—Sending and Receiving IDOCs
Chapter 5: WCF SAP Adapter RFCs and BAPIs
Chapter 6: BizTalk Integration with Windows Azure Platform AppFabric
Chapter 7: Integrating with SharePoint 2010
Chapter 8: Integrating with SharePoint 2010 Web Services
Chapter 9: Microsoft Dynamics AX
Chapter 10: Integrating BizTalk Server and
  • Chapter 1: Consuming ASDK-based Adapters
    • Understanding the ASDK-based adapter
    • ASDK-based Adapters vs. WCF services
    • Installation
      • Installing the WCF LOB Adapter SDK
      • Installing the BizTalk Adapter Pack 2010
    • Using the ASDK development tools
      • Echo adapter
      • Building the BizTalk application
    • The WCF-Custom adapter and SOAP actions
      • Action Mappings
      • Setting SOAP actions dynamically
    • ASDK tools and features
      • Generating the schemas
      • Timeouts
      • Tracing and message logging
    • Summary
    • Chapter 2: WCF LOB SQL Adapter
      • Supported operations
        • Inbound operations
        • Outbound operations
      • Consuming ASDK SQL Adapter in Visual Studio
        • Providing credentials
        • Connecting to SQL Server URI properties
        • Binding Properties
        • Generating schemas
        • ASDK SQL Adapter in the BizTalk Administration Console
        • Inbound operations
        • Outbound operations
        • WCF-SQL vs. WCF-Custom adapter
      • ASDK SQL adapter examples
        • Example 1—TypedPolling and debatching
        • Example 2—Select, Table Valued Function, and Execute Reader
        • Example 3–Query notification and multiple result sets
        • Example 4 – Composite Operations
      • Summary
      • Chapter 3: Integrating BizTalk Server and Microsoft Dynamics CRM
        • What is Microsoft Dynamics CRM?
        • Why Integrate Dynamics CRM and BizTalk Server?
        • Communicating from BizTalk Server to Dynamics CRM
          • Integrating Directly with the Dynamics CRM 2011 SOAP API
            • Querying Dynamics CRM from BizTalk Server
            • Adding New Records to Dynamics CRM from BizTalk Server
          • Using a Dynamics CRM proxy service with BizTalk Server
            • Setup
            • Generating a proxy service
            • Building the BizTalk components
            • Configuring the BizTalk endpoints
        • Communicating from Dynamics CRM to BizTalk Server
          • Integration to BizTalk Server
            • Setup
            • Writing the Dynamics CRM plugin
            • Registering the plugin
            • Testing the plugin
        • Summary
        • Chapter 4: WCF SAP Adapter—Sending and Receiving IDOCs
          • Why do people use SAP?
            • Why do people choose BizTalk to integrate with SAP?
            • Challenges that BizTalk Developers may face
          • Installation of WCF SAP Adapter
            • 32-bit vs. 64-bit
            • SAP Prerequisite DLLs
            • WCF-SAP Adapter vs WCF Customer Adapter with SAP binding
            • Supported SAP configurations
            • IDOC schema generation
              • What are IDOCs?
              • How to generate IDOC schemas
            • IDOC Deep Dive
            • Building a BizTalk application – Sending IDOC
          • Testing BizTalk Application
          • Custom IDOCs
            • Receiving a custom IDOC from SAP
            • Testing BizTalk Application—Receiving custom IDOC
            • Receiving flat file IDOCs
          • Summary
          • Chapter 5: WCF SAP Adapter RFCs and BAPIs
            • Overview of SAP RFCs and BAPIs
              • RFCs
              • BAPIs
              • RFCs/BAPIs vs. IDOCs
                • Synchronous vs asynchronous
                • Does an out-of-box interface exist?
                • Are you trying to chain multiple events/processes together?
                • Workflow
            • Schema generation
              • Outbound operations
              • Inbound Operations
              • Calling RFCs/tRFCs hosted in BizTalk
              • Custom objects
              • Transactions
            • Custom vs. out-of-box RFCs/BAPIs
            • Building a BizTalk application—RFC walkthrough
            • Testing BizTalk application—RFC walkthrough
            • Building a BizTalk application—BAPI walkthrough
            • Testing BizTalk application—BAPI walkthrough
            • Tips, pitfalls, and troubleshooting
            • Summary
            • Chapter 6: BizTalk Integration with Windows Azure Platform AppFabric
              • What is Windows Azure AppFabric?
                • AppFabric Access Control
                  • Problem scenarios
                  • The solution
                • Service Bus
                  • Problem scenarios
                  • The solution
              • Publishing Service Bus messages to BizTalk Server
                • Scenario description
                • Building the BizTalk solution components
                  • Defining message schemas
                  • Exposing a service endpoint
                • Building the Access Control Service Components
                • Building the Token Validator WCF behavior
                • Configuring the BizTalk Service to verify claims
                • Building the service consumer
                • Creating Service Bus Access Control permissions
                • Reconfiguring a BizTalk solution to use Service Bus binding
                • Reconfiguring the Service Consumer to use Service Bus Binding
              • Publishing BizTalk Server messages to the Service Bus
                • Scenario description
                • Solution design
                • Building the Access Control Service components
                • Building the BizTalk solution components
                • Configuring BizTalk Solution to use Service Bus bindings
              • Summary
              • Chapter 7: Integrating with SharePoint 2010
                • SharePoint and BizTalk integration: Why SharePoint is better with BizTalk
                  • Capturing equipment replacement images
                  • Vehicle maintenance lists
                  • Field incident reporting
                • Understanding the components of SharePoint and BizTalk integration
                • Installation of Windows SharePoint Services Adapter Web Service
                  • FinalizeDocuments
                  • GetDocuments
                  • IsAlive
                  • PutDocuments
                • Windows SharePoint Services Adapter configuration
                  • Receive Adapter
                    • Adapter Web Service port
                    • Archive File Location URL
                    • Batch Size
                    • Namespaces Aliases
                    • Polling Interval
                    • SharePoint Site URL
                    • View Name
                  • Send Adapter
                    • Adapter Web Service Port
                    • SharePoint Site URL
                    • Namespaces Aliases
                    • Microsoft Office Integration
                    • Template Document Library
                    • Templates Namespace Column
                    • SharePoint Columns
                  • Other Considerations
                    • Context Properties
                    • Windows SharePoint Services Adapter is a one-way adapter
                • Receiving documents from SharePoint
                  • Building InfoPath Form and SharePoint Forms Library
                  • Creating SharePoint view
                  • Creating SharePoint archive library
                  • Building the application
                  • Testing the application
                • Sending documents to SharePoint
                  • Creating the SharePoint Forms Library
                  • Building the BizTalk application
                  • Testing the application
                • Summary
                • Chapter 8: Integrating with SharePoint 2010 Web Services
                  • SharePoint List overview
                  • SharePoint's List Web Services
                  • Consuming SharePoint List scenario walkthrough
                  • Creating Custom SharePoint List
                  • Custom List GUIDs
                  • Building BizTalk application
                    • Generating schemas for SharePoint Web Service
                    • Orchestration initialization
                    • Mapping SharePoint request
                    • SharePoint's unstructured responses
                    • ERP flat file
                  • Deploying and configuring the BizTalk solution
                  • Testing BizTalk application
                  • Other ways to integrate with SharePoint
                    • SharePoint Client Object Model
                    • SharePoint REST services
                    • Business Connectivity Services (BCS)
                    • Determining the right solution
                • Summary
                  • Chapter 9: Microsoft Dynamics AX
                    • What is Dynamics AX?
                    • Methods of integration with AX
                    • Installing the adapter and .NET Business Connector
                    • Configuring Dynamics AX 2009 Application Integration Framework for BizTalk Adapter
                    • Synchronous walkthrough example—currency exchange rates
                      • Dynamics AX schemas
                        • Dynamics AX query message
                        • Dynamics AX create message
                        • Orchestration setup
                      • Port configuration
                    • Asynchronous walkthrough example—Dynamics AX message outflow
                      • Message setup
                      • Orchestration setup
                    • Port configuration
                    • Batch setup in Dynamics AX
                  • Using the .NET business connector
                  • Other development and configuration notes
                    • Development
                    • Configuration
                    • Maintenance
                  • Summary
                    • Chapter 10: Integrating BizTalk Server and
                      • What is
                      • Why integrate and BizTalk Server?
                      • Communicating from BizTalk Server to
                        • Configuring the foundational BizTalk components
                        • Customizing data entities
                        • Consuming the WSDL in BizTalk Server
                        • Configuring BizTalk messaging ports to call
                        • Testing the application
                      • Communicating from to BizTalk Server
                        • Sending outbound messages from to BizTalk Server
                          • Configuring a workflow with Outbound Messaging
                          • Building the BizTalk recipient of the Outbound Message
                          • Triggering the outbound message from
                        • Querying BizTalk Server from
                          • Building the cloud-enabled REST service proxy
                          • Building a Visualforce page that consumes the cloud service
                      • Summary

                      Kent Weare

                      Kent Weare was born in Regina, Saskatchewan, Canada. He developed a love for ice hockey, football, and technology. He attended the University of Regina, where he obtained a Degree in Computer Science. After completing his undergraduate degree, he spent time in India completing a Post Graduate diploma in Object Oriented Technology. Recently, Kent has decided to pursue a Master's Degree in Information Management from Arizona State University. He currently lives in Calgary, Alberta, Canada but remains a die-hard Saskatchewan Roughrider football fan. Kent began his career at a small Internet startup before taking on a junior role with the Saskatchewan Government. Since then, he has worked on projects for the Canadian Federal Government, a multinational bank in the United States, health care projects in Eastern and Western Canada, and has spent the last eight years employed in the Energy/Utilities sector in Calgary. Kent's current role as a senior enterprise architect involves setting the technical direction for the organization and is very involved in cross-domain disciplines such as Integration and Mobility. During Kent's time at the Federal Government, he had an opportunity to participate in his first BizTalk project. Ten years later, he is still "hooked" on BizTalk, having worked with every BizTalk version released since then. In 2008, Kent was awarded his first Microsoft MVP award for BizTalk Server. He continues to be active in the BizTalk community and recently, received his sixth consecutive MVP award. Kent maintains active blogs at and He may also be seen presenting BizTalk-related material at local and international user groups. Recently, Kent has co-authored two BizTalk books: Microsoft BizTalk 2010: Line of Business Systems Integration and (MCTS) and BizTalk Server 2010 (70-595) Certification Guide.

                      Richard Seroter

                      Richard Seroter is a solutions architect for an industry-leading biotechnology company, a Microsoft MVP for BizTalk Server, and a Microsoft Connected Systems Advisor. He has spent the majority of his career consulting with customers as they planned and implemented their enterprise software solutions. Richard worked first for two global IT consulting firms, which gave him exposure to a diverse range of industries, technologies, and business challenges. Richard then joined Microsoft as a SOA/BPM technology specialist where his sole objective was to educate and collaborate with customers as they considered, designed, and architected BizTalk solutions. One of those customers liked him enough to bring him onboard full time as an architect after they committed to using BizTalk Server as their enterprise service bus. Once the BizTalk environment was successfully established, Richard transitioned into a solutions architect role where he now helps identify enterprise best practices and applies good architectural principles to a wide set of IT initiatives.

                      Richard maintains a semi-popular blog of his exploits, pitfalls, and musings with BizTalk Server and enterprise architecture at

                      The authors have provided a website with further information about the book here:


                      Sergei Moukhnitski

                      Sergei Moukhnitski is a software architect with 15 years of experience developing software and systems. His area of professional interests is business process and integration technologies applied to ERP and CRM systems such as Microsoft Dynamics and SAP.

                      Thiago Almeida

                      Thiago Almeida is a Senior Integrations Consultant for one of New Zealand’s largest IT service providers. He has over eight years of experience working as a solutions architect and senior developer on projects for some of the country’s largest companies. Thiago has been awarded Most Valuable Professional in BizTalk from Microsoft in 2009 and 2010 to acknowledge his exceptional contributions to the BizTalk Server technical community. He runs the Auckland Connected Systems User Group, being a frequent speaker, and maintains a blog on BizTalk Server at He is also a Microsoft Connected Technology Advisor and a Microsoft Virtual Technical Solution Professional in Integration, providing advanced technical input in BizTalk Server and associated integration technologies on client engagements with Microsoft.

                      Carl Darski

                      Carl Darski is a software consultant who has diverse professional experience in sectors including telecommunications, oil & gas, power and mining. As an electrical engineer, Carl quickly recognized the growing importance of software integration technologies. He has assisted several clients in implementing BizTalk as an integration standard.
                      Sorry, we don't have any reviews for this title yet.

                      Code Downloads

                      Download the code and support files for this book.

                      Submit Errata

                      Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                      Sample chapters

                      You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                      Frequently bought together

                      Microsoft BizTalk 2010: Line of Business Systems Integration +    Practical Mobile Forensics =
                      50% Off
                      the second eBook
                      Price for both: £31.05

                      Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                      What you will learn from this book

                      • Explore some of the inner workings of the WCF LOB SDK and WCF Custom Adapter
                      • Learn how to retrieve and manipulate data using popular operations exposed by WCF SQL Adapter
                      • Understand some of the technical and political challenges of integrating with SAP
                      • Learn the difference between SAP IDOCs, BAPIs and RFCs
                      • Discover Microsoft’s AppFabric Service bus and learn how to build BizTalk solutions that complement Microsoft’s Service bus in the Windows Azure Cloud
                      • Build integrated SharePoint solutions using the Windows SharePoint Services Adapter and SharePoint Web Services
                      • Understand how to integrate with Microsoft Dynamics AX 2009 using the BizTalk adapter and .Net business connector
                      • Discover how to establish bi-directional connectivity between CRM and your on-premise services

                      In Detail

                      Microsoft BizTalk is an integration and connectivity server solution that allows businesses to connect disparate systems easily. In today’s business climate of mergers and acquisitions, more and more enterprises are forced to exchange data across disparate Line of Business systems using integration brokers like BizTalk Server 2010. What is often overlooked when integrating these systems is the pre-requisite knowledge that ERP and CRM systems demand in order to effectively integrate them. No longer is this knowledge locked up in the heads of expensive consultants. Gain an edge within your organization by developing valuable skills in the area of Line of Business integration from this book.

                      This book will show you how to integrate BizTalk with Line of Business systems using practical scenarios. Each chapter will take a Line of Business system, introduce some pre-requisite knowledge and demonstrate how you can integrate BizTalk with that Line of Business system, and then provide guidance based upon real world experience, taking your BizTalk knowledge further.

                      This book will enable you to master how to integrate BizTalk with Line of Business systems effectively. The book starts by highlighting the technical foundation of WCF-LOB adapters and the common steps and important properties pertaining to popular WCF-LOB adapters. You will then move on to an overview of how to integrate with Microsoft SQL Server using the WCF based SQL Server adapter. The book then dives into topics such as integrating BizTalk Server with Microsoft Dynamics CRM, building BizTalk/SAP integrated solutions using IDocs, the differences between IDocs and RFCs/BAPIs, and integrating BizTalk with Windows Azure AppFabric Service Bus amongst others.

                      Accelerate Line of Business system integration with Microsoft BizTalk Server 2010.


                      This book will be a tutorial that focuses on integrating BizTalk with Line of Business systems using practical scenarios. Each chapter will take a Line of Business Adapter, introduce some pre-requisite knowledge and demonstrate how you can integrate BizTalk with that Line of Business Adapter, and then provide guidance based upon real world experience, taking your BizTalk knowledge further. The book will take “perceived” daunting scenarios, like integrating with SAP, and provide readers with a clear tutorial that walks them through integrating Line of Business systems.

                      This book focuses on Microsoft BizTalk 2010; however, most of the concepts and explanations will apply to BizTalk 2006 R2 and BizTalk 2009.

                      Who this book is for

                      If you are an experienced BizTalk developer who wants to integrate BizTalk with Line of Business systems using practical scenarios, then this book is for you. A solid understanding of BizTalk at an intermediate level is required. This book assumes developers are comfortable creating schemas, maps, orchestrations, ports and messages in Visual Studio and configuring applications in the BizTalk Administration Console. However, experience in integrating with Line of Business systems is not necessarily required.

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software