StoredProcs

  Linked Service  provides Azure data factory with basic connection information required to connect external source. There are multiple ways to create a Linked Service in Azure - Via Manage in Azure Data Factory UI, Power Shell, Azure Portal. Data Store Linked Service can be used to configure connection setup for data stores such as relational databases, Azure blob, on-prem FTP servers, HDFS, and many more. Compute environments supported in ADF can be configured using Compute Linked Service.  Azure Databricks, Azure Batch, HD Insights, Azure ML, and Azure Data lake Analytics are the platforms supported as of today. Parameterizing Linked Service The ability to parameterize a linked service makes it an extremely powerful utility. In a DW/BI, It is a fairly common scenario to have multiple source data systems using a sing RDBMS system, Oracle for instance. Using Parameters, we can configure a single linked service to connect to multiple homogeneous data systems. Para...

     Azure Data Factory aka ADF is Azure's Data offering that caters development and orchestration of Data pipelines.  ADF empowers cloud developers to orchestrate their Databrick notebooks and various other codebases. This cloud-managed service is specially designed for complex hybrid ELT, ETL, and Data Integration solutions. ETL Tool - Azure Data Factory ADF is one among many data offerings by Azure and is designed to orchestrate data pipelines. Capabilities like Data flows make it a powerful ETL tool with an ever-growing list of data source integrations. How Azure Data Factory is licensed? Azure Data Factory is Azure's Platform as service (PaaS) solution. Azure Data Factory Components . It has a number of components wrapped in 'Author' and 'Management' options in the left pane. Author components( GA till date) include Pipelines, Dataflows, Datasets, Power Queries. Management Components are Integration Runtimes, Linked Services, Triggers, Global Paramet...