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.

Faster bulk writes

For faster bulk writes into your Azure SQL database, you should turn on the Use Azure blob storage for faster bulk loading option:

This option requires two prerequisites:

1. Set up an Azure Blog Storage bucket and enter its access key credentials (see instructions).
2. Create a master key password on the Azure SQL database you're syncing to. See Microsoft's instructions here .

Once done, click Save. With this option on, Polytomic will take a faster path when syncing data to your Azure SQL database.