SQL Command Schemas
SQL command schemas allow you to retrieve and update Apache Impala 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.
INSERT Command Schemas
You can execute INSERT statements by generating INSERT Command Schemas for send ports.