January 11, 2021 Weekly Update on Microsoft Integration Platform & Azure iPaaS

January 11, 2021 Weekly Update on Microsoft Integration Platform & Azure iPaaS

Do you feel difficult to keep up to date on all the frequent updates and announcements in the Microsoft Integration platform and Azure iPaaS?

Integration weekly updates can be your solution. It’s a weekly update on the topics related to Integration – enterprise integration, robust & scalable messaging capabilities and Citizen Integration capabilities empowered by Microsoft platform to deliver value to the business.

Microsoft Announcements and Updates

Community Blog Posts



How to get started with iPaaS design & development in Azure?

  • Robust Cloud Integration with Azure
  • Microsoft Azure for Developers: What to Use When
  • Serverless Computing: The Big Picture
  • Azure Logic Apps: Getting Started
  • Azure Logic Apps: Fundamentals
  • Microsoft Azure Developer: Creating Enterprise Logic Apps
  • Microsoft Azure API Management Essentials
  • Azure Functions Fundamentals
  • Cloud Design Patterns for Azure: Availability and Resilience
  • Architecting for High Availability in Microsoft Azure


Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

The post January 11, 2021 Weekly Update on Microsoft Integration Platform & Azure iPaaS appeared first on Hooking Stuff Together.

BAM Portal: You are not authorized to view this page due to invalid authentication headers.

BAM Portal: You are not authorized to view this page due to invalid authentication headers.

I know, BAM Portal is deprecated in BizTalk Server 2020 but it is still available and until there is no better alternative – you can always use BizTalk360 – it is better than nothing.

Yesterday while I was once again playing with BAM in BizTalk Server 2020 I ended up having the following error message while trying to access to BAM Portal:

HTTP Error 401.2 – Unauthorized

You are not authorized to view this page due to invalid authentication headers.

That was a bit strange since normally Everyone has access to BAM Portal, what normally can happen is that they don’t see any BAM View to explore.


For me, it was clear that this error was somehow related to the user-authentication methods/protocols installed on IIS. So I went to check the available user-authentication methods on IIS and realized that was missing the most critical method for BAM Portal to work: Windows Authentication.

BAM Portal requires Windows Authentication to work correctly.

This error is not related


This issue is very simple to fix. Windows Authentication was not available as an option, so we have to install it, and to do that you need to:

  • Start by running the Server Manager, if it is not already open, on the Windows Start menu, click the Server Manager option.
  • Under the Manage menu, select Add Roles and Features (or press Add roles and features under the Dashboard panel).
  • On the Before You Begin screen, click Next.
  • On the Installation Type screen, select Role-based or feature-based installation and click Next.
  • On the Server Selection screen, select the appropriate server, leave the default options, and click Next.
  • On the Server Roles screen, expand the Web Server (IIS) > Web Server > Security options.
    • Make sure that you select Windows Authentication option
    • Click Next.
  • On the Features screen, click Next.
  • On the Confirmation screen, click Install

Now if you try you will be able to successfuly access to BAM Portal

The post BAM Portal: You are not authorized to view this page due to invalid authentication headers. appeared first on SANDRO PEREIRA BIZTALK BLOG.

Notes From The Road: 2020 Year In Review

Notes From The Road: 2020 Year In Review

I sincerely believe that humankind has faced worse years than in 2020. Nevertheless, this was probably the most challenging, exhausting, and difficult year of our generation. When the pandemic hit, and we were forced to be locked down at home, everything change, and we have to struggle between: 

  • Both parents working from home. We were not prepared, i.e., we did not have the necessary conditions at home, but that was the least of concerns, and it was relatively easier to fix. I ready had my office at home, so it was a matter to extend it to fit my wife’s needs and improve the network capabilities.
  • 3 Kids with younger ages being 24 hours at home and more critical having virtual school at home, and this was truly a challenge. Once again, luckily, I have several devices, that unfortunately, many people do not have, so in terms of equipment, that was easy, the oldest get a Mac, and the youngest was entitled to a Surface Pro. the little one, fortunately, didn’t have virtual school. But to conciliate both kids having virtual school and both parents having to work, and taking care of the kids and the house… wow, that was something huge that we luckily succeeded in without causing to much stress on our family and marriage.

Briefly and in the face of adversity, I would say that this turned out to be a good year. Family until now is safe and healthy, and that is the essential thing in life. We didn’t travel this year, that is something that I miss, but we arrange other things to pass the time in family, mainly at home safely. And for that reason, renovations at home continue to happen during 2020 in order to continue to build our dream house.

But that it’s not all:

  • We increased the family by adopting a new member: a 4-year-old puppy who suffered from mistreatment and that is now is a little princess here at home and cause for great joy and children’s play
  • We started a pep project during this pandemic to reduce stress, but it ended up improving our food: a biological garden that was initially small and got bigger and bigger!
  • And my team at DevScope grew even more and we hope it will continue to grow during this year in terms of business but full of challenging and great projects worldwide. We are doing a fantastic job;

My Blog is growing every year…

With all these constraints caused by the pandemic, both in personal and professional terms, It was to imagine that I had little time to do something I like: sharing knowledge. But when you do something that you enjoy, you always find the time. It was also a way to escape from all the problems and worries that have happened and relax. So it actually was a very productive year:

  • Publish 92 new posts on my blog; This goes directly to the podium, being the second most productive year since I start my personal blog.
    • More than 392,535 visits to my blog – that’s an average of 1,075 visits per day!
    • Coming from 214 countries across the world in the past year.
      • 7 new countries compare to the previous year
    • And the countries that most visited my blog are once again the United States, followed by India, the United Kingdom, and Canada

Not bad if we compare to previous years:

  • 2019: 431,000 visits, 207countries, 43 new posts
  • 2018: 246,381 visits, 194 countries, 70 new posts
  • 2017: 210,000 visits, 167 countries, 63 new posts (migrate to a new blog)
  • 2016: 318,576 visits, 190 countries, 50 new posts
  • 2015: 350,000 visits, 184 countries, 79 new posts
  • 2014: 310,000 visits, 183 countries, 52 new posts
  • 2013: 200,000 visits, 176 countries, 79 new posts
  • 2012: 170,000 visits, 171 countries, 102 new posts
  • 2011: 91,000 visits, 61 new posts

I want to say thanks to all my readers. I appreciate all the visits to my blog, and thanks for your support.

Attractions in 2020

These are the top 10 posts that got the most views in 2020:

  1. A fish out of water: Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created with 40,532 views
  2. Microsoft Integration and Azure Stencils Pack for Visio: New major version available (v5.0.0) with 21,948 views
  3. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security with 17,420 views
  4. SQL Server Management Studio (SSMS): The Visual Studio component cache is out of date. Please restart Visual Studio with 14,256 views
  5. SQL Server detected a logical consistency-based I/O error: incorrect pageid in BizTalkMsgBoxDb database with 13,450 views
  6. Logic Apps: How to send a well-formatted HTML Email notification with Office 365 Outlook connector with 10,070 views
  7. Microsoft Flow: How to pass the SQL data table results in a Markdown-formatted table into an Email notification or Approval Requests with 8,271 views
  8. Microsoft Integration and Azure Stencils Pack for Visio: New version available (v5.1.0) with 6,964 views
  9. TypeLoadException: Could not load type ‘type name’ from assembly ‘assembly name, Version=, Culture=neutral, PublicKeyToken=…’ with 6,596 views
  10. Microsoft Integration (Azure and much more) Stencils Pack v3.0.0 for Visio with 5,122 views

And these are some of my favorite post that I enjoyed writing in 2020:

Open Source Contributions…

With all of this activity on my blog and to support my posts, I end up reorganizing and add several repositories and contributions to my GitHub account and organizations. Here are some samples:

  • Migrate all the BizTalk Server tools and Open Source Community projects to BizTalk Server 2020:
    • BizTalk Port Multiplier Tool: a tool that aims to simplify this process by allowing you to easily “clone or duplicate” an existing port (Receive Port or Send Port).
    • BizTalk Filter Finder Tool: a tool that aims to simplify the process for better understand and maintain solutions based on content-based routing. By allowing you to have a quick overview of all the artifacts, send ports, or orchestrations that have filters associated.
    • BizTalk Bindings Exporter tool: a tool that you can use to easily export a binding file from BizTalk Applications.
    • BizTalk Server SSO Application Configuration Tool: a tool that provides the ability to add and manage applications, add and manage key-value pairs in the SSO database, as well as import and export configuration applications so that they can be deployed to different environments.
    • BizTalk MapperExtensions Functoid Wizard: a Custom Functoid Project Wizard for Visual Studio 2010. It allows you to create a new Functoids project for BizTalk Server without having to create manually the project.
    • BizTalk MapperExtensions Functoid Project Template:  a Custom Functoid Project Template for Visual Studio 2019. It allows you to create a new Functoids project for BizTalk Server 2020 without having to create manually the project.
    • BizTalk Pipeline Components Extensions Utility Pack: a set of custom pipeline components (libraries) with several custom pipeline components that can be used in received and sent pipelines, which will provide an extension of BizTalk out-of-the-box pipeline capabilities.
    • BizTalk Mapper Extensions UtilityPack: a set of libraries with several useful functoids to include and use in a map, which will provide an extension of BizTalk Mapper capabilities.
  • Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack continues to be updated with new releases and getting some contributions from the community.
  • And I add brand new Repositories on my account:

Other contributions…

And if you think I stayed and contribute only on my blog, you are very wrong I perform several other publications outside my blog:

A year of on-line speaking engagements…

However, that not all! I still was able to deliver 10 virtual sessions in several conferences and User Groups worldwide on topics like BizTalk Server, Logic Apps and Power Automate:

  • Virtual Global Azure Lisbon | April 25, 2020 | Logic Apps: Best practices, Tips, and Tricks
  • Integration Use Group | May 4, 2020 |Microsoft Power Platform: Learn what Power BI + PowerApps + Power Automate + Office 365 can do for your organization
  • Integration Use Group | May 25, 2020 |Logic App: Best Practices, Tips & Tricks
  • INTEGRATE 2020 Remote | June 1-3, 2020 | BizTalk Server 2020: Migration Path
  • On-Demand | July 16, 2020 | Current Vision Enterprise Integration & Automation
  • Collabdays Lisbon | October 10, 2020 | Power Automates: Best Practices, Tips & Tricks
  • Global Microsoft 365 Bootcamp Lisbon 2020 | November 21, 2020 | Power Automates: Best Practices, Tips & Tricks
  • Global Integration Bootcamp Madrid 2020 | November 28, 2020 | BizTalk Server 2020 In Action
  • Integration Use Group | December 07, 2020 | Logic Apps: Development Experiences
  • Developer! Developer! Developer! (DDD2020) | December 12, 2020 | Logic App: Best Practices, Tips & Tricks

For all of you…

Once again, thanks for following me, for reading my blog, and I promise that I will continue to share my knowledge during 2021.

The post Notes From The Road: 2020 Year In Review appeared first on SANDRO PEREIRA BIZTALK BLOG.