Set Up an Azure Synapse Connection

Set up the Azure Synapse connection to start the flow of data into Data 360.

User Permissions Needed 
To create a connection:System Admin profile or Data Cloud Architect permission set

Before you begin:

  • Enable the Beta connector through the feature manager. See Enable Data 360 Features.
  • Verify your admin has enabled firewalls on the system you want Data 360 to connect to by including these IP addresses to your allowlists.

  1. In Data Cloud, click Setup, and select Data Cloud Setup.

  2. Under Configuration, select Connectors.

  3. Click New.

  4. On the Source tab, select Azure Synapse and click Next.

  5. Enter a connection name, connection API name, and provide the authentication and connection details.

  6. For Authentication Details, select the Authentication Method that you want to use from the dropdown.

    1. For SQL Username and Password, enter the SQL Server username and password to authenticate the user.
    2. For Microsoft Entra (formerly Active Directory) Username and Password, enter the Microsoft Entra username and password to authenticate the user.

  7. For Password, enter the password to authenticate the user.

  8. For Connection URL, provide the URL in this format {subdomain}.sql.azuresynapse.net{:port}

    1. The subdomain can have 1–50 characters, including lowercase letters (a–z), numbers (0–9), and hyphens (-). The subdomain can’t start or end with hyphens.
    2. The port is optional. If included, the port is 4–5 numbers and prefixed with a colon (:).

  9. For Schema, enter the database schema that the user’s access is limited to for this connection.

  10. For Database, enter the Azure Synapse database that the user’s credentials are authorized to authenticate to.

  11. To review your configuration, click Test Connection.

  12. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams.