View the earlier version.Version 7.10

BizTalk360 comes with a pre-loaded set of queries and also allows users to define secure SQL queries. The users can choose one of these pre-loaded queries from the drop down list. When the item is selected from the drop down, the query automatically executes and the result is displayed in the Query Results pane.

Executing The Pre-Stored Queries

To execute the pre-stored queries, follow the steps as shown below in exact order. Let us consider an example of executing, a query to retrieve the list of 'All Disabled Receive Locations'. The query will look into the BizTalkMgmtDb and retrieve the information of disabled receive locations.

  1. Log in to the BizTalk360 application
  2. Click the 'Operations' tab in the Navigation panel
  3. Click the expand button against 'Data Access' tab and select 'Secure SQL Queries' link
  4. In the Secure SQL Queries screen, under Build Query Expression:
  • Select the pre-stored query "Sendport to Specific Location [BT360DOC01\BT360DOC01:BizTalkMgmtDb]" from the drop down
  • The query will execute and the results will be displayed in the Query Results pane

Once the query is executed, the tab name will be renamed to the name of the query (Sendport to Specific Location).

BizTalk360 allows the users to open up to 4 tabs at a time to execute multiple queries. To open a new tab, click the + button. To close the tabs individually, click the * button next to the tab name. To close all the tabs in one click, click the X button next to the + button.

Click the sliders to view the process of executing the pre-loaded queries.

secure sql queries in biztalk360 select sql query in biztalk360 sql queries in biztalk360