Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Category: Azure Data Factory

How to Store Normalized SQL Server Data into Azure Cosmos DB

November 21, 2022November 21, 2022 Koen Verbeeck Leave a comment

Recently I got a hold of my Untappd data. For those who don’t know the app, it’s a rating app for beers. You can check-in a beer each time you drink one (by scanning the barcode for example), and then rate it, assign flavors et cetera. I did a GDPR request to get all my […]

Read More

Granular Cost Management for Azure Data Factory

October 19, 2022October 19, 2022 Koen Verbeeck Leave a comment

A new feature has been launched that allows you to have more granular control over the execution costs of your pipelines. By enabling the feature, you have a cost overview per pipeline in your cost analysis in the Azure portal and in your billing report. This is great news if you want to figure out […]

Read More

How you can save up to 80% on Azure Data Factory pricing

May 11, 2022May 11, 2022 Koen Verbeeck 1 Comment

… with this one weird little trick 🙂 Sorry for the clickbait, but you can actually save a lot on ADF pricing if you design your pipelines carefully. And as we will see, don’t do everything in ADF. Before we proceed further, I advise to watch this short YouTube video by Cathrine Wilhelmsen on ADF […]

Read More

Book Review – Azure Data Factory by Example

March 29, 2022March 29, 2022 Koen Verbeeck 2 Comments

I just finished the book Azure Data Factory by Example: Practical Implementation for Data Engineers by Richard Swinbank. The book was not exactly what I was expecting, but that’s actually my fault and not the book’s. The book itself is great and is a great introduction to Azure Data Factory (ADF) and it covers almost […]

Read More

Execute SQL Scripts on Snowflake using Azure Data Factory

March 13, 2022March 13, 2022 Koen Verbeeck 1 Comment

Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers): the Script activity! This is not to be confused with the script task/component of SSIS, which allows you to execute .NET script (C# for most people, or VB if you’re Ben Weissman). No, this task […]

Read More

Extracting Data from the AFAS REST API with Azure Data Factory

March 7, 2022March 7, 2022 Koen Verbeeck 8 Comments

AFAS is a Dutch business software company, proving companies with ERP and HR software-as-a-service. You can extract data from the service using a REST API (there are also SOAP web services available for those who appreciate the trip down memory lane). In this blog post I’ll show you how you can get data out of […]

Read More

Dynamically Map JSON to SQL in Azure Data Factory

February 28, 2022February 28, 2022 Koen Verbeeck 40 Comments

We’re reading in some JSON files in Azure Data Factory (ADF), for example for a REST API. We’re storing the data in a relational table (SQL Server, Azure SQL DB…). The data volume is low, so we’re going to use a Copy Data activity in a pipeline, rather than a mapping data flow (or whatever […]

Read More

Dynamic Datasets in Azure Data Factory

May 27, 2021May 27, 2021 Koen Verbeeck 4 Comments

With “dynamic datasets” I mean the following: a dataset that doesn’t have any schema or properties defined, but rather only parameters. Why would you do this? With a dynamic – or generic – dataset, you can use it inside a ForEach loop and then loop over metadata which will populate the values of the parameter. […]

Read More

Azure Data Factory and the Exact Online REST API – Getting around the 10 Minute Limit

May 25, 2021May 25, 2021 Koen Verbeeck 7 Comments

This is the final blog post of this series on how to extract data from the Exact Online REST API with Azure Data Factory. I’ve you followed along with the previous posts, you’ve seen how you can request new refresh/access tokens from the API, how you can extract data from an endpoint for multiple divisions […]

Read More

Azure Data Factory and the Exact Online REST API – Dealing with Pagination

May 25, 2021May 25, 2021 Koen Verbeeck 16 Comments

Some endpoints don’t have that much data, both others certainly will, for example financial transactions. The REST API limits the number of records it returns, and for most endpoints this is 60 records. After the first 60 records, you get a link at the bottom of the response that points to the next 60 records. […]

Read More

Posts pagination

Newer posts 1 2 3 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Free Webinar – Build a data warehouse on Azure Data Platform for $150
  • Techorama 2025 – Slides
  • Redgate SQL Prompt in SSMS 21
  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest

Categories

  • Azure (26)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (57)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (113)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress