Save/Archive BizTalk Server all suspended messages using PowerShell

Save/Archive BizTalk Server all suspended messages using PowerShell

No matter what you do, issues will happen at some point, and we need to deal with them. For example, on BizTalk Server, messages can get suspended for many reasons. Sometimes, we can resume these suspended messages. But, in other situations, we can’t, or no water what we do, they cannot be processed because they contain some errors that need to be fixed.

Regardless of the scenario or the reasons for this to happen, there are situations that we endup having several messages suspended on BizTalk Server. Using the out-of-the-box BizTalk Server Administration tool, we are only allowed to save one message at a time, which means that we need to go one by one and, after several clicks, save the message on the hard drive. This is a huge time-consuming operation.

To expedite these operations, we can use PowerShell. It’s true that we will need to spend a little time creating these PowerShell scripts, but the gain that we get is massive, and once made, we can use it anytime.

With this script, we can retrieve the body/payload of all suspended BizTalk Server messages and save them to a specific folder – no filters required.

The result will be a list of messages created on our hard drive:

Download

THIS POWERSHELL IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

You can download Save/archive all BizTalk Server suspended messages with PowerShell from GitHub here:

The post Save/Archive BizTalk Server all suspended messages using PowerShell appeared first on SANDRO PEREIRA BIZTALK BLOG.

Azure Integration Bootcamp | February 5, 2022 | Logic Apps: New set of Best practices, Tips and Tricks

Azure Integration Bootcamp | February 5, 2022 | Logic Apps: New set of Best practices, Tips and Tricks

As part of the Intergalactic Automation Summit 2022 online event organized by the Power Community that is taking place between 4-6th February 2022:

  • 4th Feb- Power Automate Bootcamp
  • 5th Feb- Azure Integration Bootcamp
  • 6th Feb- Power Platform ALM DevOps

All of these events are free! And you can register here.

I choose to submit a session to the Azure Integration Bootcamp, and I’m honored to be accepted as a guest speaker on a session about Logic Apps: A new set of Best practices, tips and tricks. My session will take place at 11:00 am according to GMT/UTC.

Logic Apps: A new set of Best practices, tips and tricks

As I mentioned before, my session will be all about best practices and small tips and tricks that we can apply to our Logic Apps flows. For those reasons, I would like to invite you to join me at the Azure Integration Bootcamp virtual event on Saturday, February 5, 2022.

Session name: Logic Apps: A new set of Best practices, tips and tricks

Abstract: A brand new set of tips and tricks and best practices that you should know for being more productive and building more reliable and effective Logic Apps. This is not an introduction session anymore. In this session, we will go through a list of 10 new best practices, tips, and tricks addressing advanced topics like deployment, dynamic connectors configurations, etc.

Join us and reserve your presence at the Azure Integration Bootcamp virtual event on Saturday, February 5, 2022, it is free!

The post Azure Integration Bootcamp | February 5, 2022 | Logic Apps: New set of Best practices, Tips and Tricks appeared first on SANDRO PEREIRA BIZTALK BLOG.

January 17, 2022 Weekly Update on Microsoft Integration Platform & Azure iPaaS

January 17, 2022 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

 

Videos

Podcasts

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

Feedback

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

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

Power Automate Bootcamp | February 4, 2022 | Power Automation: A new set of Best practices, tips and tricks

Power Automate Bootcamp | February 4, 2022 | Power Automation: A new set of Best practices, tips and tricks

As part of the Intergalactic Automation Summit 2022 online event organized by the Power Community that is taking place between 4-6th February 2022:

  • 4th Feb- Power Automate Bootcamp
  • 5th Feb- Azure Integration Bootcamp
  • 6th Feb- Power Platform ALM DevOps

All of these events are free! And you can register here.

I choose to submit a session to the Power Automate Bootcamp, and I’m honored to be accepted as a guest speaker on a session about Power Automation: A new set of Best practices, tips and tricks. My session will take place at 05:00 pm according to GMT/UTC.

Power Automation: A new set of Best practices, tips and tricks

As I mentioned before, my session will be all about best practices and small tips and tricks that we can apply to our Power Automate flows. For those reasons, I would like to invite you to join me at the Power Automate Bootcamp virtual event on Friday, February 4, 2022.

Session name: Power Automation: A new set of Best practices, tips and tricks

Abstract: A brand new set of tips and tricks and best practices that you should know for being more productive and building more reliable and effective Power Automate flows. This is not an introduction session anymore. Instead, this session will go through a list of 10 new best practices, tips, and tricks addressing advanced topics like deployment, dynamic connectors configurations, etc.

Join us and reserve your presence at the Power Automate Bootcamp virtual event on Friday, February 4, 2022, it is free!

The post Power Automate Bootcamp | February 4, 2022 | Power Automation: A new set of Best practices, tips and tricks appeared first on SANDRO PEREIRA BIZTALK BLOG.

Global Automation Bootcamp | February 4, 2022 | How to monitor your integrations solutions with Automation Account

Global Automation Bootcamp | February 4, 2022 | How to monitor your integrations solutions with Automation Account

As part of the Intergalactic Automation Summit 2022 online event organized by the Power Community that is taking place between 4-6th February 2022:

  • 4th Feb- Power Automate Bootcamp
  • 5th Feb- Azure Integration Bootcamp
  • 6th Feb- Power Platform ALM DevOps

All of these events are free! And you can register here.

I choose to submit a session to the Global Automation Bootcamp, and I’m honored to be accepted as a guest speaker on a session about How to monitor your integrations solutions with Automation Account. My session will take place at 05:00 pm according to GMT/UTC.

How to monitor your integrations solutions with Automation Account

In this session, we will address how you can monitor your integrations solutions using Azure Integration Account running PowerShell Runbooks and Logic Apps to notify inconsistencies in your solutions. For those reasons, I would like to invite you to join me at the Global Automation Bootcamp virtual event on Friday, February 4, 2022.

Session name: How to monitor your integrations solutions with Automation Account

Abstract: In this session, we will address how you can monitor your integrations solutions using Azure Integration Account running PowerShell Runbooks and Logic Apps to notify inconsistencies in your solutions.

Join us and reserve your presence at the Global Automation Bootcamp virtual event on Friday, February 4, 2022, it is free!

The post Global Automation Bootcamp | February 4, 2022 | How to monitor your integrations solutions with Automation Account appeared first on SANDRO PEREIRA BIZTALK BLOG.

January 10, 2022 Weekly Update on Microsoft Integration Platform & Azure iPaaS

January 10, 2022 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

 

Videos

Podcasts

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

Feedback

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

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

BizTalk Server SSO Application Configuration Web Tool

BizTalk Server SSO Application Configuration Web Tool

It’s been some time since I created the BizTalk Server SSO Application Configuration tool. The tool is available for several versions of BizTalk Server. It provides the ability to add and manage applications, add and manage key-value pairs in the SSO database, and import and export configuration applications to be deployed to different environments.

However, and although I love this tool, there is a significant limitation. It is a Windows application tool. So, most of the time, we need remote access to the BizTalk Server machines to access the tool to be able to read or change these values inside the SSO Applications.

To bypass this limitation, we create a Web version of this tool. The tool has almost the same features available as the traditional windows tool:

  • You can securely export and import Application configurations and it is compatible with MSFT SSO snap-in;
  • You can duplicate Applications (copy and past);
  • You can rename Applications;
  • You can easily add new key-values;
  • You can edit key-values;

Other versions

This tool is also available in the format of Windows Application for the following BizTalk Server versions:

Download

THIS TOOL IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

You can download BizTalk Server SSO Application Configuration Web Tool from GitHub here:

The post BizTalk Server SSO Application Configuration Web Tool appeared first on SANDRO PEREIRA BIZTALK BLOG.

BizTalk Server BAM SQL Queries: Checking who has permission

BizTalk Server BAM SQL Queries: Checking who has permission

While organizing my vast resources in my hard drive, I recently found out, polished, and improved two SQL Server queries that allow us to check the users and groups with access to BAM resources.

These are simple SQL Queries, but they are essential for maintaining your environment under control, security, and privacy standards compliance.

Generally, BizTalk Server is compatible with all the privacy standards-compliant like GDPR or FIPS. BizTalk Server is a messaging broker that doesn’t capture or store any data on its system other than for the time needed to complete business processes and connect and route messages to their target systems. However, because you can process messages and/or communicate with systems that contain sensitive data (personal data), you must have some good practices in BizTalk Server Applications to comply with privacy standards.

Business Activity Monitoring (BAM) is a collection of tools that allow you to manage aggregations, alerts, and profiles to monitor relevant business metrics (called Key Performance Indicators, or KPIs). It gives you end-to-end visibility into your business processes, providing accurate information about the status and results of various operations, processes, and transactions so you can address problem areas and resolve issues within your business. But it is also a component that can capture data from the messages passing by the systems, and some of these data can be sensitive – that shouldn’t happen, but it can happen.

So, it is always good in terms of security, control, documentation, and in some cases, privacy to know which users can access BAM data.

BizTalk Server: SQL Query to list all Users with access to BAMPrimaryImport database

This is a simple SQL Server Query that provides a list of all users that has access to the BAMPrimaryImport database.

THIS SQL SCRIPT IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

BizTalk Server: SQL Query to list all Users with access to BAM Views

This is a simple SQL Server Query that provides a list of all users access to a specific or to all BAM Views

THIS SQL SCRIPT IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

The post BizTalk Server BAM SQL Queries: Checking who has permission appeared first on SANDRO PEREIRA BIZTALK BLOG.

BizTalk Monitor Suspend Instance Terminator Service

BizTalk Monitor Suspend Instance Terminator Service

Monitoring a BizTalk Server environment can sometimes be a complex task due to the infrastructure and complexity layers behind the BizTalk Server. Apart from that, the administrator teams need to monitor all the applications deployed to the environment.

Ideally, the administration team should use all monitoring tools at their disposal, whether they are included with the product, such as BizTalk Server Administrative console, Event Viewer, HAT, or BAM. But the main problem with these tools is that:

  • They need manually intervention.
  • Almost all of them requires remote access to the environment.

When an administrator must manually check each server or application by events that may have occurred, that is not a very efficient and effective way to allocate the team’s time nor to monitor the environment.

Of course, they can also use other monitoring tools from Microsoft, such as Microsoft System Center Operation Manager (SCOM), or third-party monitoring solutions such as BizTalk360. These tools should be able to read events from all layers of the infrastructure and help the administration team to take preventive measures, notifying them when a particular incident is about to happen, for example, when the free space of a hard drive is below 10%. Furthermore, they should allow the automation of operations when a specific event occurs, for example, restart a service when the amount of memory used by it exceeds 200MB, thereby preventing incidents or failures, without requiring human intervention.

But the question is: and if you don’t have these tools?

You can archive these tasks in several ways. Many people create custom web portals to emulate some of the most basic tasks of the admin console. One of my favorite options is using a mix of PowerShell, schedule tasks, and/or Azure Services like Logic Apps and Functions. But today I will show you a different or alternative way:

  • Create a Windows Service to monitor suspended Instances and automatically terminate them

Note: of course, this solution can be expanded to other kinds of stuff or add new funcionalities.

BizTalk Monitor Suspend Instance Terminator Service

This is a Windows Service that will be continually monitoring BizTalk Server for specific suspended messages (with an interval of x seconds/minutes/hours defined on code) and termites them automatically.

This tool allows you to configure:

  • The type of suspended messages you want to terminate
  • Terminate without saving the messages or saving them to a specific folder before terminating them.

These configurations are made on the app config of the service:

<ServiceFilter>
	<add key="ServiceClass" value="64"/>
	<add key="ServiceStatus" value="32"/>
	<add key="ErrorId" value="0xC0C01B4E"/>
	<add key="Action" value="Terminate"/>
	<add key="SaveLocation" value="C:ArchiveError1"/>
</ServiceFilter>
<ServiceFilter>
	<add key="ServiceClass" value="4"/>
	<add key="ServiceStatus" value="4"/>
	<add key="ErrorId" value="0xc0c01680"/>
	<add key="Action" value="SaveAndTerminate"/>
	<add key="SaveLocation" value="C:ArchiveError2"/>
</ServiceFilter>

You can also define on the app config file the:

  • Database name, that by default is already BizTalkMgmtDb
  • and the Database Server Host Name, by default localhost

The solution available on GitHub already provides a straightforward setup file.

Download

THIS TOOL IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

You can download the BizTalk Server GetTrackedMessage tool from GitHub here:

The post BizTalk Monitor Suspend Instance Terminator Service appeared first on SANDRO PEREIRA BIZTALK BLOG.