Before we create pipelines to fetch data from the REST API, we need to create a helper pipeline that will fetch a new access token. This pipeline has the following format: Get the last known refresh token from the database (or whatever storage you use). You need to have manually retrieved the first pair of […]
Tag: adf
Azure Data Factory and the Exact Online REST API – Fetching your first refresh/access tokens
UPDATE 1: the layout seems to have been updated, but at the time of writing (Feb 2026), you can still revert back to the old layout which is consistent with the screenshots UPDATE 2: going to the app centre from your exact online app might not work when you’re using inprivate browsing To get data […]
Azure Data Factory and the Exact Online REST API – Introduction
I’m going to do a small blog post series on how to extract data from a REST API using Azure Data Factory. I’m going to use the Exact Online REST API, because it has a series of challenges: a complicated process to get your first access token endpoints with more data will use pagination a […]
Migrating SSIS to Azure – an Overview
For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an Integration Runtime, a cluster of virtual machines that will execute your SSIS packages. In the beginning, you only had the option to use the project deployment model and host your SSIS […]
New Management Hub in Azure Data Factory
I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then to connections. But instead of showing me my linked services (which is the default tab), it showed me this message instead: My curiosity was awakened. By clicking on “Open management hub”, you are taken to […]
Switching between different Azure Data Factory environments
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately, the functionality to switch between them is a bit hidden in the user interface. One might assume you could find it in the breadcrumbs in the […]