BizTalk Mapper Extensions UtilityPack: Database Functoids for BizTalk Server 2020

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.

BizTalk Mapper Extensions UtilityPack for BizTalk Server 2020

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 RepositoryBizTalk Mapper Extensions UtilityPack

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published. Required fields are marked *


Back to Top