1. DB Best Documentation
  2. Database Compare Suite
  3. Connecting to an Azure Synapse Analytics data warehouse
Database Compare Suite™

Connecting to an Azure Synapse Analytics data warehouse

Use the following procedure to connect to your Azure Synapse Analytics data warehouse (formerly Azure SQL Data Warehouse).

  1. Click the New icon in the Project panel at the top left corner of the window.

  2. Select Azure Synapse Analytics in the Platform drop-down list at the top of the dialog box.

  3. Select the Standard option in the Mode drop-down list if you would like to connect to an Azure Synapse Analytics data warehouse in the standard mode.

    • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been already used).

    • Provide the rest of connection information to the Azure Synapse Analytics Data Warehouse: Server Port, Authentication method, Database and Username. You can enter these values manually or select them from drop-down lists. Authentication method can only be chosen from the drop-down list, which includes the following options: Standard Server Authentication, Active Directory Integrated, and Active Directory Password.

    • Enter Password to complete the information about the Azure Synapse Analytics connection.

    • Check the Use SSL option to establish a secure connection to the Microsoft SQL Server database.

    • Press the Test button to verify that you can successfully connect to your Azure Synapse Analytics data warehouse.

  4. Select the Connection String option in the Mode drop-down list if you would like to connect to an Azure Synapse Analytics data warehouse using special connection string.

    • Enter the Connection string manually or select from the drop-down list (if it has been used already).

    • Find the connection string template below. Use it as an example to create a connection string that allows to connect to your Azure Synapse Analytics data warehouse:

      Data Source=azure_sa_server.database.windows.net;Initial Catalog=AZURE_SA_DB;Integrated Security=False;User ID=azure_sa_user;Password=pass;Pooling=False;Application Name="DB Best Database Compare Suite";Connect Timeout=300

    • Press the Test button to verify that you can successfully connect to your Azure Synapse Analytics data warehouse.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].