Azure SQL Database Setup Guide

Here's instructions about how to setup Azure SQL Database as a data warehouse:

Enable access

Decide whether to connect to your warehouse directly or connect using an SSH tunnel.

• If you decide to connect directly to your database, you will need to create a firewall rule to allow access. This is the simplest and most secure method.
• If you decide to connect using an SSH tunnel, Fivetran will connect to a separate server in your network which provides an SSH tunnel to your database. This method is necessary if your database is in an inaccessible subnet on a virtual network. To connect using an SSH tunnel, follow these instructions.

The Fivetran data processing servers will need access to your database server. You will need to configure the firewall.

Configure server firewall

Open the SQL database firewall settings in the Azure console

Select "SQL database" on the left pane. Then select the SQL database that you want to replicate.

Click "Set server firewall"

Add a new firewall rule to whitelist Fivetran's IPs

Remember to Save!

Enter host and port in wizard

• Host: Server name in the Azure database dashboard overview.

• Port: 1433

---

Create a Fivetran user

Add a container database user:

USE [<database>];
CREATE USER fivetran WITH PASSWORD = '<password>';

replacing with the name of your database and with a password of your choice.

Grant permissions to user

Once user fivetran is created, grant it CREATE permission for the database you would like Fivetran to sync.

GRANT CREATE SCHEMA ON DATABASE::[<database>] TO fivetran;
GRANT CREATE TABLE ON DATABASE::[<database>] TO fivetran;

Enter user, password and database in wizard

• User: enter fivetran@<servername>, where \<servername> is part of your azure host url: \<servername>.database.windows.net

• Password: the password you set

• Database: the database you want to replicate from.