Azure SQL Database Setup Guide
Here's instructions about how to setup Azure SQL Database as a data warehouse:
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
Server namein the Azure database dashboard overview.
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
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
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.