Allowing ETL access to Microsoft SQL Server Databases ETL can read data from your Microsoft SQL Server databases or write data to them. This article discusses providing ETL access on your Microsoft SQL Server database and then details creating the SQL Server database connection in ETL.

You must provide ETL access to your Microsoft SQL Server database. If it is behind a firewall:

  • Create a user and grant it minimum permissions required for ETL to read or write data from the database.
  • Allow access from 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 ETL:

  1. Click the Connections icon (lightning bolt) on the top left menu.
  2. To create a connection, click New connection. thumbnail image
  3. Choose SQL Server and name the connection.
  4. Select your access type (direct connection if you've whitelisted 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. thumbnail image