BizTalk Server 2013 Beta Announced

BizTalk Server 2013 Beta announcement really exciting times ahead. Beta is available for download here. Will be posting more on this in a few days. A major release will build on the recently released BizTalk Server 2010 R2 CTP.

Featured in BizTalk Community Series by Steef-Jan

Was recently introduced in a BizTalk Community Series article by Steef-Jan. A heartfelt thanks to Steef-Jan, for the opportunity. 

Cumulative Update 4 for BizTalk Server 2010

The Cumulative update 4 for BizTalk Server 2010 has been released. More can be found here.  

ASP.NET MVC/Web API/Web Pages Open Source

Microsoft's Open Source strategy by making ASP.Net MVC available under an open source license sounds amazing. Find more here. 

Biztalk Server 2010 EDI 999 Functional acknowledgement support

BizTalk Server 2010 Cumulative Update 3 made available recently has included the awaited 999 Functional Acknowledgement support. More can be found in this KB article. 

Installing Microsoft WebMatrix 2 Beta

Attended a Microsoft Web Camp recently focused on WebMatrix, Html5 and Css3. My first bits of experience with the tool. Will be installing Web Matrix 2.0 beta.

• Start with the download here.
• With the Web Platform Installer 4.0,  the installation is not much trouble. 

Fig.1 Web Platform Installer 4.0

• Click Install and the list of all dependencies are available right away. Note: I had .Net Framework 4.0 pre-installed on my machine.

Fig.2 Web Platform Installation

• Click Accept and the download and installation starts.

Fig.3 Quick Start MS WebMatrix

Polling using BizTalk WCF Oracle Adapter

Came across this scenario of polling an Oracle table from BizTalk Server 2010 using the WCF Oracle Adapter and a requirement of running a post poll statement which updates the table in one of my forum posts. Used the WCF Consume Adapter Service to do a small POC for this and following are a few steps that I followed.

• Used the Consume Adapter Service Wizard to connect to the oracle DB using the oracleEBSBinding and create a Service inbound operation for a schema artifact Test table. This will create a set of Schemas and a binding file with a receive port

Fig.1 Consume Adapter Service

• Next I created the receive port using the auto-generated binding file and then a send port to a file location with a filter to subscribe the messages which will published by the receive port. As shown in Fig.2, I have set the required polledDataAvailableStatement, pollingAction,pollingInput(FOR UPDATE), pollingInterval and postPollStatement(UPDATE) properties on the receive port. The pollingAction can be taken from the metadata of the auto-generated schema. Following is an example(have changed the schema name)

         <xs:documentation>
          <doc:action xmlns:doc="http://schemas.microsoft.com/servicemodel/

            adapters/metadata

           /documentation">Tables/Poll/SCHEMA_NAME/TEST</doc:action> 
         </xs:documentation>

Fig.2 WCF Custom Transport Properties for Receive Port

• To test this I deployed the auto-generated schemas and started the send port and enabled the receive port. The results in the outbound folder as shown in Fig.3

Fig.3 Outbound Folder.

• Note that the result of the polling input in this case is after applying the postPollStatement.