Data Factory Updates Simplify and Secure Enterprise ETL

• Data Factory’s focus on data connector improvements can simplify usage, while improving security.
• Native mode (low code) adds more non-Azure services as destinations and features to build complex pipelines.
• SQL Server Integration Services mode updates make using it with Azure SQL offerings more appealing.

Azure Data Factory, a Microsoft cloud service providing various forms for extract, transform, and load (ETL), continues to focus on enhancing the service’s Native mode to address enterprise requirements, although the traditional SQL Server Integration Services mode introduces options that may entice on-premises customers to Azure.

Service Overview

Azure Data Factory provides enterprise-scale ETL services that help automate data integration, transformation, and movement workloads. It can access data from multiple data stores, including on-premises, Azure-hosted, and third-party cloud database services. Organizations can use Data Factory to create pipelines that combine data from multiple sources. For example, a Data Factory pipeline might pull (extract) data from multiple regional sales databases, summarize (transform) the data, and save (load) the results into a corporate data warehouse that is used to calculate daily sales performance metrics.