Database Queries

Updated on 26 Dec 2019
1 Minute to read

Print
Share
Dark
Light
PDF

Article Summary

Share feedback

Thanks for sharing your feedback!

Setting up monitoring for Database queries

Log in to the BizTalk360 application
Click 'Monitoring' in the navigation panel
Click the expand button against 'Manage Mapping' tab and select 'BizTalk Environment' link

BizTalk360-Monitoring-SQL-Queries-BizTalk-Environment.png

Select the Alarm name (see Creating an alarm) from the drop down for which you would like to associate the alerts

At the tab pages at the top, select Database Query
Click New Query button to set up monitoring for the database query
Enter the Name for the Alert, add the SQL Instance name, select the Authentication Mode (Windows Authentication \ SQL Authentication ) and the SQL Database name

Authentication mode

Windows Authentication - BizTalk360 connects to the SQL instance against windows system users.
SQL Authentication - BizTalk360 Connects to the SQL instance using the username and password provided by the user. Users can also connect to the Azure database using SQL authentication.

Click Next to add the Query and Threshold details
Enter the SQL query in the space provided
Select the Warning and Error Conditions when BizTalk360 must return an alert

BizTalk360-Monitoring-SQL-Queries-Configure-Thresholds.png

Click OK to Save the monitoring information

Note:

You can monitor the Database Query results by configuring the query which returns the scalar value.If there is any deviation in the query results then BizTalk360 will trigger an alert notification.

Was this article helpful?

What's Next

Overview

Table of contents

Setting up monitoring for Database queries