Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

6. BizTalk AppFabric Connect > Performing table operations in SQL Azure

Performing table operations in SQL Azure

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.

Getting ready

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 1.0 (September update or later) and the BizTalk Server 2010 Feature Pack installed. Also, see the Installing the AppFabric Connect Feature and AppFabric Connect for Services recipe discussed earlier in this chapter. You will find SQL the Script for the SQL Azure Database and table and the BizTalk project (BTS.Cookbook.SQLAzure.TableOps), which you can use for reference, accompanied with this book.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint