Skip to main content

​
Authenticate to Azure Synapse

After you add the connector, you need to set the required properties.
  • Server: Enter the name of the server that runs Azure Synapse.
  • Port: Enter the port number for Azure Synapse. The default port value is 1433.
  • Database: Enter the name of the Azure Synapse database.
supports authenticating to Azure Synapse in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

​
Password

​
Azure Active Directory

​
Azure Managed Service Identity

​
Azure Service Principal

​
Azure Service Principal Certificate

​
AzurePassword

​
Complete Your Connection

To complete your connection:
  1. For Batch Mode, select the mode that you want to use for inserting bulk data.
    • BCP
    • COPY: Specify the following settings:
      • Azure SAS Token: Enter the string value of your Azure Blob shared access signature (SAS). To obtain this value:
        1. In the Azure portal, select Settings > Shared access signature for your Azure Blob container.
        2. Click Generate SAS token and URL and copy the value that is generated in the Blob SAS token text box. Note: Make sure that you select the proper permission (Create, Write, Delete) from the Permissions list and verify the validity of the Start and Expiry times before you generate the SAS token.
      • Storage Acount Location: Enter the storage-account location where you want to stage your data.
    • STANDARD
  2. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
  3. If you authenticate with AzureAD, AzureMSI, AzureServicePrincipal, AzureServicePrincipalCert, or AzurePassword, click Connect to Azure Synapse to connect to your Azure Synapse account.
  4. Click Create & Test to create your connection.