Edit

Adding the SQL Adapter to BizTalk Server Administration Console

  • Article

The SQL adapter can be used in BizTalk either as a WCF-Custom port or a WCF-SQL port. If you want to use the SQL adapter through a WCF-Custom port, you do not need to add the WCF-Custom port to the BizTalk Server Administration console because the WCF-Custom port is added to the BizTalk Server Administration console by default. However, if you want to use the SQL adapter through a WCF-SQL port, you must first add the WCF-SQL adapter to the BizTalk Server Administration console.

This topic shows you how to add the WCF-SQL adapter to the BizTalk Server Administration console.

Important

You do not need to follow these steps if you want to configure a WCF-Custom port for the SQL adapter.

Add the SQL Adapter

  1. Open the BizTalk Server Administration console.

  2. Expand the BizTalk Group, expand Platform Settings, and then select Adapters.

  3. Right-click Adapters, point to New, and select Adapter.

    Add an adapter

  4. In the Adapter Properties dialog box, enter a name for the adapter, and from the Adapter list, select WCF-SQL.

    Add WCF-SQL adapter to BizTalk

  5. Select OK.

See Also

Building blocks to develop BizTalk applications with the SQL adapter