Azure Thoughts, EAI Challenges

In past I written posts on interaction between BizTalk and Windows Azure SQL Database (former known under SQL Azure) using the WCF-SQL Adapter. I have revisited one of my posts that dealt with calling a stored procedure. To bring back old memories I tried to do same against using BizTalk Server 2013 (this time through using an orchestration and messaging) The WCF-SQL Adapter (binding) from the BizTalk adapter pack has the following capabilities: Execute create-read-update-delete statements on tables and views;  execute stored procedures and generic T-SQL statements  Database polling via FOR XML  Database polling via traditional tabular results  Proactive database push via SQL Query Notification  Expansive adapter configuration which impacts connection management and transaction behavior  Support for composite transactions which allow aggregation of operations across tables or procedures into a single atomic transaction  Rich metadata brows...

Almost two years ago I wrote a post on the location of the BizTalk Adapters for BizTalk 2010. For BizTalk 2010 there are basically two folders both containing a setup application. One folder contains the setup for installation of BizTalk, RFID and Adapter Pack. The other folder contains a setup for BizTalk accelerators. This is a little bit different for BizTalk Server 2013 Beta. In case you download BizTalk2013Beta.exe from the Download Center   you will have a folder named for instance BizTalk2013beta (depending how you named the folder when unpacking the media). When you run the setup in that folder you can install BizTalk, UDDI Services, RFID, BizTalk Adapters and ESB Toolkit. For BizTalk Server 2013 Beta itself there is documentation available for installation (divers Operating Systems), and the product itself . In case you download BizTalk2013AcceleratorsBeta.exe from the Download Center   you will have a folder for instance called BizTalk2013AcceleratorsBe...