# Configure Azure Synapse Analytics Integration

This page provides a tutorial for enabling the Azure Synapse Analytics integration on the Immuta app settings page. To configure this integration via the Immuta API, see the [Integrations API getting started guide](https://documentation.immuta.com/2024.3/developer-guides/api-intro/integrations-api/getting-started).

For an overview of the integration, see the [Azure Synapse Analytics overview](https://documentation.immuta.com/2024.3/integrations/azure-synapse-analytics/reference-guides/azure-synapse-analytics) documentation.

## Requirement

A running Dedicated SQL pool is required.

## Add an Azure Synapse Analytics integration

1. Click the **App Settings** icon in the left sidebar.
2. Click the **Integrations** tab.
3. Click the **+Add Integration** button and select **Azure Synapse Analytics** from the dropdown menu.
4. Complete the **Host**, **Port**, **Immuta Database**, and **Immuta Schema** fields.
5. Opt to check the **Enable Impersonation** box and customize the **Impersonation Role** name as needed. This will allow users to natively impersonate another user.
6. Opt to update the **User Profile Delimiters**. This will be necessary if any of the provided symbols are used in user profile information.

### Select your configuration method

You have two options for configuring your Azure Synapse Analytic environment:

* [**Automatic setup**](#automatic-setup): Grant Immuta one-time use of credentials to automatically configure your environment and the integration.
* [**Manual setup**](#manual-setup): Run the Immuta script in your Azure Synapse Analytics environment yourself to configure the integration.

#### Automatic setup

Enter the [username and password](#user-content-fn-1)[^1] in the **Privileged User Credentials** section.

#### Manual setup

1. Select **Manual**.
2. Download, fill out the appropriate fields, and run the bootstrap master script and bootstrap script linked in the **Setup** section.
3. Enter the **username** and **password** in the **Immuta System Account Credentials** section. The username and password provided must be the credentials that were set in the bootstrap master script when you created the user.

### Save the configuration

Click **Save**.

### Register data

[Register Azure Synapse Analytics data in Immuta](https://documentation.immuta.com/2024.3/data-and-integrations/registering-metadata/register-data-sources/query-backed-tutorial).

## Edit an Azure Synapse Analytics integration

1. Click the **App Settings** icon in the left sidebar.
2. Navigate to the Integrations tab and click the **down arrow** next to the Azure Synapse Analytics Integration.
3. Edit the field you want to change. *Note any field shadowed is not editable, and the integration must be disabled and re-installed to change it.*
4. Enter **Username** and **Password**.
5. Click **Save**.

{% hint style="info" %}
**Immuta requires temporary, one-time use of credentials with specific permissions.**

When performing edits to an integration, Immuta requires temporary, one-time use of credentials of a Superuser or a user with the Manage GRANTS permission

Alternatively, you can download the **Edit Script** from your Azure Synapse Analytics configuration on the Immuta app settings page and run it in Azure Synapse Analytics.
{% endhint %}

## Remove an Azure Synapse Analytics integration

1. Click the **App Settings** icon in the left sidebar.
2. Navigate to the Integrations tab and click the **down arrow** next to the Azure Synapse Analytics Integration.
3. Click the **checkbox** to disable the integration.
4. Enter the username and password that were used to initially configure the integration.
5. Click **Save**.

[^1]: Immuta only supports the SQL authentication option for Azure Synapse Analytics. The Microsoft Entra authentication option is unsupported. See the [SQL Authentication in Azure Synapse Analytics documentation](https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/sql-authentication?tabs=serverless) for details.