Creating Linked Services In Azure Data Factory

In this blog you will understand “How to create a Linked services for Azure SQL Database and Azure Blob Storage to Azure Data Factory?”

The linked service has the connection information that the Data Factory service uses at runtime to connect to it.

Suppose you want to copy Azure SQL Database table data into Azure Blob Storage, so in that scenario you have to create two separate Linked Service-

Azure SQL Database to Azure Data Factory
Azure Blob Storage to Azure Data Factory

Prerequisites

If you don’t already have a subscription, create a free Azure Account.
Resource group – Create Resource Group.
Azure SQL Database, Create Azure SQL Database.
Create Azure Data Factory, see here
Allow Azure services and resources to access this server-

Open your Azure SQL Database > Click on Set server firewall >Choose Yes “Allow Azure services and resources to access this server”.

Firewall enable resource access server

Linked Service – Azure SQL Database to Azure Data Factory

Following these steps in order to create a Linked Services-

Step-1: In Azure Data Factory window > Click on Manage Tab > Click on + New button.

New Linked Service ADF

Step-2: New linked services window appears > Search Azure SQL Database > Select Azure SQL Database > Continue.

Choose Azure SQL Data Base

Step-3: One window appears with some options-

Name: Assign Linked Service name
Azure subscription: Choose your subscription.
Server name: Choose your SQL server name.
Database name: Choose SQL database name.
Authentication type: Select SQL authentication and enter server user name and password.

After all configuration click on Test connection then click on create button.

Linked service for SQL to ADF

Step-4: Linked service has been create successfully between Azure SQL Database to Azure Data factory.

SQL Linked service

Linked Service – Azure Blob Storage to Azure Data Factory

Prerequisites for this-

If you don’t already have a subscription, create a free Azure Account.
Azure Storage Account, see Create a storage Account in Azure

Follow these steps to setup linked service for Azure Blob Storage to Data factory.

Step-1: Click on Mange Tab > Select Linked service > Click on + New button

Linked service

Step-2: New linked service windows open in right side screen, search Azure blob storage and click on continue.

Step-3: Now assign the proper linked service name, choose azure subscription & storage account name and click on create.

Create linked service

Step-4: Linked service created successfully.

Recommend Azure Post: Microsoft Azure Topics

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.