Access Dynamics 365 through Azure API Management

A project I recently worked on required a Third-Party vendor to access Microsoft Dynamics 365 data. This external organisation wanted to query customer data and surface this data on another…

EIP – Competing Consumer Enterprise Integration Pattern for faster data processing

In this post I’ll demonstrate how to design an integration architecture that uses the tried and tested integration design pattern competing consumer. As always, I’ll demonstrate both “low-code” and code…

Fatal: could not read Password for terminal prompts disabled

I was recently trying to write back remote changes carried out by a build agent as part of a CI-CD task. I came across the following error:

Find Duplicates using Azure Data Factory (two source files)

There are some scenarios where you need to combine different datasets with some similarities to find duplicates. In this post I demonstrate how to use Azure Data Factory and Dataflows…

Use Azure Data Factory to find duplicate records (two source files)

I've read many sources online that illustrate how to create a flow that detects record duplicates. Some of these duplicate detection patterns can be quite complex, most are old patterns.…

Configuring Dynamics 365 CE Data Export Service

The steps below outline the actions needed to build the Dynamics 365 Data Export Service. What I found was that documentation on this subject is sparse, but also, blog posts…

Stop Azure Data Factory Data Flows outputting to multiple files

I came across a recent issue where I was trying to overwrite a single in my Data Flow. However, Data Factory started to output several intermediary files instead.

Filtering in Azure Data Factory

Microsoft have now made it easier to filter records from a delimited source. We all know it's possible to filter SQL data sources, but now filtering in Azure Data Factory…

Create a Dynamics 365 CE Trial Instance with your Azure Student Subscription

I signed-up to an Azure Student Account for an Azure Developers course that I was studying during the evenings. One thing that I noticed immediately was that I could not…

Get started with Azure Analysis Services

I was looking for some documentation online that would help me run Azure Analysis Services on an Azure SQL DB using Visual Studio 2019. Documentation is sparse so I thought…