Skip to main content
  • Create a user and grant it minimum permissions required for Integrate.io ETL to read or write data from the database.
  • Allow access from Integrate.io ETL’s IP addresses to your SQL Server database port (Refer to this article if you’d prefer to create an SSH tunnel or reverse SSH tunnel.) Note: We only support “Default” connection policy on Azure SQL/Synapse Analytics.

​
To create a Microsoft SQL Server database connection in Integrate.io ETL

1
Click the Connections icon (lightning bolt) on the top left menu.
2
To create a connection, click New connection.
New connection button in the Connections page
3
Select SQL Server and name the connection.
Selecting SQL Server as the connection type
4
Select your access type (direct connection if you’ve whitelisted Integrate.io ETL’s IP addresses.)
5
Enter your SQL Server database server name as the hostname.
6
Enter the database name.
7
Enter the user name. Use the pattern user@server_name as the user name.
8
Enter the user’s password.
9
Click Test Connection to make sure the connection details are correct.
10
Click Create connection to create the connection.
SQL Server connection configuration form with host, database, and credentials
Successful SQL Server connection test confirmation
Last modified on May 12, 2026