SQL command schemas allow you to retrieve OneDrive 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.