The following are the advantages of custom SQL queries functionality in BizTalk360:
- Single management tool for users to execute the queries. No need for SQL Server Management Studio
- Central Query Repository - maintaining queries is much easier
- The end users need not have direct access to the SQL database. The queries will be executed in the context of service account, therefore only the service account requires access.
- Queries can be executed against any SQL instance/database.