Posts

Showing posts from September, 2013

BizTalk and Windows Azure SQL Database

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 browsing and retrieval for finding and

BizTalk Server 2013: New Adapters Series: SFTP

In march I promised to do a post on the last new adapter released with BizTalk Server 2013: SFTP . I wanted to discuss all the new adapters and did so for the relays, SB-Messaging and WebHttp. I forgot about SFTP. I got reminded of that fact when I read latest TechNet Wiki article  by Suleiman Shakhtour . Excerpt of the article: In the BizTalk 2010 release, Microsoft enhanced the existing FTP adapter to support SSL (FTPS) which encrypting the data transfers between systems. With the BızTalk 2013 release, Microsoft added the SFTP (SSH File Transfer Protocol also called Secure File Transfer Protocol), which has been anticipated for many years. In the past for one had to rely on the open source adapter developed by Blogical found on CodePlex or an adapter from commercial third parties (like /n software SFTP ). You can further read the article on the TechNet Wiki: BizTalk Server:How to use SFTP Adapter in BizTalk Server 2013 . You will read how to configure and test the adapter yo

A few notes from the Hybrid Organisation Event - London

Last week I attended the Hybrid Organisation Event in London. A story on the event can be found on BizTalk360 blog. I enjoyed it and was good to see some friends and my old colleagues Sander Nefs and Rene Brauwers , After event Sander wrote to two interesting posts on Windows Azure Services Bus after seeing Sam VanHoutte session: UK Connected Systems User Group – BizTalk Services questions BizTalk Services Questions and answers In my previous post I pointed out to where slides of Sam his session on WABS can be found. In case you like to learn more about Richard’s talks on integration you see view his courses on Pluralsight (look for Patterns of Cloud Integration ). Clemens had an interesting session during that day that lasted two hours: next wave of integration (device to cloud). You can see more on this topic through Channel 9 Clemens Vasters Subscribe (look for Device to Cloud Series ). It was well organized and successful event. Organized by Microsoft UK and

BizTalk PaaS: Windows Azure BizTalk Services – Part V

Windows Azure BizTalk Services is a relative new technology offered by Microsoft through Windows Azure. The service was launched beginning of June during the TechNet North America. It is still in preview mode. I have written a few posts on this technology through this blog. During the recent event in London called the Hybrid Organisation , Sam VanHoutte from Codit presented A lap around the Windows Azure BizTalk Services. You can find the slides through slide share. He did the same presentation at the recent BizTalk User Group in the Netherlands. Today I wrote a post on the TechNet Wiki Blog : Since this is a fairly new technology you will not find many practical articles on how to implement solutions with it or how to's. Other than the MSDN documentation and a few blog posts there is of course the TechNet Wiki. Here you can find on the BizTalk Server Resources on the TechNet Wiki page under Windows Azure BizTalk Services section a few articles. You can read the

BizTalk Professionals can find there tools through the TechNet Wiki

In past I have written quite a few articles for the TechNet Wiki and I sometimes blog on TechNet Wiki Blog . One of my recent posts was on tools: There are many tools 3rd party available or from Microsoft that can help a professional in building robust applications. This accounts for many technologies and server products like BizTalk Server, .NET, and SharePoint. The TechNet Wiki plays an essential role describing these tools, how to use them and where you find them. As professionals you will be more productive when it comes to testing your solution, verifying the installation of the server product or troubleshooting an issue when using tools of the trade. Not only tools can be helpful, but also reading articles about testing or building your solution, and many other cases. The TechNet Wiki also harbors many of these kinds of articles. You can read further here . Cheers, Steef-Jan

Monitor BizTalk Server Job

I recently created an article on TechNet Wiki on the Monitor BizTalk Server Job. The Monitor BizTalk Server job scans for issues, but does not fix them for you! It consist of two steps. First step is the execution of the [btsmon_Inconsistancies] stored-procedure. This procedure will on its turn call other procedures in the MessageBox, Management and Tracking database to collect error data (like messages without references). The second step is calling the procedure [btsmon_GenerateErrorString] in Management database, which involves a query of two tables [btsmon_Inconsistancies] and [btsmon_Issues]. You can read more here …. You can also read a post by Randal on this job: This job is especially good news for those of us responsible for keeping BizTalk Server running and healthy. The general idea behind the job is to check for errors and report that those errors exist in one of the message box databases, the management or the tracking database. A zombie message is an exampl

BizTalk Community Series: Introducing Richard Hallgren

Image
Holidays are over and I enjoyed my stay in Spanish Pyrenees and France ( Béziers ). In case you ever visit the Spanish Pyrenees you might see sights like this when hiking through the mountains. Now back to reality. Sun has stop shining (it will return Thursday though) here in the Netherlands and it is back work. Today’s story in this post will be on Richard Hallgren , who works as a Solution Architect at iBiz Solutions , a specialized consultancy company with about 20 employees (and growing). It mainly focuses on integration and data centric solutions based on Microsoft and Tibco technology. iBiz has a number of larger customers spread all over Scandinavia continent. “In my role as a Solution Architect I'm usually responsible for the overall architecture, making sure we follow best practices such as having automated builds, automated tests, a clear strategy, clear requirements, documentation platforms, working source code workflows etc, etc. Basically making sure we have