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.

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

Logic Apps (Standard) Data Mapper Patterns: Aggregation Pattern

by Sandro Pereira | Jul 6, 2023 | BizTalk Community Blogs via Syndication

Basically, the Aggregation Pattern could also be another example or a subset of the Content Enricher Pattern (you can know more about this here: BizTalk Mapping Patterns & Best Practices), but sometimes when we exchange messages between different systems, we will...

Democratizing RPA with Power Automate Desktop Book Review

by Sandro Pereira | Jul 5, 2023 | BizTalk Community Blogs via Syndication

The book states: “Boost your productivity by implementing best practices for automating repeating desktop processes.”, adding that no special IT knowledge is needed for this book. And I have to say that is 100% true. It is a remarkably user-friendly book that covers a...

Azure Function to convert Google Documents (.gdoc) into Word Documents (.docx)

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

In Google Web UI Perspective, we have the option to download the Google Docs (word) files in terms of the formats. From the Logic App perspective, we can easily list files from the folder, but converting that .gdoc files into Onedrive word files (.docx extension)...

Logic App Standard local run error: Failed to verify “AzureWebJobsStorage” connection specified in “local.settings.json”.

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

Last night when I was about to deliver my Logic Apps Data Mapper session at Azure Logic Apps Community Day 2023, more or less 15 minutes earlier, I decided to do a last test run on my demos – it is always good for you to do a last-minute validation – but to be fair, I...

A fish out of water: How to check what SSIS packages are running and stop them?

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

You may already know that I usually use the series A fish out of water when I want to write something that goes a little bit off-topic on my main blog topic: Enterprise Integration. This time, and despite this, can also be considered an Enterprise Integration – ETL...

Azure Function: JSON Schema Validation (new release v3.0)

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

We just released another version of our Azure Function JSON Schema Validation, adding support to another feature. In this case, a very basic one, required fields. In order to specify the mandatory properties or elements, we need to use the required keyword, where you...