SQL Command Schemas
SQL command schemas allow you to retrieve Azure Analysis Services data in BizTalk through an SQL interface. For example, you can execute a parameterized query when a message is received, with the message containing the input parameter values.
Executing SQL Statements
The following sections show example requests, responses, and schemas for the appropriate ports.
SELECT Command Schemas
You can execute SELECT commands by generating SELECT Command Schemas for both receive locations and solicit-response send ports.