Book Image

Microsoft BizTalk 2010: Line of Business Systems Integration

Book Image

Microsoft BizTalk 2010: Line of Business Systems Integration

Overview of this book

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.
Table of Contents (18 chapters)
Microsoft BizTalk 2010: Line of Business Systems Integration
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Creating Custom SharePoint List


Note

Note: The following example assumes you have an existing SharePoint site in place. The following links describe how to create SharePoint sites for WSS 3.0 SP2 and SharePoint 2010 Foundation:

WSS 3.0 SP2:

http://technet.microsoft.com/en-us/library/cc288969(office.12).aspx

SharePoint 2010 Foundation:

http://technet.microsoft.com/en-us/library/cc263094.aspx

We need to create a Custom List where our field workers can input their data related to their Vehicle Maintenance. BizTalk will later connect to this list and retrieve the data so that it can be sent to our ERP system.

  1. 1. We can create a Custom List by clicking on the Lists link underneath the Home menu in the SharePoint Ribbon.

  2. 2. We now want to click on the Create link.

  3. 3. Select Custom List, provide a list name of Vehicle Maintenance, and click the Create button.

  4. 4. We now have an empty list and want to create our Custom Columns by clicking on the Create Column button.

  5. 5. Add the following columns...