The ADF Case

How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]

Azure Data Factory Pipelines: Filling in the gaps

Azure Data Factory is a cloud based data orchestration tool that many ETL developers began using instead of SSIS. In this article, Rodney Landrum recalls a Data Factory project where he had to depend on another service, Azure Logic Apps, to fill in for some lacking functionality.

Orchestrating Azure Databricks Notebooks with Azure Data Factory

Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.

Incremental Data loading through ADF using Change Tracking

Learn how you can use Change Tracking to incrementally load data with Azure Data Factory

Downloading a CSV File from an API Using Azure Data Factory

In this article, learn how to use Azure Data Factory with a REST API to download files.

Getting Started with Delta Lake Using Azure Data Factory

This article will demonstrate how to get started with Delta Lake using Azure Data Factory's new Delta Lake connector through examples of how to create, insert, update, and delete in a Delta Lake.

Create Azure Data Factory inventory using Databricks

Learn how to build a catalog of your different Azure Data Factory objects such as pipelines, activities, datasets and more.

Azure Data Factory : Your First Data Pipeline

Introduction Azure Data Factory is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. We can create and schedule data pipelines which can move data between various supported data stores. We can also use for data transformation before loading it into […]

Azure Data Factory vs SSIS vs Azure Databricks

In this article we cover some things you should consider when determining whether to use Azure Data Factory, SSIS or Azure Databricks.