IntroductionOn a day to day basis, a BizTalk administrator must perform few monotonous activities such as terminating instances, enabling receive locations, ensuring the status of SQL jobs etc. BizTalk360 has few powerful features which help you to automate such monotonous tasks. These features are hidden gems and are overlooked by many BizTalk360’s users, despite the availability of a good documentation. That prompted me to start my new blog series called “Automating BizTalk administration tasks using BizTalk360”. In this blog series, I will be explaining these automation capabilities which BizTalk360 brings to its users.
What is Data Monitoring in BizTalk360?As we are aware, BizTalk collects a diverse set of data into message box database, tracking database, BAM primary import and ESB databases. BizTalk360 brings all these data into a single console and on top of that provides a powerful capability to set alerts based on various thresholds. This feature is called data monitoring. Below is a screenshot that shows all different data sets which can be used in data monitoring feature. Below table briefly explains various types of data items which could be monitored.
Data monitoring category
|Process Monitoring||With process monitoring you will be able to monitor the number of messages being processed by receive ports, send ports. This is popularly also called as “non-event monitoring” Ex: if you want to alert when less than 50 messages received in an hourly window during business hours, then process monitoring is the best fit. Refer the assist article Process Monitoring for more information.|
|Message Box Data monitoring||With this you will be able to set alerts on the number of suspended, running, dehydrated messaging instance. Refer the assist article Message Box Data Monitoring for more information.|
|Tracking Data Monitoring||With this you can set alerts on tracked messaging events and tracked service instances. Refer the assist article Tracking Data Monitoring for more information.|
|BAM Data Monitoring||With this you can set alerts on the data stored in BAM tables. Refer the assist article BAM Data Monitoring for more information.|
|EDI Data Monitoring||With this you can set alerts on the EDI and AS2 reporting data stored in BAM tables. Refer the assist article EDI Data Monitoring for more information.|
|ESB Data Monitoring||With this you can set alerts on the ESB data and exceptions stored in BAM and ESB tables. Refer the assist article ESB Data Monitoring for more information|
|Logic Apps Metrics Monitoring||With this you can set alerts on metrics emitted by Logic apps. Refer the assist article Logic Apps Metrics Monitoring for more information|
Message Box Data Monitoring ActionsIn Message Box Data Monitoring, the user can configure the queries to monitor service instances and messages. Monitoring service will send the notification to the users whenever the service instances/Messages count violates the threshold condition. Message Box Data Schedule can be configured in Data Monitoring > Message Box Data. It can be scheduled at the different frequencies (Daily, Weekly, and Monthly) based on the volume and priority to take the action on service instances/messages.
Query ConditionBizTalk360 provides Highly advanced query builders for selecting the precise and expected suspended instances based data-result. While querying the suspended/All In-Progress Service Instances you can apply the filters like Error Code, Application, Service Class, Service Name etc.
A Message-Context based query is been provided by BizTalk360 for higher business-friendly scenarios. In Message payload, context/promoted properties can be selected to know the transactional message. In Data monitoring schedule the user can choose which context promoted properties to be in an email alert.