Today we will focus on another set of libraries available for BizTalk Server 2020: Database Functoids. This is part of the BizTalk Mapper Extensions UtilityPack project migration task I been doing in the last few days.
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 inputs 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 inputs parameters:
BizTalk Mapper Extensions UtilityPack
BizTalk Mapper Extensions UtilityPack is a set of libraries with several useful functoids to include and use it in a map, which will provide an extension of BizTalk Mapper capabilities.
Where to download?
You can download this functoid along with all the existing one on the BizTalk Mapper Extensions UtilityPack here:
BizTalk Mapper Extensions UtilityPack
GitHub
