1 / 22

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

Download Presentation

Module 3: Creating Maps

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Module 3:Creating Maps

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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. Validating, Testing and Debugging a Map

  9. 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

  10. 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

  11. 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

  12. Using Basic Functoids

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

  14. 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

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

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

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

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

  19. 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

  20. 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

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

  22. 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

More Related