> ## 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 Synapse Analytics

> Connect Azure Synapse Analytics to Integrate.io ETL for reading and writing analytical data. Configure access and connection settings.

In order to allow Integrate.io ETL access to your database, follow these steps:

<Steps>
  <Step>
    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/). (Note: We only support **"Default"** [connection policy](https://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings?view=azuresql\&tabs=azure-portal#change-the-connection-policy) on Azure SQL/Synapse Analytics)
  </Step>

  <Step>
    Add a SQL Server connection to your account.
  </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 Synapse Analytics 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-12.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=ffa1f1f309c8d6c9b945efa831ae9834" alt="Completed Azure Synapse Analytics connection configuration form" width="1200" height="827" data-path="images/connectivity-and-security/image-12.webp" />
    </Frame>
  </Step>
</Steps>