Our blog
Offering
our
perspective
Filter by :
Azure
06/07/2021

How to use Azure Devops data within PowerBI

  When using Azure DevOps, we generate a lot of data. This can include scheduling data as well as data on the team or the various pipelines set up. It would be a shame not to use this …
access_google_storage_bucket_front
.Net
07/06/2021

How to reach a Google Storage Bucket from an Azure Function

In the context of developing a data flow, we need to connect to a Google Storage Bucket. Since there is no Logic App connector to do this easily, we will do it from an Azure Function. The idea is …
Azure
24/05/2021

Automate deployment for Azure Data Factory with Azure DevOps

Deploying and variabilizing an Azure Data Factory (ADF) on different environments by exporting its ARM template can quickly become tedious. Even more so when the number of flows to be exported …
encoder_decoder_edifact
Azure
11/03/2021

Encoding and decoding EDIFACT messages in a Logic App

EDIFACT messages can be processed in a Logic App, either decoding incoming messages or encoding outbound ones. To configure EDIFACT message encoding and decoding, a number of steps must be …
Azure
18/02/2021

Oracle data transfers via Azure Data Factory

Azure Data Factory (ADF) is the ETL (Extract Transform Load) component of the Microsoft Azure environment. It is used to create pipelines to extract, modify and move data in and out of numerous data …
Azure Active Directory user authentication on Azure Function
Azure
28/01/2021

AD user authentication with Azure function

When you create an Azure Function it is protected, by default, with the API key security. So when you need to call that function then you simply attach the provided API key to the request. API key …
.Net
07/01/2021

Azure EF Core and EF 6 SQL database connection resiliency

When using a serverless Azure SQL database via an Azure Function, the “Internal .Net Framework Data Provider error 6 in SQL Azure” error can sometimes occur. Yet if you re-run the query a …
rbac authorization using ARM
ARM Template
30/11/2020

Authorizing resources using RBAC with a separate ARM file

I have been using ARM (Azure Resource Management) templates to deploy Azure resources for a fairly long time. Generally speaking, these templates are straightforward to use, but some steps can be a …
BizTalk
16/11/2020

Handling zombie messages in BizTalk

  Zombie messages are messages that were routed to a running orchestration from the messageBox and were currently “in flight” when the orchestration instance ended. In other words, we have …
Front linked ARM
Azure
03/11/2020

Linked ARM templates with _artifactsLocation and _artifactsLocationSasToken

  As described in the Microsoft documentation, it is possible to use these parameters to reference linked ARM templates. There are two reasons to do this, in that there is no need to provision a …
Optimizing JSON processing in Logic App with map and reduce
Azure
06/10/2020

Optimizing JSON data processing in Logic App with map and reduce

Not while ago a colleague of mine asked me to take a look at his Logic App. It has a HTTP trigger with JSON data on the input. The Logic App processed the data (JSON array) with a For-Each action and …
Variabilise bindings DevOps
BizTalk
05/10/2020

Using variables in BizTalk bindings in Azure DevOps

In this article, we will see how to use variables in BizTalk bindings during automatic deployments using Azure DevOps. We will also see how to have different configurations depending on the …