Data Factory is a cloud-based Extract-Transform-Load service which enables data from multiple sources, both cloud and on-premises based, to be extracted, transformed as per technical and business rules, and loaded into a variety of destinations including the Data Lake, SQL Database, Synapse Analytics and many more.

Architecture diagram for automated enterprise BI with Azure Synapse and Azure Data Factory