Using EAI Bridges and LOB Target to connect to on-premises SQL Server

Using EAI Bridges and LOB Target to connect to on-premises SQL Server

Like I mention in one of my last posts, I decided to publish all my demos that I have been using in my sessions in BizTalk Innovation Event series. This will be the first demo. This demo is a basic integration scenario: “Event registration” and intends to show some of the Enterprise Application Integration (EAI) […]
Blog Post by: Sandro Pereira

FAIL VODAFONE (sorry Nokia)

Originally posted on:

I can’t say I follow things that closely in the Windows Phone world, but I am aware of the upgrade to Windows phone 7.8. I’ve been looking forward to this for a while. The improvements in the UI look nice, and when I get it, I can try to kid myself that my company phone, a Nokia Lumia 800, is really an 820.

It appears that the roll-out of 7.8 started today in the US for Nokia 900 users. It can take a while for upgrades to make it to all theeligiblephones. So, imagine my delight when, this evening, my phone informed me an update was waiting for me! Yeah! I eagerly started the upgrade process and excitedly informed my bemused family that I was about to get Windows Phone 7.8.

Er…no. After asuccessfulupgrade, the phone re-booted…into Windows Phone 7.5.

I did a little digging. It appears that the last upgrade, code-named Tango, has just arrived on my phone. Tango was released on 20th July last year. That’s just over six months before I got the upgrade.

Oh dear me.

I’ll report back on Windows Phone 7.8 in late summer…if I’m fortunate enough to get it by then 🙁

Apologies to Nokia who I stupidly railed at in an earlier version of this post. Of course, they simply manufacture the handsets. In my case, the carrier is Vodafone and they are the company responsible for pushing updates to my phone. It seems that back in SeptemberVodafone decidedto cancelthe globalroll-out of Tango updates to some users due to a WiFi concern. Although the press only reported this as affecting a single HTC model, maybe this is connected with my experience.

Update 2 (Friday)
A colleague has been busy forcing upgrades on his Nokia Lumia 800 (there is a little trick you can use, apparently, that involves switching off your PC WiFi connection at just the right moment while using Zune, and then re-connecting). He forced an upgrade to Tango. Now, he reports thathe got two further updates and then a third. The thirdappears to beWindows Phone 7.8 (which at the time of writing he is currently installing). So, best guess is that Tango is being rolled out as a precursor to the 7.8 update. I’ll report back on this later.


BizTalk Community Series: Introducing Torben Chrona Christiansen

The year 2013 promises to be a great year for us BizTalk professionals. BizTalk Server 2013 will be released in a few months, the beta is currently available on-premise and in Windows Azure. A few events have taken place already this month like the BizTalk Summits in London, Amsterdam and Stockholm. There will be more events coming this year. A lot of community involvement in 2013.

Today’s story

Service Bus Notification Hubs-Part 3 My Solution Overview

Service Bus Notification Hubs-Part 3 My Solution Overview

In my previous post I introduced the concept of Customer Power Outages and, at a high level, introduced  how Outage Management Systems work.  The key take away from that blog post is that important, event driven data is passing through BizTalk and there is an opportunity use this information to provide better Customer and Employee engagement through Service Bus Notification Hubs.  Think about, conceptually how different is it from BAM Alerts?  The idea behind BAM Alerts is data is moving through BizTalk, Tracking Profiles pick it up and send it to subscribers who are interested in it via email (oversimplifiedI know).  The process of collecting this information for Notification Hubs is different but now we can reach an audience that we may never had access to before.

In this post we will take a closer look into how we could actually implement a Power Outage system and include notifications to both customers and employees by using Service Bus Notification Hubs. 

Note: In some areas I have over-simplified the process in order to focus on some of the key technical aspects of Notification Hubs.

In the diagram below I have laid out the series of events that make up the architecture:

  1. Customer determines their power is out and launches the Windows 8 application on their SurfaceRT tablet in order to report their Power Outage.  The mobile client registers itself for Toast Notifications.  In this case the Customer is only interested in events pertaining to its SiteID (Customer ID) so a Tag of 0090123456789 is included as part of the Toast Notification registration. Next, the customer clicks the submit button to notify the power company of their outage. The message is sent to a Customer Outage Service Bus Queue.
  2. BizTalk is using the new SB-Messaging Adapter to connect to this Service Bus Queue and pulls down the Customer message.
  3. BizTalk will perform a transformation and send the message to the Work Order Create Queue.  Once again, the new SB-Messaging Adapter will be used when communicating with the Service Bus.
  4. Once the Work Order message has been sent to the Service Bus Work Order Create Queue, BizTalk will send a message using the Service Bus .Net Preview SDK to the Service Bus Notification Hub.  Included in this message is the tag “Airdrie” which happens to be the City were the customer, who submitted the trouble ticket, lives.  It also happens to be the area that the Power Line Technician (PLT)  is responsible for.  Only he will receive this toast notification because he is the only employee that is registered for this tag. 
  5. The PLT will now receive a Toast Notification indicating that he has a new Work Order that he needs to complete.
  6. When the PLT clicks on the Toast Notification, the PLT App is launched and he can click the Retrieve Next Order button to download the order. 
  7. Once the PLT has had a chance to assess the situation he can provide an Estimated Time of Restore (ETR) and send this information to a Work Order Update Queue that exists in the Service Bus.
  8. BizTalk will pickup this message from the Work Order Update Queue.
  9. The updated Work Order information will now be sent to the Outage Management System using the FILE Adapter.
  10. BizTalk will use the information contained in the Work Order Update message to push a Notification message up to the Service Bus Notification Hub.  As part of this message, a tag for the customer’s Site ID is populated.  In this case it is 0090123456789 which happens to be the same Site ID as the customer who initially logged the Power Outage ticket.
  11. The customer will now receive a Toast Notification indicating their Estimated Time of Restore (ETR).
  12. Steps 7 – 11 will be repeated once the PLT has restored power and a notification can be sent to the customer, when the work order has been closed in the Outage Management System, indicating that their power has been restored and give them a duration of the outage.


Hopefully this post has described in more detail how Service Bus Notifications can improve customer and employee engagement.  I promise that the next post in the series will have some code.  I just felt that if I could build a story, it would provide some worthwhile context that truly demonstrates why this Notification Hub technology is important.

Renewal of Microsoft Gold Partnership

Renewal of Microsoft Gold Partnership

Once again, Cnext is proud to announce the renewal of the gold partnership with Microsoft, demonstrating a “best-in-class” ability and commitment to meet Microsoft Corp. customers’ evolving needs in today’s dynamic business environment and distinguishing itself within the top 1 percent of Microsoft’s partner ecosystem. Cnext reached this gold partnership in the category Application Integration. […]
Blog Post by: Cnext

Announcing new free webinars for Microsoft ALM Certification

Microsoft Learning used the ALM Summit 3 this week to announce the new “Microsoft Certified Solution Developer (MCSD): Application Lifecycle Management” certification. The new certification required you to pass the following three exams.

  1. 70-486: Administering Microsoft Visual Studio Team Foundation Server 2012
  2. 70-497: Software Testing with Visual Studio 2012
  3. 70-498: Delivering Continuous Value with Visual Studio 2012 Application Lifecycle Management

QuickLearn’s two TFS instructors have both already obtained this certification and have prepared comprehensive exam preparation sessions to help candidates focus their study and pass these exams.

The exam preparation sessions are available as FREE, ONLINE WEBINARS that anyone can register to attend. Over the coming month we’ll also release online video preparation sessions.

Attending these webinars will help you in the following ways.

  • Understand the goals and objectives covered in each exam.
  • Get links to study material on the Microsoft MSDN website.
  • Go through some samples questions.
  • See product demonstrations for topics listed in the exam preparation guide.
  • Learn techniques to help you when you’re doing the actual exams.

To sign up for any of the free webinars, simply click the following link, choose the webinar you wish to attend and register.


NOTE: We do not tell you the questions or the answers. We provide sample questions that we have written ourselves. We respect the NDA we signed prior to taking these exams. We do not encourage the use of brain dumps. Brain dumps devalue the certification and reduce value for everyone.

QuickLearn Training at the ALM Summit 3 event

This week QuickLearn was involved at the third annual Application Lifecycle Management Summit held on the Microsoft Corporate headquarters in Redmond.

Nick and I were both involved in delivering content and sharing our TFS knowledge and skills with attendees. Here are the two activities we presented.

Pre-conference workshop

I delivered a sold-out pre-conference workshop entitled “Managing your application lifecycle with TFS”. The workshop provided attendees with a rapid overview of many of the features of Microsoft’s ALM suite. Based on the number of questions from attendees, there was a lot of interest in the new features in TFS 2012.

Exam Cram Session

Microsoft took the opportunity to announce the brand new MCSD: Application Lifecycle Management certification at the conference. Nick and I paired up to deliver a 90 minute exam prep session to help attendees learn the best way to prepare for the three exams required for the new certification. Fortunately, both Nick and I both already have the certification so this made things a little easier.

Feedback from both activities was overwhelmingly positive and with our commitments done, we’re both just enjoying attending sessions at the conference for the rest of the week.

Bulk starting/stopping/overriding EDI batches in BizTalk Server 2010

Bulk starting/stopping/overriding EDI batches in BizTalk Server 2010

TorbenChrona Christiansen wrote a very handy blog post last year on how to bulk stop and start EDI batches in BizTalk Server 2009 using SQL queries. These queries can be used to aid in creating proof of concepts, to demonstrate batching in presentations, as a setup step in integration tests, or during deployments. Seeing as […]
Blog Post by: Johann