Pro Mapping in BizTalk Server 2009

Contents at a Glance

Contents

About the Authors

About the Technical Reviewer

Acknowledgments

Introduction

Who This Book Is For

How This Book Is Structured

Conventions

Prerequisites

Downloading the Code

Contacting the Authors

Creating a Simple Map

Using the Development Studio

Creating the Map

Summary

How BizTalk Maps Work

Understanding How BizTalk Maps Work

Examining the Hidden Constructs in Maps

Digging into the HelloWorld Map Rules

Summary

Using Scripting in Maps

Choosing Between Scripts and Functoids

Selecting from Available Scripting Languages

Choosing Your Scripting Language

Combining Types of Scripting

Examples of When You Should Use a Script

Summary

Testing BizTalk Maps

Incremental Testing

Addressing Architecture Considerations

Test Data

Testing in the Map Editor

Summary

Mapping Conditionals

Checking If Data Exists

Blocking Output When Data Doesn’t Exist

Checking If a Specific Condition Exists

Checking If a Specific Condition Does Not Exist

An If/Else Condition

Using the Logical OR for a Single Return Value

Using a case Statement

Summary

Dealing with Numbers

Is This a Number?

Is This Number an Integer?

Rounding Numbers

Summing Numbers

Counting Records

Converting Real Numbers to Integers (and Back Again)

Moving the Sign to a Trailing Position

Converting a Number to or from Sign-Trailing Overpunch Format

Summary

Manipulating Strings

Trimming Strings

Trimming Nonblank Characters from a String

Padding a String

Selecting Substrings from String Data

Concatenating Strings

Searching String Data

Removing and Replacing Characters from Strings

Using the RegEx Function to Remove Garbage from a String

Summary

Manipulating Dates and Times

BizTalk Date and Time Functoids

Altering the Format of a Date

Calculating a Due Date

Comparing Date Intervals

Performing Time Zone Conversions

Converting Gregorian Dates to Ordinal Dates

Converting Ordinal Dates to Gregorian Dates

Converting Dates and Times Using the ParseExact Method

Getting Dates and Times for an XSLT Script

Summary

Collecting Data

Collecting Nonlooping Data from the Source

Collecting Looping Data from the Source

Modifying the Target Schema for Data Collection

Using Global Variables for Data Collection

Loading a Unique List from Input Data

Arrays vs. Hash Tables

Using an Array to Control Data Selection for Output

Summary

Accessing External Data

Using External Flat Files

Using the BizTalk Database Functoids with External Data

Locating External Files with Path Names and Connect Strings

Summary

Using Basic Looping Controls

Understanding Loops

Understanding BizTalk Mapping Engine’s Basic Looping Concepts

Limiting the Output of a Loop

Forcing Looping in the Output

Simultaneously Forcing and Limiting a Loop

Many-to-One Looping

One-to-Many Looping

One-to-Nested Looping

Nested-to-One Looping

Summary

Handling Advanced Looping

Many-to-One Looping with a Source Child Loop

One-to-Many Looping with a Child Target Loop

Summary

Introducing Electronic Data Interchange (EDI)

EDI Standards-Based Transactions

Versions and Releases

Using the Basic Building Blocks of EDI Messages

Exploring X12 Interchanges

Exploring EDIFACT Interchanges

Illustrating the Differences Between X12 and EDIFACT

Summary

Exploring EDI Looping

Looping from EDI to an Application

Looping from an Application to EDI

Summary

Processing EDI Code Pairs

Introducing EDI Code Pairs

Handling ID Codes in X12 REF and EDIFACT RFF Segments

Using a Recursive XSLT Call Template to Process Code Pairs

Using Nested XSLT Call Templates to Process Code Pairs

Multiple Code Pair Positions in a Single Segment

Creating Code Pairs in EDI Output

Summary

Unraveling the SDQ Segment

Exploring the SDQ Segment

Mapping Inbound SDQ Data

Mapping Outbound SDQ Data

Summary

Taming the Dreaded 856 ASN HL Loop

Exploring the HL Loop

Planning to Map the HL Loop

Mapping an Inbound 856

Mapping an Outbound 856 ASN

Creating the Simple Outbound 856 ASN

Summary

Building Custom Assemblies and Functoids

Deciding to Use a Custom Assembly or Custom Functoid

Creating an External Assembly for Date Conversion Functions

Building a Custom Functoid

Adding More Functoids

Doing a Custom Database Lookup

Summary

Examples from the Fringe

Modifying Outbound EDI Envelope Data

Building BizTalk Maps Outside the Map Editor

Breaking Up Large Strings Using Table Looping

Summary

Index