Welcome to BizTalkGurus.com!

We are a Microsoft Integration focused community site providing a place to share ideas, thoughts, and ultimately build better solutions covering BizTalk Server and Azure Integration . This site contains syndicated community blogs, learning resources, code samples, how-to videos, and forum archives from the past 19+ years of helping solve simple to complex integration issues.

Looking for Azure-focused Integration help?

Check out: AzureIntegrationGurus.com

The POWER of Community Content!

Over 19 years worth of the top BizTalk and Microsoft Integration Community Blog posts all in one spot plus new posts continuously being added.

Posts going back to February 2004!

In total, over 12,000 posts and over 5,000 forum topics.

Recent Integration Community Blog Posts

Azure Function: JSON Schema Validation

by Sandro Pereira | Jun 1, 2023 | BizTalk Community Blogs via Syndication

JSON Schema is a declarative language that allows you to annotate. It provides a format for what JSON data is required for a given application and how to interact with it and validate JSON documents to ensure it meets the requirements. Applying JSON Schemas validation...

JSON Validator Tool

by Sandro Pereira | May 30, 2023 | BizTalk Community Blogs via Syndication

Another common task for us developers inside Azure Integration Services, especially inside Logic Apps, is manually creating a JSON message, either inside a Parse JSON action, Compose action, or directly in the connectors (or any other way), but there is a catch… If...

BizTalk Mapper Extensions UtilityPack: DateTime Functoids for BizTalk Server 2020

by Sandro Pereira | May 26, 2023 | BizTalk Community Blogs via Syndication

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

PowerShell script to download a specific version of WinSCP

by Sandro Pereira | May 25, 2023 | BizTalk Community Blogs via Syndication

Today I was helping a BizTalk Server customer migrate their process from using the FTP adapter to the SFTP adapter. And if you are familiar with the BizTalk SFTP adapter, you will be aware of the painful process of choosing the correct version of WinSCP and how that...

Azure Function to read key values from Azure App Configuration

by Sandro Pereira | May 24, 2023 | BizTalk Community Blogs via Syndication

Almost 3 years ago, I wrote a blog post about How to get Key-values from Azure App Configuration within Logic Apps, and this is still valid today since we still don’t have an App Configuration Connector available out of the box. But I realize that I never blog about...

Note to myself: How to change the language in the Azure Portal

by Sandro Pereira | May 23, 2023 | BizTalk Community Blogs via Syndication

This is just another post for the sake of my mental sanity because I hate that Microsoft will induce, based on my location, that I intend for the Azure Portal to have my beloved Portuguese as the default language! Don’t get me wrong, I’m proud to be Portuguese, and I...