Today, we will focus on another set of libraries available for BizTalk Server 2020: Database Functoids. This is part of the migration task for the BizTalk Mapper Extensions UtilityPack project I’ve been working on over the last few days.
📝 One-Minute Brief
Introduces the Database Functoids in the BizTalk Mapper Extensions UtilityPack for BizTalk Server 2020, enabling BizTalk maps to retrieve data directly from databases and use it during message transformation.
Database Functoids
This library includes a suite of functoids to perform a variety of database operations, mainly to extract data from a database for use in an output instance message.
This project includes the following Custom Functoids:
- Adv Database Lookup Functoid: Use the Adv Database Lookup functoid to extract information from a database and store it as a Microsoft ActiveX Data Objects (ADO) recordset.
- This functoid requires the following 3 inputs:
- a database connection string;
- A table name;
- and a WHERE clause.
- Returns a recordset containing the result records.
- This functoid requires the following 3 inputs:
- Adv Value Extractor: Use the Adv Value Extractor functoid to extract the appropriate column value from a recordset returned by the Adv Database Lookup function.
- This functoid requires two input parameters:
- a link to the Adv Database Lookup functoid;
- and a column name.
- Returns a string with the value of the specified column.
- This functoid requires two input parameters:
BizTalk Mapper Extensions Utility Pack
BizTalk Mapper Extensions Utility Pack is a set of libraries that includes several useful functoids to include in a map, extending BizTalk Mapper’s capabilities.
Download
You can download the source code and application binaries from GitHub:
Hope you find this helpful! If you liked the content or found it useful and would like to support me in writing more, consider buying (or helping to buy) a Star Wars Lego set for my son.
