Ability to send a Report depending on the result of a Secure SQL Query
In the last version of BizTalk360, we have the ability to display Secure SQL Queries in Report which is good.
But now what is missing is the ability to send a report depending on the result of a Secure SQL Query. The use case is that on our side we have existing SQL Server Reports we want to replace with BizTalk360. These reports are sent by email to users only if for example a query returns results, or at the opposite if one query is not returning any results.
Analytics reporting has been improved. Use SQL Query reporting to get the results in csv format, and you will not receive an email if the query returns no records.