This article continues the discussion of a meta data driven pipeline that move data from SQL Server into a Fabric Warehouse. Last time, we were using the Adventure Works schema which was deployed to an Azure SQL Database. Today, we are going to learn how to install and configure the on-premises data gateway for a hybrid design.
Business Problem
The current design uses a full load pattern to move data from the SQL Server database to a Fabric Warehouse. We are going to modify the design slightly to manage data from SQL Server 2022 which is installed on a virtual machine in Azure that does not have a