Events
31 Mar, 23 - 02 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article is a guide for configuring Azure Synapse Link for Azure SQL Database with network security. Before you begin, you should know how to create and start Azure Synapse Link for Azure SQL Database from Get started with Azure Synapse Link for Azure SQL Database.
In this section, you create an Azure Synapse workspace with a managed virtual network enabled. For Managed virtual network, you'll select Enable, and for Allow outbound data traffic only to approved targets, you'll select No. For an overview, see Azure Synapse Analytics managed virtual network.
Sign in to the Azure portal.
Go to your Azure Synapse workspace, select Networking, and then select the Allow Azure Synapse Link for Azure SQL Database to bypass firewall rules checkbox.
Open Synapse Studio, go to Manage, select Integration runtimes, and then select AutoResolvingIntegrationRuntime.
In the pop-up window, select the Virtual network tab, and then enable Interactive authoring.
From the Integrate pane, create a link connection to replicate data from your Azure SQL database to an Azure Synapse SQL pool.
Start your link connection.
In this section, you create an Azure Synapse workspace with managed virtual network enabled. You'll enable Managed virtual network, and you'll select Yes to limit outbound traffic from the managed workspace virtual network to targets through managed private endpoints. For an overview, see Azure Synapse Analytics managed virtual network.
Sign in to the Azure portal.
Go to your Azure Synapse workspace, select Networking, and then select the Allow Azure Synapse Link for Azure SQL Database to bypass firewall rules checkbox.
Open Synapse Studio, go to Manage, select Integration runtimes, and then select AutoResolvingIntegrationRuntime.
In the pop-up window, select the Virtual network tab, and then enable Interactive authoring.
Create a linked service that connects to your Azure SQL database with a managed private endpoint enabled.
a. Create a linked service that connects to your Azure SQL database.
b. Create a managed private endpoint in a linked service for the Azure SQL database.
c. Complete the managed private endpoint creation in the linked service for the Azure SQL database.
d. Go to the Azure portal for your SQL Server instance that hosts an Azure SQL database as a source store, and then approve the private endpoint connections.
Now you can create a link connection from the Integrate pane to replicate data from your Azure SQL database to an Azure Synapse SQL pool.
Start your link connection.
If you're using a database other than an Azure SQL database, see:
Events
31 Mar, 23 - 02 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Get started with Azure Synapse Link for Azure SQL Database - Azure Synapse Analytics
Learn how to connect an Azure SQL database to an Azure Synapse workspace with Azure Synapse Link.
Azure Synapse Link for Azure SQL Database - Azure Synapse Analytics
Learn about Azure Synapse Link for Azure SQL Database, the link connection, and monitoring the Synapse Link.
Create Azure Synapse Link for SQL Server 2022 - Azure Synapse Analytics
Learn how to create and connect a SQL Server 2022 instance to an Azure Synapse workspace by using Azure Synapse Link.