Open navigation

About Azure SQL Database prerequisites

Before you can begin using Azure SQL database as a Supermetrics destination, you should ensure that you’ve met the prerequisites below. 


Note that items from Azure Synapse — for example, database names or database schemas — aren’t compatible with Azure SQL destinations.


Prerequisites

SQL server

You need an existing SQL Server in Azure, and a database set up for that server.


Permissions

If you’d prefer to create the destination with a user account, make sure it has permission to:

Alternatively, you can use your SQL Server Admin login credentials to create the destination in the Supermetrics Team Site.


IP allowlisting

If your organization only allows access from “selected networks”, add the following Supermetrics IP addresses to the Firewall settings in your SQL Server. Learn about the permissions you need to modify Firewall settings

Don’t forget to add your own IP address.


  • <YOUR OWN IP ADDRESS>
  • 54.220.179.34
  • 54.155.253.26
  • 54.217.129.200
  • 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.