Module 3: Creating Maps

Module 3:Creating Maps

Overview • Lesson 1: Creating a BizTalk Map • Lesson 2: Configuring Basic Functoids • Lesson 3: Configuring Advanced Functoids

Lesson 1: Creating a BizTalk Map • What Is a BizTalk Map? • Creating a Map by Using the BizTalk Mapper • Creating Links • Basic and Complex Map Links • Validating, Testing and Debugging a Map • Demonstration: Creating and Testing a BizTalk Map

What Is a BizTalk Map? PO Status Date PO ItemID Qty UnitPrice A map defines the correspondence between records and fields in two different schemas Data Transformation Data Translation Perform computational and other data operations Copy the data from one message to another Map Destination Schema Source Schema PurchaseOrder PO_Number Date Item_No Quantity Change the format of data between messages Example: translate between a flat file and an XML file Order_Status

Creating a Map by Using the BizTalk Mapper BizTalk Mapper Integrated within Visual Studio Starts when a map is opened or added toa project Source and destination schemas must be part of the project or contained in a referenced assembly SourceSchema Map Grid DestinationSchema

Creating Links Record Record Record PO Status Status ItemID ItemID Item PO Status PO Order PO No Date Item No Order PO No Status Flag Item No Order Status Item PO

Basic and Complex Map Links Order PO Item Record Items PO_Number PO ItemID Qty Date UnitPrice Field1 Field2 ID Status Status Date Item_No Quantity Order_Status Order PO_Num Date Detail FieldA FieldB

Validating, Testing and Debugging a Map

Demonstration: Creating and Testing a BizTalk Map In this demonstration, you will see how to: • Use the BizTalk Mapper • Add source and destination schemas to the map • Create a simple link • Automate multiple links • Test and validate a map

Lesson 2: Configuring Basic Functoids • Data Manipulation with Functoids • Using Basic Functoids • Adding Functoids to a Map • Using Map Grid Pages • Demonstration: Adding Functoids to a Map

Data Manipulation with Functoids Record PO Date Status UnitPrice ItemID Qty Functoids Map Destination Schema Source Schema Use to manipulate mapped data Can use predefined functoids or create custom functoids Custom functoids can call scripts Order (..) PO Number Date Item No Quantity X Order Status Total Price

Using Basic Functoids

Adding Functoids to a Map 2 Link functoids to fields 1 Drag functoid from Toolbox to map 3 Configure functoid inputs

Using Map Grid Pages Record Status Date PO UnitPrice Qty ItemID Use pages to reduce complexity of a map Grid Pages Grid Preview Create up to 20different pages Isolate different partsof a map Work with different parts ofa map separately Must create connectedfunctoids on the same layer Destination Schema Source Schema Order (..) PO Number Date Item No Quantity X Order Status Total Price Page 1 Page 2 Page 3 Page 4 Find and work with a portion of a large map

Demonstration: Adding Functoids to a Map In this demonstration, you will see how to: • Create multiple map pages • Add basic functoids to a map

Lesson 3: Configuring Advanced Functoids • Using Advanced Functoids • Using Looping Functoids • Using Database Functoids • Using a Scripting Functoid • Demonstration: Configuring Advanced Functoids

Using Advanced Functoids Use Advanced functoids to: Manage looping records Define conditional mapping Define custom scripts Copy the entire elements of data

Using Looping Functoids Looping functoids include: Looping functoid Index functoid Record Count functoid Table-driven functoids: Table Looping functoid Table Extractor functoid

Using Database Functoids Database functoids Used to extract data from a database Uses ADO datasets Database functoids include: Database Lookup Error Return Format Message Value Extractor

Using a Scripting Functoid Scripting functoid Use when standard functoids do not providerequired results Can call an external .NET assembly Supported languages Visual Basic C# JScript XSLT XSLT Call Template

Demonstration: Configuring Advanced Functoids In this demonstration, you will see how to: Use a Looping functoid Use a Record Count functoid

Lab: Creating a BizTalk Map Exercise 1: Creating a Map Exercise 2: Adding Basic Functoids to a Map Exercise 3: Adding Database Functoids to a Map

Module 3: Creating Maps