How to use Private Endpoint for Azure SQL Database from Azure Data Factory - ADF Tutorial 2021

 Issue: How to use Private Endpoint for Azure SQL Database from Azure Data Factory - ADF Tutorial 2021.

In this article, we are going to learn, how to create a private endpoint from Azure Data Factory for Azure SQL database, A private endpoint is a network interface that uses a private IP address from your virtual network. This network interface connects you privately and securely to a service powered by Azure Private Link. By enabling a private endpoint, you're bringing the service into your virtual network. 

Let's start our demonstration, open your Azure portal, and then go to the Azure Data Factory Studio, in the ADF go to the connections and click on Linked services, and then click on + New,  it will open and window at the right side of the dashboard, select Azure SQL database then click on continue, on the next page, first of all, provide the linked service name, then click on connect via Integration Runtime, as we have to create a new integration runtime,   click on +new, then select azure and click on continue, then select Virtual network configuration preview, enable that and click on create, then select the server name, then select database name, and then click on Manage Private Endpoint, and click on Create New, and then give a specific name to the endpoint and select Account Selection Method, select From Azure subscription, then select your server name and then click on create. Once you click on that the private endpoint status will be shown as Provisioning, to approve this request, go to the Azure portal then go you your SQLBD and then click on Private endpoint connections, in the connection you will see a request for accessing the database, so you have to select that request and click on approve, once you approve the request go back to your linked service page and you will see the private endpoint connection status will be approved, now select the authentication type, username, and password, test the connection and click on create, as shown in the picture below. 

Fig-1: Create a new Linked service for Private Endpoint Connection.

Once our linked service is created, let's go to the Azure portal and then go to the Azure SQL server, and then select the Firewalls and virtual networks, and set the Deny public network access as ''YES''.

Fig-2: Firewalls & Virtual Network settings.

Once you finish your Firewalls & Virtual Network settings, now your Private endpoint is created and you can connect to your Azure SQL database by using a private endpoint connection. 

Video Demo: How to use Private Endpoint for Azure SQL Database from Azure Data Factory

No comments:

Post a Comment