Azure SQL

Polytomic connects to Azure SQL using user credentials. While not required, we recommend you create a user exclusively for Polytomic so that the your database's audit logs distinguish all Polytomic activity.

1. Within your Azure SQL Portal obtain the Server credentials by navigating to the database or managed instance you want to query. On the overview page you'll see a Server name.

2. Within your Azure SQL portal determine the Database you plan to connect to.

3. Create a user within your Azure SQL Portal and save the Username and Password for later use.

4. In Polytomic, go to Connections → Add Connection → Azure SQL.

5. Enter your Azure SQL credentials in Polytomic's Server, Username, Password, Database, and Port fields.

6. Click Save.

Connecting via SSH

Polytomic supports connecting to Azure SQL via SSH. See Connecting via an SSH tunnel for more information.