If you are looking for how to create linked service in azure data factory using sql db you are at the right place.
Go to your azure data factory account (Assume you already have one in case not please refer : https://azurelib.com/azure-data-factory/ )
Click on the Manage Tab to create the linked service to connect to azure sql database.
Click on ‘ + New ‘ or Create Linked Service for creating the linked service.
Based on the data source select the type. In our case as we wanted to connect to the azure sql database. Hence search the sql database and select
Now provide the suitable name and description based on your choice Description is not mandatory and you can keep it empty as well. However it is good practice to provide the description.
Provide the integration runtime (if you don’t have any dedicated integration runtime , choose AutoResolveIntegrationRuntime
Select the subscription, once you select the right subscription the server name list would be automatically populated with the available servers.
Select the server of your choice from the drop down. (If you don’t have create the azure sql db , please create using How to create Azure SQL Database)
Three are three ways to connect, one is managed identity, service principal and third one is simple sql authentication. In production environment SQL authentication is used for connecting to external data source outside the group.
If you don’t have Azure active directory enabled in your account, then you can choose simple sql authentication, in this you will enter your database username and password. Click test connection to check all is good.
Once you see connection successful just click on create and you are done. By this you have successfully created your linked service to connect to azure sql database in adf. If you have any issue in how to create linked service in azure data factory please do let me in comment section below. I will try to solve your problem in most effective manner.
You may like to how to create dataset now : What is dataset in azure data factory
Deepak Goyal is certified Azure Cloud Solution Architect. He is having around decade and half experience in designing, developing and managing enterprise cloud solutions. He is also Big data certified professional and passionate cloud advocate.
