Using Functoids in the BizTalk 2013 Mapper
This course presents a deep-dive exploration of the BizTalk Mapper toolbox, especially the powerful built-in components that enable complex message transformations via a drag 'n' drop design grid.
What you'll learn
The Mapper is one of the keystone tools included with BizTalk Server 2013, featuring an intuitive graphical design interface for constructing message transformations. Included with the Mapper is a comprehensive set of drag 'n' drop components, called Functoids, which assist in performing complex operations on the data and the message structure. This course presents a deep-dive exploration of these components and will greatly assist developers in leveraging the powerful capabilities they afford.
Table of contents
- Introduction 2m
- String Concatenate, Uppercase, Lowercase, & Size 4m
- String Trimming, Extraction, & Searching 5m
- DEMO: String Functoids 10m
- Date/Time Functoids 3m
- DEMO: Date/Time Functoids 3m
- Logical Equality 4m
- Logical Greater Than | Less Than 2m
- Logical AND | OR 3m
- Logical String | Numeric | Date 3m
- Logical NOT | Existence | Nil 3m
- DEMO: Logical Functoids 9m
- Summary 1m
- Introduction 1m
- Cumulative Sum & Scoping 5m
- Cumulative Minimum, Average, & Concatenation 4m
- DEMO: Cumulative Functoids 6m
- Addition, Subtraction, Multiplication, & Division 5m
- Other Mathematical Operations 5m
- DEMO: Mathematical Functoids 7m
- Sine, Cosine, and Tangents 4m
- Exponents & Logarithms 4m
- Conversion Functoids 4m
- Summary 1m
- Introduction 1m
- Overview of the Database Functoids 3m
- Performing General Lookups 3m
- Lookup Best Practices 3m
- Cross-Referencing Overview 6m
- Cross-Referencing by Value 3m
- Cross-Referencing by ID 4m
- Formatting Messages 2m
- DEMO: Populating the XRef Database Tables 7m
- DEMO: Using the Cross-Reference Functoids in the Mapper 11m
- Summary 1m
- Introduction 2m
- Basic Looping 2m
- DEMO: Looping Functoid 2m
- Index-Based Access 4m
- Iteration 1m
- DEMO: Iteration Functoid 2m
- Counting Records 1m
- Nil Values 2m
- Table Looping 3m
- DEMO: Table Looping Functoids 7m
- Conditional Value Mapping 1m
- DEMO: Value Mapping Functoids 2m
- Mass Copying 2m
- Assertion 2m
- Summary 1m
About the author
A Principal Consultant for Mexia, Dan is a Microsoft MVP (Azure), a Microsoft Certified Solution Expert (MSCE), and a Microsoft Certified Technical Specialist (MCTS) in BizTalk Server 2010. An enterprise integration specialist, Dan founded the Brisbane BizTalk User Group in 2005 and currently leads the Brisbane Azure User Group. He’s also a Microsoft Certified Trainer (MCT). During his many years of experience in the Australian IT industry, he has helped a number of large private and government ... more