Manually Configuring a Physical Port Binding to the SQL Adapter

Manually Configuring a Physical Port Binding to the SQL Adapter

This section provides information about configuring the Microsoft BizTalk Adapter for SQL Server as a WCF custom binding or as a WCF-SQL port by using the BizTalk Server Administration console. After deploying the adapter, you will be able to send and receive messages from SQL Server by using the BizTalk Server Administration console. The steps for deploying the adapter vary depending on:

  • The direction of communication between BizTalk Server and the SQL adapter. You may choose to configure a send, receive, or a send-receive port. Your choices are summarized in the following table.

    Port direction Communication pattern Direction of communication to choose from

    Send

    One-way

    I will always be sending messages on this port.

    Receive

    One-way

    I will always be receiving messages on this port.

    Send-receive

    Request-response

    I will be sending a request and receiving a response.



    Dd788465.note(en-US,BTS.10).gifNote
    Two-way receive ports are not supported by the SQL adapter.

    For more information, see the BizTalk Server Help documentation at http://go.microsoft.com/fwlink/?LinkID=101130.

  • Whether the adapter sends messages to the SQL Server (outbound operations) or receives messages from SQL Server (inbound operations). Depending on whether you want to send or receive messages, you will create a send or receive port, respectively.

    Dd788465.note(en-US,BTS.10).gifNote
    You can also configure the send or receive ports by importing a binding configuration file that is created by the Consume Adapter Service Add-in as part of metadata generation. For instructions on configuring ports using this binding file, see Configuring a Physical Port Binding Using a Port Binding File.

Show:
© 2016 Microsoft