Skip to content

Latest commit

 

History

History
39 lines (29 loc) · 3.23 KB

manually-configure-a-physical-port-binding-to-the-sql-adapter.md

File metadata and controls

39 lines (29 loc) · 3.23 KB
Raw
description title ms.custom ms.date ms.service ms.reviewer ms.suite ms.topic
Learn more about: Manually configure a physical port binding to the SQL adapter
Manually configure a physical port binding to the SQL adapter
06/08/2017
biztalk-server
article

Manually configure a physical port binding to the SQL adapter

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

  • The direction of communication between [!INCLUDEbtsBizTalkServerNoVersion] and the [!INCLUDEadaptersqlshort]. 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.

    [!NOTE] Two-way receive ports are not supported by the [!INCLUDEadaptersqlshort].

    For more information, see How to Create a Send Port, or How to Create a Receive Port.

  • 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.

    [!NOTE] You can also configure the send or receive ports by importing a binding configuration file that is created by the [!INCLUDEconsumeadapterservshort] as part of metadata generation. For instructions on configuring ports using this binding file, see Configure a physical port binding using a port binding file to use the SQL adapter.

In This Section

See Also

Building blocks to develop BizTalk applications with the SQL adapter