Introducing Azure Data Factory Copy Activity

Sign in to queue

Description

The Azure Data Factory service is a fully managed service for composing data storage, processing, and movement services into streamlined, scalable, and reliable data production pipelines. You can use the Copy Activity in a pipeline to copy data from a source to a sink (destination) in a batch. The Copy Activity can be used in the following scenarios:

  • Ingress to Azure. In this scenario, data is copied from an on-premises data source (ex: SQL Server) to a Azure data store (ex: Azure blob, Azure table, or Azure SQL Database)
  • Egress from Azure. In this scenario, data is copied from Azure (ex: Azure blob, Azure table, or Azure SQL Database) to on-premises data marts and data warehouse (ex: SQL Server)
  • Azure-to-Azure copy. In this scenario, the data distributed across Azure data sources is aggregated into a centralized Azure data store. Examples: Azure table to Azure blob, Azure blob to Azure table, Azure Table to Azure SQL, Azure blob to Azure SQL.

[00:00] - Introducing Azure Data Factory Copy Activity
[00:43] - Sample 1-- Copy data from Azure Sql to Azure Blob .
[01:49] - Sample 2-- Copy data from On Premises Sql Server to Azure Blob . 

To learn more you can follow the useful links and participate in the Forum

Tag:

Azure

Embed

Download

The Discussion

Add Your 2 Cents