ht
Documentation
WelcomeConcepts

Get Started

OverviewCreate a sourceCreate a modelCreate a destinationCreate a sync

Sources

Amazon AthenaAmazon RedshiftDatabricksGoogle BigQueryGoogle SheetsLookerMySQLPostgreSQLRocksetSnowflakeSQL ServerTrino
Documentation/Sources/Sqlserver
ht
Documentation

SQL Server

Table of Contents
Create the Warehouse connection in Hightouch
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.

Create the Warehouse connection in Hightouch

Hightouch will always connect to your warehouse from 54.196.30.169 or 52.72.201.213. You may allow-list this IP address in your VPC security groups.
  1. In Hightouch, go to Sources or click https://app.hightouch.io/sources
  2. Click "Add Source"
  3. Select SQL Server, and click "Connect Source"
  4. Enter your hostname (IP address or Azure hostname)
  5. For Port, enter your port. This is 1433 by default.
  6. For Database, enter your database name.
  7. For Username, enter your SQL Server username.
  8. For Password, enter your SQL Server password
  9. Click "Test" to test the connection. Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page
If you see the following error message, you need to update your firewall settings in your Azure Console.

Azure Firewall Setup

By default, Azure will protect your SQL Server from any external IP address from connecting to your SQL Server. Below are the steps to add Hightouch's IP addresses to the firewall.
  1. Log into your Azure Console Dashboard
  2. Click on "SQL databases"
  3. Select the SQL database that you want to update
  4. Click on "Set server firewall"
  5. Add Rules for our 2 server IPs, 54.196.30.169, 52.72.201.213 as hightouch1 and hightouch2 respectively
  6. Click save button in top upper left corner

Tunneling

If your SQL Server is not "publicly accessible", you have two options
  • SSH tunnel: Hightouch will connect to your SQL Server via an SSH tunnel established from Hightouch's servers to a bastion server in your VPC.
  • Reverse SSH tunnel: You will establish an SSH connection from a bastion server in your VPC to Hightouch's servers, and Hightouch will reuse that connection to connect to SQL Server.
Both of these options are now self-serve and can be referenced here.