Skip to main content

General availability: Copy data to/from Azure Data Explorer using Azure Data Factory or Synapse Analytics

Published date: November 17, 2021

The Microsoft Data Integration team has just released a new connector for Mapping Data Flows, in both Azure Data Factory (ADF) & Azure Synapse Analytics (ASA). You can now natively connect to your Azure Data Explorer (ADX) clusters in mapping data flows.

Mapping Data Flows provides scale-out data transformation in the cloud in ADF and ASA. With these additional connectors, you can build ETL (Extract, Transform, Load) patterns at Spark scale in a code-free design environment without ever touching the Spark compute. Azure Integration Runtimes allow you to define the Spark environment and provide a serverless Spark compute for your data transformation pipelines.

Read Mapping Data Flow gets new native connectors to see an example of how to use the ADX connector as a source in a data flow to read New York city taxi data and to perform any of the hundreds of data transformation patterns to reshape and transform the data. 

Read more on how to Copy data to or from Azure Data Explorer using Azure Data Factory or Synapse Analytics.

  • Azure Synapse Analytics
  • Azure Data Factory
  • Azure Data Explorer
  • Azure Integration Runtime
  • Features