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: 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 2: Log in to the Supermetrics Azure Synapse data source

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.

Did you find it helpful? Yes No

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