220 likes | 367 Views
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
E N D
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
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
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