Open navigation

How to connect Azure Synapse to Supermetrics

This guide will walk you through how to log into the Supermetrics Azure Synapse data source.


Before you begin


Instructions

Step 1: Make sure you have database access
In order to connect to Azure Synapse, your Azure account must have access to the correct database. To check that you have the right access:
  1. Log in to Azure.
  2. >Enter “sql databases" in the search box at the top of the page.
  3. Select SQL databases from the dropdown. Click the database that you want to connect to. If you don’t see the database listed on the page, ask an Azure administrator to give you access.
  4. A panel will open with database details. Enter “query editor” in the search box and select Query editor (preview).
  5. A new login page will open. On the right side under Active Directory authentication, select Continue as....
  6. If you can open the query editor, then you should have the database access needed to connect Supermetrics to Azure Synapse. If you can't use the query editor, ask an Azure administrator to give you access.
Step 2: Gather login details

To connect Supermetrics to Azure Synapse, you’ll first need to gather your:

  • Tenant ID
  • Workspace name
  • Database name

Tenant ID

You can acquire the Tenant ID either by checking with the Azure administrator, or by opening Microsoft Azure, and then searching for and clicking Tenant properties in the top search bar.


When you find it, copy the Tenant ID from the list of properties.


Workspace name

You can find the workspace name (also called the server name) either by checking with your Azure administrator, or by looking up the SQL server list in the Microsoft Azure portal.


Do this by opening Microsoft Azure and then searching for and clicking on SQL servers in the top search bar.


When you find the list of servers, copy the name of the server you want to query.


Database name

You can find the workspace name (also called the server name) either by checking with your Azure administrator, or by looking up the SQL server list in the Microsoft Azure portal.


Do this by opening Microsoft Azure and then searching for and clicking on SQL databases in the top search bar.


The name column should have both the database name and the workspace/server name. You just need to copy the database name.

Step 3: Log in

We recommend that the first login be carried out by an administrator account — the final step in the login process involves app permissions for your entire organization, and only administrators can adjust that setting.


If these app permissions aren’t accepted for the organization, non-admin users won’t be allowed to log in.

  1. Select the Azure Synapse data source in the destination you use with Supermetrics.
  2. Fill in your Tenant ID, Workspace name, and Database name.
  3. Log in to the Microsoft user account attached to the database.
  4. Accept the app permissions.
    The Consent on behalf of your organization setting is optional. If it isn’t enabled, non-admin users won’t be able to use Supermetrics with Azure Synapse.
  5. Close the login window when prompted.

You’re now ready to start pulling data from Azure Synapse with Supermetrics.

IP allowlisting

Your database must have the following IPs allowlisted. Adjust this setting in the Firewalls and virtual which can be done in Firewalls and virtual networks section of database config. 

  • 3.251.34.121 
  • 46.137.101.254 
  • 54.194.240.160 
  • 34.250.96.130 
  • 23.20.234.176

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.