Export (0) Print
Expand All

Specifying SOAP Action

To perform any operation on SQL Server using the WCF-based SQL adapter, you must specify a SOAP action. The SOAP action communicates to the adapter what action should be performed. You can specify the SOAP action either from Visual Studio or from the BizTalk Server Administration console. However, if you specify the SOAP action from both locations, the action you specified from Visual Studio will be overridden.

For more information about specifying SOAP action, see http://go.microsoft.com/fwlink/?LinkId=102063.

From Visual Studio, you must specify the SOAP action as part of the orchestration by using an Expression shape.

To specify SOAP action from Visual Studio

  1. In the BizTalk orchestration, include an Expression shape by dragging it from the BizTalk Orchestration toolbox.

  2. Double-click the Expression shape to open BizTalk Expression Editor.

  3. Specify the action in BizTalk Expression Editor. For example:

    OutboundMessage(WCF.Action)="TableOp/Insert/dbo/Employee"
    

    For more information about the Expression shape and BizTalk Expression Editor, see http://go.microsoft.com/fwlink/?LinkId=102064.

From the BizTalk Server Administration console, you can specify the SOAP action as part of the WCF-Custom or WCF-SQL port configuration.

To specify a SOAP action for the WCF-Custom port

  1. Start the BizTalk Server Administration console.

  2. In the console tree, expand BizTalk Group, then expand Applications, and then click Send Ports. In the right pane, you can choose to create a port or select an existing port.

  3. In the port properties dialog box, from the Type drop-down list, select WCF-Custom, and then click Configure.

  4. In the WCF-Custom Transport Properties dialog box, click the General tab.

  5. In the Action text box, specify the SOAP action for the operation. You can specify the action in the following ways:

    • By using the single action format. Use this format if the WCF-Custom port sends and receive messages for a single operation. For example:

      TableOp/Insert/dbo/Employee
      
    • By using the action mapping format. Use this format if a single WCF-Custom port sends and receives messages for more than one operation. For example, if a single WCF-Custom port sends and receives messages for Op1 (to insert records in the Employee table) and Op2 (to update records in the Employee table), the SOAP action can be specified in the following manner:

      <BtsActionMapping>
        <Operation Name="Op1" Action="TableOp/Insert/dbo/Employee" />
        <Operation Name="Op2" Action="TableOp/Update/dbo/Employee" />
      </BtsActionMapping>
      
      The action mapping approach provides greater flexibility in terms of specifying a set of actions, and hence enabling messages that belong to different action types to flow through the same port.

      The format for the SOAP action is different for each operation. For more information about the action format for each operation, see individual topics under Technical Reference.

To specify a SOAP action for the WCF-SQL port

  1. Start the BizTalk Server Administration console.

  2. Add the WCF-SQL adapter to the BizTalk Server Administration console. For instructions, see Adding the SQL Adapter to BizTalk Server Administration Console.

  3. In the console tree, expand BizTalk Group, then expand Applications, and then click Send Ports. In the right pane, you can choose to create a port or select an existing port.

  4. In the port properties dialog box, from the Type drop-down list, select the WCF-SQL adapter you added earlier, and then click Configure.

  5. In the transport properties dialog box, click the General tab.

  6. In the Action text box, specify the SOAP action for the operation. You can specify the action in the following ways:

    • By using the single action format. Use this format if the WCF-SQL port sends and receive messages for a single operation. For example:

      TableOp/Insert/dbo/Employee
      
    • By using the action mapping format. Use this format if a single WCF-SQL port sends and receives messages for more than one operation. For example, if a single WCF-SQL port sends and receives messages for Op1 (to insert records in the Employee table) and Op2 (to update records in the Employee table), the SOAP action can be specified in the following manner:

      <BtsActionMapping>
        <Operation Name="Op1" Action="TableOp/Insert/dbo/Employee" />
        <Operation Name="Op2" Action="TableOp/Update/dbo/Employee" />
      </BtsActionMapping>
      
      The action mapping approach provides greater flexibility in terms of specifying a set of actions, and hence enabling messages that belong to different action types to flow through the same port.

      The format for the SOAP action is different for each operation. For more information about the action format for each operation, see individual topics under Technical Reference.

© 2014 Microsoft Corporation. All rights reserved.
Show:
© 2015 Microsoft