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-
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.