While we are trying to extract some data from Azure SQL server database, if something has to be processed, then it will be processed and is stored in the Data Lake Store.
Steps for Creating ETL
Create a Linked Service for source data store which is SQL Server Database
Assume that we have a cars dataset
Create a Linked Service for destination data store which is Azure Data Lake Store
Create a dataset for Data Saving
Create the pipeline and add copy activity
Schedule the pipeline by adding a trigger