Tag: azure

Nov 11 2023

Azure, Business Intelligence, Technology

Azure Data Factory and DB2 Codepages

by mattias

No Comments

Having the option to connect to DB2 from Azure Data Factory is a great help in migrating from more legacy database platforms to the cloud. Or to ingest these systems...

adf, as400, azure, Azure Data Factory, DB2, etl

Nov 09 2023

Azure, Business Intelligence, Technology

Use Power BI APIs from Azure Data Factory

by mattias

2 Comments

Prerequisites  The preferred way to use the PowerBI API from Azure Data Factory (ADF) is by using a Service Principal. This has the benefit of not requiring a license assigned to...

adf, api, azure, Azure Data Factory, PowerBI, REST, Service Principal

Jun 23 2023

Azure, Uncategorized

SQL : Locking down disperse SQL databases – part 1

by mattias

No Comments

In this series, I’ll detail a process to automate giving and removing access to databases. Not just a single one, but different databases over different servers. Introduction The use case...

azure, azure sql db, elastic job, function, keyvault, powerautomate, security, sql

Jun 18 2023

Business Intelligence

PowerBI : Implementing BYOK

by mattias

No Comments

What is BYOK BYOK is the acronym for Bring Your Own Key. It gives you the ability to use your own encryption key on your data in rest, so you...

azure, byok, encryption, PowerBI, security

Aug 22 2022

Azure

Azure : Cheap static webserver

by mattias

No Comments

A small nifty feature in Azure storage accounts allows you to use them as a web server for static pages. Much cheaper alternative than setting up an Azure VM with...

azure, static, storage, storage account, web, website