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:
- Access and ability to create, query, update, rename, drop, insert and delete from objects in a given schema within a database. Learn more about GRANT (Transact-SQL).
- Query table and column metadata information. Learn more about System Information Schema Views (Transact-SQL).
Alternatively, you can use your SQL Server Admin login credentials to create the destination on the Supermetrics Hub.
IP allowlisting
If your organization only allows access from “selected networks”, you need to add the Supermetrics IP addresses to the Firewall settings in your SQL Server.
Learn about the permissions you need to modify in Firewall settings.
Go to Networking → Connectivity → Connection Policy, and set the connection policy to "Default" mode. Learn more about connection policy in Azure SQL Database.