BizTalk360 has over 80 features bundled into a single solution to make BizTalk Server monitoring and administration super-efficient and secure. To access those features, the user must navigate to the feature via the menu. However, it takes a long time, so we improved the Pin to dashboard feature to serve as a shortcut for selecting the desired features. It allows you to pin features, artifacts, monitoring schedules, alarms, specific tabs, SQL query results, and more to Operation, Analytics, and Custom dashboards. The feature, pin to dashboard is available in the Operations, Monitoring, and Analytics sections. Let’s have a detailed view of the feature in this article.
Pin to Dashboard in V9 & V10
Before we get into the specifics of the pin to dashboard feature, Let’s look at the differences between V10 and V9.
- By default, all widgets in V9 are pinned to the operation dashboard. However, in V10, widgets can be pinned to the Operations, Analytics, and Custom dashboards.
- Only the features in V9 can be pinned. Features, artifacts, monitoring schedules, alarms, specific tabs, and other items can all be pinned in V10.
- There is no option to pin the SQL query result to the dashboard in previous versions. In the latest version V10, users can pin the SQL query result to the desired dashboard. This improvement to SQL query result pinning is available for Message Box Queries, Tracking Queries, and Secure SQL Queries.
Click here to know more about pin to dashboard feature.
Let’s look at what widgets are and how they can help us save time.
Widgets are entities in the dashboard that represent a feature or artifact. In the pin to dashboard feature, there are two types of widgets. They are
- Navigation Widget – a shortcut that allows you to navigate to a specific feature or artifact.
- SQL Query Results Widget – Displays SQL query results in a grid format.
To move to the selected feature/artifact page, use the navigation widget.
Let’s look at an example,
Rather than using the menu to access the ESB Application’s send port, pin it to the Analytics dashboard, which is monitored by BizTalk360 Default Alarm, to save time.
Fig 1.0 Pinning an ESB application’s send port artifact with the BizTalk360 Default alarm to the Analytics dashboard.
“Do you find it difficult to navigate to different features using the menu?”
In this scenario, you may pin the feature and access it by clicking on the widget rather than going through a menu. Assume you regularly utilize orchestration artifacts in the Applications feature of the Operations section. Pin the orchestration of a certain application to the dashboard of your choice. This widget makes it simple to go to the desired feature.
Fig 1.1 Pinning a Graphical Message Flow application with an orchestration artifact to the Operations dashboard
SQL Query result widget
In the dashboard, the SQL Query Result widget will display the query results in a grid format. This widget includes filters, grouping by results, and navigation.
- Filters – different filter options used while saving a query.
- Group Results By – used to group the results; the grouped results will be displayed in the widget as a separate grid.
- Navigation – By clicking on the navigation icon, the user can navigate to the desired feature, execute the query, and view the results.
- The widget only displays the top 500 rows.
In the Operation section, this SQL Query result widget is available for Message Box Queries, Tracking Queries, and Secure SQL Queries.
Message Box Queries
Users can use BizTalk360 to run queries on the BizTalk Message Box database (BizTalkMsgBoxDb) to get a list of suspended service instances, running service instances, and subscription information.
In Message box queries, users can create, run, and save SQL queries. The saved queries can be pinned to a dashboard of your choice.
Let’s jump into an example,
The query “Graphical message flow – suspended service instances” was used to monitor the Graphical message flow application’s suspended service instances utilizing Group Results by as Host name filters, with the query results pinned to the Message Box Queries dashboard (Custom Dashboard). This widget displays the suspended service instances of the Graphical message flow application.
Fig 1.2 Pinning SQL query results from suspended service instances of the Graphical Message Flow application to the Message Box Queries dashboard (Custom dashboard)
Tracking Queries help in better understanding of the processes in BizTalk which can be accessed through the BizTalk Admin Console. These queries provide insight into which messages and orchestrations have been processed by BizTalk. From the Tracking Queries, it is also possible to have good insight into the message flow. The tracking queries can also be saved for later use. These queries are stored in the BizTalk360 database, so you always have them at hand.
Users can create, run, and save SQL queries in Tracking Queries. The saved queries can be pinned to the dashboard of your choice.
Let’s look at an example,
The “Service Instances – BizTalk Server Application Host” query was used to display the service instances in BizTalk Server Application Host and the query results were pinned to the Tracking Queries dashboard (Custom Dashboard). This widget makes it easier to see the service instances in the BizTalk Server Application host.
Fig 1.3 Pinning BizTalk Server Application Host Service Instances query results to the Tracking Queries dashboard (Custom dashboard)
Secure SQL Queries
Secure SQL Queries functionality is provided by BizTalk360 as a secure platform for storing predefined queries and allowing BizTalk members to execute them. BizTalk360 comes pre-loaded with a set of queries by default, and users (with appropriate permissions) can create secure SQL queries that are more relevant to the organization’s business.
Users can run the default queries as well as create, run, and save SQL queries in Secure SQL queries. The saved queries and the default queries can be pinned to the desired dashboard.
Let’s dive into an example with default queries,
Default queries will be available in Secure SQL Queries under the Default Queries tab in the Queries blade. The default query results widget “All Disabled Receive Locations” helps in viewing the BizTalk Server’s disabled receive locations on the Secure SQL Queries dashboard (Custom Dashboard).
Fig 1.4 Pinning the results of the “All Disabled Receive Location” (Default Query) query to the Secure SQL Queries dashboard (Custom dashboard)
Let’s look at an example with saved queries,
Saved queries will be available in Secure SQL Queries under the Saved Queries tab in the Queries blade.
The “BizTalk Server Pipelines” query results widget in the Secure SQL Queries dashboard (Custom Dashboard) provides a list of BizTalk Server pipelines.
Fig 1.5 Adding results from “BizTalk Server Pipelines” (Saved Query) to the Secure SQL Queries dashboard (Custom dashboard)
“Do you frequently query databases?”
If this is the case, instead of executing the query every time. You may store a query and pin it to the dashboard of your choice. As an outcome, the query result will be shown in a grid style, with results grouped by results and, if appropriate, filters. This stops the same query from being executed more than once.
How can widgets save time?
Widgets can save the user a significant amount of time that would otherwise be spent navigating to select a feature from a menu or repeatedly executing a stored SQL query. Instead, the user can pin the required SQL query results or feature/artifact to the desired dashboard.
BizTalk360 comes with a slew of features, and the pin to dashboard feature allows you to quickly access the one you want. We figured out how to pin a widget to the dashboard so that we could quickly navigate to the desired feature/artifact or view the query results. It includes all the cool features you need to effectively operate, monitor, and analyze your BizTalk environment. If you want to evaluate our product or take a tour of it. So, why not give it a shot? Sign up for our free trial to give it a try. A free demo will be provided by our dedicated product consultant team.