Sandro Pereira is a Portugal-based enterprise integration expert and Microsoft MVP, sharing deep technical knowledge on Azure Integration Services, BizTalk Server, cloud and on-prem integration patterns, architecture, and best practices.
19 articles from this blog
Explains how to set the correct Content-Type property when sending messages from BizTalk Server to Azure Service Bus, addressing version differences.
Microsoft's new 'Clone to Standard' feature simplifies migrating Azure Logic Apps from Consumption to Standard tiers, reducing manual effort.
Explains a critical 32-character naming limit in Azure Logic Apps Standard that can cause deployment and runtime errors due to Host ID collisions.
Explains how an empty workflow.json file can silently crash an Azure Logic App host and prevent all workflows from loading, with solutions.
Troubleshooting guide for resolving a WinSCP assembly loading error in BizTalk Server's SFTP adapter, including version compatibility and installation steps.
A PowerShell script automates installing the correct WinSCP version for BizTalk Server 2016/2020, eliminating manual version checks and errors.
Azure Logic Apps designer's 'Run with payload' feature currently enforces JSON-only input, preventing manual testing of workflows expecting XML or other content types.
Guide to configuring BizTalk Server's native backup jobs to store database backups directly in Azure Blob Storage using SQL Server's BACKUP TO URL feature.
Explains why being an Azure Storage Account Owner doesn't grant data access and how to assign the correct Storage Data roles.
Troubleshooting guide for fixing the 'browser blocked popup' error when creating a Logic App connection in the Azure Portal.
A custom BizTalk pipeline component that extracts metadata from incoming filenames for routing and tracking, part of an open-source utility pack.
A guide to creating a custom BizTalk send pipeline component for dynamic outbound file naming using XPath and timestamps.
Introduces a BizTalk Server pipeline component for archiving outbound messages in a structured YYYY/MM/DD folder format for auditing and troubleshooting.
Logic Apps designer can now detect and combine consecutive variable initialization actions into a single block for cleaner workflows.
Microsoft announces a major redesign (v4) of the Azure Logic Apps designer in Public Preview, featuring a cleaner layout, draft mode, and workflow notes.
Logic Apps' Initialize variables action has a limit of 20 variables per action, with workarounds and best practices for cleaner workflows.
Explains security, authentication, and parameter passing between parent and child Azure Logic Apps, covering Consumption vs. Standard plans.
Explains the differences between Call and Start Orchestration in BizTalk Server, detailing parameter types and direction options.
Explains how Azure API Management can directly publish messages to Azure Service Bus using a managed identity and a specific policy.
