Azure Thoughts, EAI Challenges

I have posted a new sample on Code Gallery: BizTalk Server 2010 Adapter Pack: Call SQL Azure View .This is one of samples I have used in my talks on BizTalk Adapter Pack 2010 Integration (A Lap Around BizTalk Adapter Pack 2010) I held in Stockholm for Swedish BizTalk User Group and in Nieuwegein for BizTalk User Group The Netherlands. Hopefully you experiment with it yourself. If you want to work with SQL Azure and want to create a database, see How to Create a SQL Azure Database wiki on TechNet. Cheers.

In this post I like to show all table operations possible with WCF-SQL Adapter. The WCF based SQL Adapter can be used to connect BizTalk applications to SQL Server. WCF-SQL Adapter is part of BizTalk Server Adapter Pack 2.0, but can also be downloaded separately. To work with the adapter you will need to install the WCF LOB Adapter SDK SP2 before installing this adapter. Something that is overlooked easily, which also accounts for the fact that this adapter is offered as a supplement to BizTalk Server 2009. You must have a valid license for the BizTalk Server in order to use the SQL adapter and be eligible for support and to receive updates. Important to note here are the supported operating systems: Windows Server 2003 Service Pack 2 Windows Server 2008 Windows Vista Windows XP Service Pack 3 Windows XP SP3 Windows Server 2003 SP2 Windows Server 2003 R2 Windows Server 2008 Windows Vista and required is .NET 3.5 SP1. The Adapter Metadata wizard is supplied through WCF LOB Adapter...