Step 1: Set Up Your Computer
Updated: November 21, 2013
This topic provides you with the information and pointers to set up your computer on which you will perform the steps to set up the hybrid integration scenario described in Tutorial: Using BizTalk Service Bridges to Lookup Data from Azure SQL Database. You must do the following to set up your computer:
Install Windows Azure BizTalk Services SDK. You can download the installer from http://go.microsoft.com/fwlink/?LinkId=235057. You use this SDK to configure and deploy the XML One-Way Bridge that picks flat-file messages from FTP Server, processes it, routes it to a relay endpoint, which then inserts the records into a SQL Server database.
Install BizTalk Adapter Service. You use this to expose the Insert operation on a SQL Server database table as a relay endpoint on Service Bus. You can download the installer from http://go.microsoft.com/fwlink/?LinkId=235057. Refer to the BizTalk Services installation guide at http://go.microsoft.com/fwlink/?LinkId=237092 to install the software prerequisites for BizTalk Services SDK and BizTalk Adapter Service.
Note Typically, if you were connecting to any other line-of-business (LOB) application by using BizTalk Adapter Service, you would also install client libraries for that specific LOB application. However, in this case, because the connection is to a SQL Server instance, explicitly installing client libraries is not required because they are already installed as part of .NET Framework.
Install the WCF LOB Adapter SDK. This is required for installing the Adapter Pack on the computer.
Install the Adapter Pack. This contains the SQL adapter that is required to establish connectivity to a SQL Server database and for exposing operations on SQL Server database tables.