Step 2: Creating Ports for the Contoso 3A2 Price and Availability Query/Response Scenario
In this step, you create send ports using the SQL adapter provided by BizTalk Server. You use the SQL port for sending and receiving the 3A2 Price and Availability response to and from the ERP system for Contoso.
To configure a send port using the SQL adapter
In Visual Studio, on the View menu, click BizTalk Explorer.
In BizTalk Explorer, right-click Send Ports, and then click Add Send Port.
In the Create New Send Port dialog box, select Static Solicit-Response Port from the drop-down list, and then click OK.
In the Static Solicit-Response Send Port Properties dialog box, in the Name box, type 3A2SQLReqResponseSendPort.
In the Properties window under the General heading, select SQL as the Transport Type.
In the Address URI box, click the ellipsis button (…).
In the SQL Transport Properties dialog box, click the ellipsis button (…) next to the Connection String box.
In the Data Link Properties dialog box, in the Select or enter a server name box, type localhost.
Select Use Windows NT Integrated security.
In the Select the database on the server box, select Contoso, and then click OK.
In the SQL Transport Properties dialog box, in the Document Target Namespace box, type
http://Contoso.com/Price.In the Response Document Root Element Name box, type rootPriceResponse, and then click OK.
In the left pane of the Static Solicit-Response Send Port Properties dialog box, click Send.
In the Static Solicit-Response Send Port Properties-Configurations-Send-General dialog box, in the Send Pipeline box, select Microsoft.BizTalk.DefaultPipelines.XMLTransmit.
In the Receive Pipeline box, select Microsoft.BizTalk.DefaultPipelines.XMLReceive, and then click OK.
In BizTalk Explorer, right-click 3A2SQLReqResponseSendPort, and then click Enlist. Right-click it again, and click Start.