Linked Service in Azure Data Factory

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. Parameter values can be set at datasets using this parameterized Linked Service. There is also a provision to set a default value for a parameter. Below snippets show the parameter section available while creating a new linked service.

Comments

ACLs in Azure Data Lake

Access Control Lists(ACLs) in azure are an extremely powerful toolset to provision granular levels of access in Azure Data Lake. Role-Based Access Control (RBAC) is best option to setup broader access levels however with ACLs you can reach the lowest possible grains as low as a file inside a blob container. Think of a scenario where you want to add more than 1 user to a folder inside a blob container and each one of them sees only their data - Possible with ACLs Prerequisites Azure Subscription Storage blob with hierarchical namespace enabled Reader Access on the storage object via RBAC How to setup ACLs in Azure Data Lake Like any other offering, Microsoft has a broad spectrum of tools/ways to setup ACLs, ranging from Azure Portal to writing python code . All the steps involved are available in Microsoft documentation, and in a very descriptive manner, therefore needless to rephrase again in this article. Instead, lets walk through some of the challenges one can c...

n8n Tutorial: Automate Your Workflows in 4 Simple Steps

Getting Started with n8n: A Practical Guide to Workflow Automation n8n (pronounced "n-eight-n") is a powerful, open-source workflow automation tool that enables you to connect different apps and services without writing code. Think of it as a visual programming environment where you design automated sequences, known as workflows, by linking together pre-built nodes. Unlike some other automation platforms, n8n is fair-code, meaning its source code is available for you to inspect, modify, and self-host, giving you unparalleled control over your data and processes. This guide will walk you through the core concepts and initial steps to harness n8n's potential, turning complex, manual tasks into efficient, automated workflows. What is n8n? Understanding the Core Concepts At its heart, n8n is an integration platform designed to move and transform data between various applications. The fundamental building block of any n8n project is the node . Each node represents a spe...

Build smart data pipelines with AI

AI in Data Engineering Smarter Pipelines, Faster Insights Artificial Intelligence (AI) is reshaping the way businesses collect, process, and analyze data. In the world of data engineering , AI is not just an enhancement but a game-changer. By embedding intelligence into data pipelines, organizations can automate repetitive tasks, predict failures, improve data quality, and unlock actionable insights faster than ever before. Whether it's scaling data workflows in the cloud, detecting anomalies in real time, or optimizing query performance, AI-driven engineering provides efficiency, accuracy, and agility that traditional methods struggle to match. But how exactly is AI influencing this evolving discipline, and what does it mean for data engineers? Let’s dive into the distinct areas where AI is making its mark. Automating Data Pipelines Data pipelines are the backbone of analytics and machine learning projects, yet building and maintaining them can be labor-intensive. AI in...

StoredProcs

Search This Blog