Copy_Source_Data_Activity_Solution1.pptx

Data Activity

1. Lesson 2 Copy Data Tool in Azure Data Factory Lesson 1 Copy Activity in Azure Data Factory

2. Copy Data Tool Benefits Quick and easy way of creating a data copy flow Wizard Based You do not need understand Data Factory definitions for linked services, datasets, pipelines, activities, and triggers. The tool automatically creates all the necessary Data Factory resources to copy data from source destination/sink. The Copy Data tool helps you validate the data that is being ingested at the time of authoring

3. Copy Data Tool Benefits Resources created by Copy Data Tool can be edited to add Complex business logic post Copy Data Tool run. Copy Data Tool can be used to learn new functionality such as pulling in numerous tables at the same time

4. Copy Data tool vs. Data Factory UI Copy Data Tool You want to easily build a data loading task without learning about Azure Data Factory entities (linked services, datasets, pipelines, etc.) You want to quickly load a large number of data artifacts into a data lake. Copy activity Authoring You want to implement complex and flexible logic for loading data into lake. You want to chain copy activity with subsequent activities for cleansing or processing data.

5. Big Data In Mind The tool is designed with big data in mind. It can move hundreds of folders, files, or tables. The tool supports automatic data preview, schema capture, automatic mapping, and data filtering.

6. Automatic Data Preview You can preview part of the data from the selected source data store, which allows you to validate the data that is being copied. If the source data is in a text file, the Copy Data tool parses the text file to automatically detect the row and column delimiters and schema.

7. Intuitive flow Configure settings for the  source . Configure settings for the  destination . Configure  advanced settings  for the copy operation such as column mapping, performance settings, and fault tolerance settings. Specify a  schedule  for the data loading task. Review  summary  of Data Factory entities to be created. Edit the pipeline to update settings for the copy activity as needed.