While migrating old BizTalk Server Visual Studio solutions into the latest version, in this case from BizTalk Server 2016/Visual Studio 2015 to BizTalk Server 2020/Visual Studio 2019, one of the first tasks we do is to open the solution in Visual Studio 2019. By doing that, the first thing that Visual Studio does is to… Read More »

Another day, another Functoid was added to the package. I updated it again with a new functoid: Add Days to Date Functoid Functoid, which is now part of the BizTalk Mapper Extensions UtilityPack project available for BizTalk Server 2020. Add Days to Date Functoid This function allows you to add days to one date in which… Read More »

I’m adding some new BizTalk Server Functoids that I have often used these last few years in my new BizTalk Server projects. Recently, I updated this package with a new functoid, Remove Trailing Zeros Functoid, and today, I’m going to update it with another one, Replace Multiple Spaces with a Single Space Functoid, which is now… Read More »

Today, almost two years after the last update on the package, I updated it with a new functoid: Remove Trailing Zeros Functoid, which is now part of the BizTalk Mapper Extensions UtilityPack project available for BizTalk Server 2020. Remove Trailing Zeros Functoid This functoid allows you to remove any trailing zeros from the input string.… Read More »

Historically, when Microsoft announces a “platform alignment” for BizTalk Server, it typically signifies the release of a new product version. These updates ensure compatibility with the latest technologies and operating environments. For example: Each version also brings enhancements, bug fixes, and sometimes new features, though the primary focus is often on ensuring the product can… Read More »

Another session I realized I had never mentioned in my blog post—something that I’m fixing now—occurred almost two years ago when I delivered a session at INTEGRATE 2022 about Building a Hybrid Integration Solution with BizTalk Server 2020. Once again, this topic is still very relevant despite being an old technology in the eyes of… Read More »

Almost three years ago, I delivered a session at INTEGRATE 2021 about what you should and should not do while migrating your solutions to BizTalk Server 2020. Just now, I realized I had never mentioned this session and event in my blog post—something that I’m fixing now. And despite this is a old technology, this… Read More »

I wish I never had to use this adapter again, but what I desire is often not reality, and I found myself needing to install once again the old legacy SQL Adapter that has been deprecated since BizTalk Server 2006 R2 – 17 years ago! Sometimes, I regret asking Microsoft to make the Legacy SQL… Read More »

Today, after almost 3 years since I did the last update on the package, I updated it with a new suite of functoids that are now part of the BizTalk Mapper Extensions UtilityPack project available for BizTalk Server 2020: DateTime Functoids. DateTime Functoids This library includes a suite of functoids to perform several DateTime operations… Read More »

Oracle Database (commonly referred to as Oracle DBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW), and mixed (OLTP & DW) database workloads. One of the most common scenarios we face in… Read More »