BizTalk Mapper Extensions UtilityPack: Database Functoids for BizTalk Server 2020

This post was originally published here

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

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.