March 2019

Persistence and Recoverability on the Microsoft Platform

By |2019-03-04T00:27:39+00:00March 4th, 2019|Azure Functions, BizTalk, Integration Playbook, Logic App, Service Bus|

Recently I added an article to the integration playbook which compares the different approaches used for Durability, Persistence and Retry across the various microsoft technologies such as BizTalk, Logic Apps, Event Grid, Event Hubs, Service Bus Messaging and Functions You can read more here - https://www.integration-playbook.io/docs/durable-messaging-on-the-microsoft-platform

February 2019

Integration Playbook

By |2019-02-27T13:09:15+00:00February 26th, 2019|Azure, BizTalk, Integration Playbook, Logic App|

I have just launched the Integration Playbook which I have had in mind for a few years but only recently got around to doing. The idea is a community resource aimed at Architects, CTO and Leads. The resource will provide information, guidance and insights around common architecture and integration topics and relate them to the Microsoft technology stack. Where do I use which technologyHow does Microsoft relate to this IT or architecture topicHow can integration architecture help me [...]

December 2018

Inserting lots of rows into SQL with a Logic App and a Stored Procedure

By |2018-12-09T12:31:08+00:00December 9th, 2018|Logic App, Serverless, Uncategorized|

When you are working with API's and Logic Apps and there is lots of rows of data involved you will sometimes come up with the following problems: An API often pages the data once you go beyond a certain number of records When you want to insert lots of rows with a Logic App into SQL you will usually have a loop which iterates over a dataset and does inserts This takes a long time to execute There [...]

October 2018

Managing Azure Serverless solutions in the Real-world and the gap filled by Serverless360

By |2019-04-04T11:18:56+00:00October 24th, 2018|Azure Functions, Logic App, Serverless|

Recently I wrote an article which is on technet wiki about understanding the roles and areas covered when monitoring and managing serverless solutions on Azure.  I then discussed the gaps which Serverless 360 can fill based on our recent real world experience. The article is on this link https://social.technet.microsoft.com/wiki/contents/articles/52071.managing-azure-serverless-solutions-in-the-real-world-and-the-gap-filled-by-serverless360.aspx

March 2018

Building Better Web Apps with Logic Apps and Signal R

By |2018-03-04T23:44:25+00:00March 4th, 2018|Azure, Logic App, SignalR|

In this article I would like to discuss a pattern I've implemented recently where we could improve the user experience in a web app through the use of Logic Apps and Signal-R. Lets imagine we have a scenario at Acme University. They have built a super Student Portal building using ASP.net and Azure. The home page for this app will require some authentication probably against Azure AD and once logged in the student will be presented with a [...]

February 2018

When data in CRM is updated I want to send it to another application

By |2019-04-04T11:16:50+00:00February 11th, 2018|Azure, CRM, Functions, Logic App, Service Bus|

Having worked a lot with Dynamics CRM/365 over the last few years I thought it would be interesting to discuss a common use case and some of the architecture patterns you may consider to implement the solution. Lets imagine a scenario where the business requirement is as follows: The user will be updating a customers record in Dynamics 365 When the user saves the change we need the change to be synchronised with the billing system Now at [...]

October 2017

Can the user modify the Integration solution – Discuss

By |2017-10-01T20:25:39+00:00October 1st, 2017|BizTalk, Logic App, Uncategorized|

Recently I had a chat with a few people at a company about integration solutions and a question came up which I remember not having been asked in a while. "Will the business users be able to modify the solution after its live". Back in the day you used to get asked this quite often but I don't remember being asked this one for a while. I do know that the technology landscape has changed a lot since [...]

TechUG – Newcastle Sept 2017 – Logic Apps

By |2017-10-01T18:57:50+00:00October 1st, 2017|Logic App|

I was invited to talk at TechUG in Newcastle last week.  TechUG is a pretty impressive user group, it is based in the UK and is a partnership of 8 IT Pro based user groups based in 8 cities in the UK.  They run 2 events per year in each city and are very popular with a twitter following well north of 10k. Ive spoken at TechUG a number of times before and its nice to get the [...]

July 2017

Documenting a Logic Apps solution

By |2017-07-31T16:13:49+00:00July 31st, 2017|Logic App, Uncategorized|

One of the biggest challenges in integration projects over the years is how to manage the relationship between the implementation of your solution and the documentation describing the intention of the solution and how it works and how to look after it. We have been through paradigm shifts where projects were writing extensive documentation before a single line of code was written through to the more agile approaches with leaner documentation done in a just in time fashion. [...]

Custom CRM Portals Super-Charged by an Azure Data Layer

By |2017-07-22T10:40:54+00:00July 22nd, 2017|API, Azure, BizTalk, CRM, Logic App, Service Bus, Uncategorized|

I wanted to talk a little about the architecture I designed recently for a Dynamics CRM + Portal + Integration project. In the initial stages of the project a number of options were considered for a Portal (or group of portals) which would support staff, students and other users which would integrate with Dynamics CRM and other applications in the application estate. One of the challenges I could see coming up in the architecture was the level of [...]