Episode
Introducing Azure Data Factory Copy Activity
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
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
Have feedback? Submit an issue here.