AppFabric Connect for Services also offers the possibility of connecting BizTalk with the cloud. It is possible to get connected with SQL Azure and call a stored procedure or perform a table operation. SQL Azure delivers cloud database services which are built on SQL Server technologies and is a component of the Windows Azure platform. Instead of storing or retrieving data from the on-premise SQL Server database, you can do it in the cloud. Benefits of SQL Azure are scalability and high availability because of elasticity to the cloud. With AppFabric Connect for Services, you are able to develop a hybrid BizTalk solution connecting with the cloud and on-premise systems.
Before you can try with use this recipe, you must have an account on Windows Azure and the SQL Azure database. Go to the SQL Azure Portal (http://www.microsoft.com/windowsazure/sqlazure/) to get a SQL Azure database. You must also have Windows Azure AppFabric SDK version...