- 08 Nov 2024
- 7 Minutes to read
- Print
- DarkLight
- PDF
Business Activity Monitoring
- Updated on 08 Nov 2024
- 7 Minutes to read
- Print
- DarkLight
- PDF
Business Activity Monitoring (BAM) can be used by functional administrators and managers as it can provide a complete overview of the business processes across the environment. BAM is a collection of tools that monitor business milestones and key metrics throughout a process in the BizTalk Server environment. The business users can set up specific data points during the business process that will give them an insight into what is happening during the process. The key aspect of BAM is that it can help you to view the business information in almost as real-time as possible. This is referred to as 'Zero latency'.
Advantages of BAM:
- Gain insight into the status of different business processes.
- Up-to-date information available through portal/alerts.
- Streamline business operations - escalate issues at the earliest.
BizTalk360 comes with an integrated BAM portal that allows business users to query BAM views, perform Activity Searches, view the user permissions that are configured in BAM, and the Activities Time Window. If BAM is implemented in your BizTalk environment, BizTalk360 automatically picks up the configuration and displays the BAM data in the portal. The reason BizTalk360 incorporates the BAM portal is to give seamless access to all information for the support people and minimize their efforts to jump between multiple tools to get different data related to the same application/environment.
BAM Views
A BAM activity represents a specific business process in the business, say, for example, handling a purchase order. As a business user, you can create BAM activities to define the information that you want to monitor in the business process with BAM. Business users can use the BAM Excel add-in to define the data that BAM needs to collect. BAM View is a representation of the data that is tracked in the BAM activity.
BizTalk360 lists all the BAM views configured in the environment under the BAM Views tab. When the BAM View is clicked, the drop-down in the Build Query Expression section will display the list of BAM Activities. A BAM View can have one or more BAM Activities. When the BAM activity is selected from the drop-down, the available columns in the BAM activity are automatically populated under the 'Available Columns' section. You have the option to move the items from the available columns section to the Selected Columns list. Once the items are moved from the available columns section to the selected columns section, you can optionally move them to the Order By section to tell the query builder how to sort the results and display them in the Query Results section.
- Select Query - Select the BAM Activity from the drop-down. All the activities associated with the BAM view will be listed.
- Max Matches - Select the number of records to be fetched. Ex. 10, 25, 50, 100, ...
- Add a Filter - To filter the results based on different parameters. Once the filter criteria are selected, you will automatically see the values for the filter listed in the drop-down.
- Run Query - Once all the values are selected, click Run Query to view the query results.
- Column Options - All the available columns will be listed in "Available Column ", from the list you can select the columns that you wish to list in the grid, by using the right/left arrow you can move the columns to the selected list. Order by option allows you to list the results based on selected column order (ascending by default).
- Run - Once all the values are selected, click Run to view the query results.
Performing an activity search
The integrated BAM portal comes with a powerful query builder that allows the support people to query the BAM data seamlessly. Follow the steps as shown below to build a query and perform the activity search:
- Log in to the BizTalk360 application.
- Select an environment from the environmental panel.
- Click the Administration tab in the navigation panel.
- Click the expand button against the BizTalk Services tab and select the Business Activity Monitoring link.
- On the BAM Portal page, click on the BAM View Name.
- In the Activity Search tab, select the BAM Activity name from the drop-down under the Build Query Expression section.
- Depending on the BAM Activity name selected, the Available Columns section will be populated with the column information.
You can select and move multiple items from the Available Column by pressing the Ctrl key and clicking the column names.
8. Once the columns are set, select the Max Matches value from the drop-down to filter the number of results in the Build Query Expression section
9. Click 'Add Filter' and select the required options if you wish to add complex filter criteria while building the query expression
10. Once the query is built, click 'Run Query' to run the query and generate the results. The Query Results section will display the results based on the values selected in the Selected Column, Order By, and the filter criteria applied in the Build Query Expression section
Viewing BAM Database information in BizTalk360
The BAM databases screen displays the list of BAM databases for the environment and some properties of the database such as data file size, log file size, and so on. The BAM database information will be useful to the BizTalk Administrator to get an insight into the database information. From a monitoring perspective, it is important to keep an eye on the size of database data and log files. BizTalk360 eases this process by displaying them on the home screen under the BAM Databases tab.
- Log in to the BizTalk360 application
- Select an environment from the environmental panel
- Click the Administration tab in the navigation panel
- Click the expand button next to the BizTalk Services tab and select the Business Activity Monitoring.
- On the BAM Portal page, click on the BAM Databases tab
- The BAM databases section displays the following information:
- Database Name
- Server Name
- Instance Name
- Auto Growth (Data)
- Auto Growth (Log)
- Data File Size (MB)
- Log File Size (MB)
BAM Time Zone
BAM view activities are displayed according to the user profile time zone settings.Within each BAM view, there exists an option to configure the time zone at column level .
Imagine a scenario where you're examining the BAMRelation view, which contains a datetime column called OrderIn_Time. This column stores values in the BAM database in the (UTC+1) timezone (for example, 7:00 AM). When you execute a query, the API converts this value to UTC time (i.e., 6:00 AM). In the BizTalk360 UI, the displayed value aligns with the user's profile time zone setting.
Steps
- Select the respective BAM view
- Click on "Activities Time Window" , which lists all the column in grid which has datetime type.
- Click on the Configure TimeZone option to configure specific time zone for each column .
- However if all the columns belongs to same timezone means , you can provide the value globally as below.
Viewing BAM related activities and documents in BizTalk360
BAM-related activities represent the atomic information of the Business milestones and Business Data. These activities can be accessed in BizTalk360 from the Activities Search screen under the BAM Views. Business milestones are the specific data that represent the state of the business processes and the data that represents data types are the Business Data. Being able to get to the activities and documents within the BizTalk360 application reduces the considerable time for BizTalk administrators.
BAM holds the concepts of Continuations and Relationships which are used to enhance the relational activity model. A Relationships model is used when the activity file contains more than one activity, i.e., in a real-time scenario, there may be multiple responses received for one order.
To view the BAM related activities and documents in BizTalk360:
- Log in to the BizTalk360 application.
- Select an environment from the environmental panel.
- Click the Administration tab in the navigation panel.
- Click the expand button against the BizTalk services tab and select the Business Activity Monitoring link.
- On the BAM Portal page, click on the BAM View Name.
- In the Activity Search tab, select the BAM Activity name from the drop-down under the Build Query Expression section.
- Depending on the BAM Activity name selected, the Available Columns section will be populated with the column information.
- Once the columns are set, select the Max Matches value from the drop-down to filter the number of results in the Build Query Expression section.
- If you wish to add complex filter criteria while building the query expression, click Add Filter and select the required options.
- Once the query is built, run the query and generate the results. The Query Results section will display the results based on the values selected in the Selected Column, Order By, and the filter criteria applied in the Build Query Expression section.
- Click on the query result row to view the detailed information of the transaction, related activities, and related documents.
- In the Related Activities tab, click the eye icon to view the Related Activities details.
- You can download the Related Document from the Related Documents tab.
Permissions to see BAM Views in BizTalk360:
For a user/group to see a BAM view in BizTalk360 UI, it is required to add the user/group name to the corresponding BAM view.
Use the following command to assign a user/group to the BAM views in the path(<BizTalk server installed folder>/tracking)
bm.exe add-account -AccountName:Domain/Username -View:BAMViewName