Home » Uncategorized

Logic App – Upsert to SharePoint List

Recently I wrote an article about how I was uploading bank info from Barclays to my Office 365 environment and into a SharePoint list. http://microsoftintegration.guru/2017/06/29/logic-apps-integration-for-small-business/ In the article I got the scenario working but I mentioned that I didn’t really like the implementation too much and I felt sure there…

Read More »

BizTalk + Azure Functions – Upload to AWS S3

Recently I had a requirement to extend one of our BizTalk solutions, this solution was around user synchronisation. We have 2 interfaces for user synchronisation, one supporting applications which require a batch interface and one which supports messaging. In this case the requirement was to send a daily batch file…

Read More »

Empowering your Integration Platform with Service Bus

In todays organisations there is a massive theme that API’s and iPaaS are the keys to building modern applications because these technologies simplify the integration experience. While this is true I think one of the things that is regularly forgotten is the power of a well thought out messaging element…

Read More »

Tactical Integration with Logic Apps

As an integration architect you usually work with customers trying to build a platform which deals with all of the different types of integration they want to do and you try to find the right balance of technologies to build an effective and efficient platform which will have a good…

Read More »

BizTalk and Azure Functions

Recently I had the opportunity to look at the options for combining BizTalk and Azure Functions for some real world scenarios. The most likely scenarios today are: Call a function using the HTTP trigger Add a message to a service bus queue and allow the function to execute via the…

Read More »

Mulesoft IPO and what it means for Microsoft System Integrators

A friend shared a couple of links with me recently about the Mulesoft IPO which is happening soon and it got me thinking about how this might affect us in the Microsoft integration world. First off those links: http://tomtunguz.com/mulesoft-s-1/ https://www.sec.gov/Archives/edgar/data/1374684/000119312517047884/d287291ds1.htm http://www.cnbc.com/2017/03/06/mulesoft-ipo-test-public-markets-appetite-for-unicorns.html It is really interesting to see a major move…

Read More »

Dealing with Bad Data in Integration Solutions

When we build integration solutions one of the biggest challenges we face is “sh!t in sh!t out”. Explained more eloquently we often have line of business systems which have some poor data in it and then we have to massage this and work around it in the integration solution so…

Read More »

Azure Resource Groups and Cloud Integration Platform

One of my favourite things in Azure is the ability to group stuff into resource groups. Maybe it’s a reflection on myself but I hate looking at messy environments that look like a kid has just emptied their toy box over the floor. With resource groups you have the ability…

Read More »

Serverless vs Codeless in the Microsoft Integration Platform

While chatting to Jeff Holland on integration Monday this evening I mentioned some thinking I had been doing around how to articulate the various products within the Microsoft Integration Platform in terms of their codeless vs Serverless nature. Below is a rough diagram with me brain dumping a rough idea…

Read More »

Create a hybrid API when you have brittle underlying LOB applications

Recently I have been thinking about a sample use case where you may want to expose legacy applications via a hybrid API but you have the challenge that the underlying LOB applications are not really fit for purpose to be the underlying sub-systems for a hybrid API. In this case…

Read More »