Connecting to Microsoft Azure Synapse SQL using an Azure private endpoint

Back Next

Configure settings for Microsoft Azure Synapse SQL connection

Configure the settings for the Microsoft Azure Synapse SQL connection to use the private endpoint.

When you set up the Microsoft Azure Synapse SQL connection, select the Secure Agent installed on the virtual machine that you created and enable the virtual network.

You can use a private endpoint when you stage files in Microsoft Azure Data Lake Storage Gen2 and use the service principal authentication or shared key authentication to connect to the storage.

Click

Administrator

Edit an existing connection or create a new connection.

Select the Secure Agent installed on the virtual machine and enable the virtual network in the connection properties.

Click

Test Connection

, and then click

Save

Administrator

, navigate to

Advanced Clusters

to create or modify an Advanced Configuration.

In the

Advanced Configuration

tab, add the Vnet and Subnet properties that is linked with the private DNS zone. This helps to spawn the cluster resources under this subnet and provide access to the private DNS zone.

This image displays vnet and subnet properties in advanced cluster.

You can also configure a private endpoint to connect to Microsoft Azure Data Lake Storage Gen2 to stage files.

For more information, see the Informatica How-To Library article, Connecting to an Azure storage account using an Azure private endpoint.

Rename Saved Search

Table of Contents

Connecting to Microsoft Azure Synapse SQL using an Azure private endpoint

Connecting to Microsoft Azure Synapse SQL using an Azure private endpoint

Configure settings for Microsoft Azure Synapse SQL connection

Configure settings for Microsoft Azure Synapse SQL connection