Linked Service - Datasets

Linked services:

Is essentially a connection Manager as in SSIS.
Defines connection information so that Data Factory can connect to the data source.
Can be reused among pipelines.
The linked service has the connection information that the Data Factory service uses at runtime to connect to it.


DataSets :
Name view of data that points or references the data.
Get more specific to item/object/file/table level.

Comments

Post a Comment

Popular posts from this blog

How to access output of any activity in another connected activity. - Lookup Activity

Accessing Pipeline Variable Array elements in another activity by. @ variable ('NameOfPipelineVariable')[0]   -- 1st element @ variable('NameOfPipelineVariable')[1]   -- 2nd element @concat( variable ('NameOfPipelineVariable')[0], variable ('NameOfPipelineVariable')[1]) @{activity('Copy1').output.dataWritten} Accesses a property of the previous copy activity and passes the value of dataWritten. or  @activity('LookupTableList').output.value --- this will return full dataset i.e. all records returned by SQL in an activity. ------- @{activity('CopyBlobtoBlob').error.message -  For the failure case, pass the error output instead of  ----------------------------------------------------------------------- First Activity outputs a column named NewWatermarkvalue. select MAX(LastModifytime) as NewWatermarkvalue from data_source_table Below is how you access the output of the above activity in another activity in...
Read more