> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Connecting to Azure SQL

> Connect Azure SQL Database to Integrate.io ETL for reading and writing data. Configure firewall rules, credentials, and connection settings.

Integrate.io ETL can read data from your [Azure SQL databases](https://www.integrate.io/blog/microsoft-etl-understanding-etl-with-azure-data-factory/) or write data to them. This article discusses providing Integrate.io ETL access on your Azure SQL database and then details creating the Azure SQL database connection in Integrate.io ETL. You must provide Integrate.io ETL access to your Azure SQL database. If it is behind a firewall:

* Create a user and grant it minimum permissions required for Integrate.io ETL to read or write data from the database.
* Add rules in your [database firewall](https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql) to allow access for Integrate.io ETL's IP addresses. Add a rule for each IP relevant to your account's region using [this list](/etl/integrateio-etls-ip-list/) (Refer to [this](/etl/allowing-integrateio-etl-access-to-my-server-behind-a-firewall/) article if you'd prefer to create an SSH tunnel or reverse SSH tunnel.)

## To create an Azure SQL database connection In Integrate.io ETL

<Steps>
  <Step>
    Click the Connections icon (lightning bolt) on the top left menu.
  </Step>

  <Step>
    To create a connection, click **New connection**.

    <Frame>
      <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-9.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=adc41a7e781b24338aad90324a15af89" alt="New connection button in the Connections page" width="1200" height="879" data-path="images/connectivity-and-security/image-9.webp" />
    </Frame>
  </Step>

  <Step>
    Select Azure Synapse Analytics.

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-10.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=f86ee139c0af9327a4186a2166de9fde" alt="Selecting Azure Synapse Analytics as the connection type" width="1200" height="879" data-path="images/connectivity-and-security/image-10.webp" />
    </Frame>
  </Step>

  <Step>
    Enter your Azure SQL database server name as the host name.
  </Step>

  <Step>
    Use the pattern **user\@server\_name** as the user name. Replace user with the user designated for Integrate.io ETL and server\_name with your Azure SQL database server name.
  </Step>

  <Step>
    Enter the user's password.
  </Step>

  <Step>
    Enter the database name.
  </Step>

  <Step>
    Click **Test Connection** to make sure the connection details are correct.
  </Step>

  <Step>
    Click **Create connection** to create the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-11.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=fd4f0c2dc54dee954026c67ae7f00f93" alt="Completed Azure SQL connection configuration form" width="1200" height="827" data-path="images/connectivity-and-security/image-11.webp" />
    </Frame>
  </Step>
</Steps>

Also reference [Allowing Integrate.io ETL access to Azure Synapse Analytics](/etl/allowing-integrateio-etl-access-to-azure-synapse-analytics/).