Configure Azure Synapse Analytics Integration

This page provides a tutorial for enabling the native Azure Synapse Analytics integration on the Immuta app settings page. To configure this integration via the Immuta API, see the Configure an Azure Synapse Analytics integration API guide.

For an overview of the integration, see the Azure Synapse Analytics overview 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 Native 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: Grant Immuta one-time use of credentials to automatically configure your environment and the integration.

• Manual setup: Run the Immuta script in your Azure Synapse Analytics environment yourself to configure the integration.

Automatic setup

Enter the username and password 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.

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.

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.

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.