Microsoft Azure Synapse SQL Connector > Introduction to Microsoft Azure Synapse SQL Connector > Administration of Microsoft Azure Synapse SQL Connector
  

Administration of Microsoft Azure Synapse SQL Connector

As a user, you can use Microsoft Azure Synapse SQL connector after the organization administrator performs the following tasks:
For more information, see the Informatica How-To Library article, "Prerequisites to Create a Microsoft Azure Synapse SQL connection": https://docs.informatica.com/integration-cloud/cloud-data-integration-connectors/h2l/1603-prerequisites-to-create-a-microsoft-azure-synapse-sql-conne/abstract.html

Azure Active Directory authentication

You can configure Azure Active Directory (AAD) authentication to connect to Microsoft Azure Synapse SQL. Default is Microsoft SQL Server authentication.
To configure the AAD authentication, perform the following tasks:

Import server certificate

Applicable if a trust store file is not configured for your organization and you want to use AAD authentication with Active Directory Federation Services in Azure. Import the server certificate to the following location:
<Secure Agent installation directory>\jdk\jre\lib\security\cacerts
Use the following command to import the certificate:
keytool -import -trustcacerts -alias <alias name of the certificate> -file <certificate file path> -keystore <Secure Agent installation directory>\jdk\jre\lib\security\cacerts -storepass <password for the truststore>

Set admin

Perform the following steps to set admin between Microsoft SQL Server that has the Microsoft Azure Synapse SQL hosted and the Azure Active Directory:
  1. 1. Log on to the Microsoft Azure portal using your credentials. The Dashboard page appears.
  2. 2. From the All Resources page, select the Microsoft SQL Server that has the Microsoft Azure Synapse SQL hosted.
  3. 3. Select the Active Directory admin option under Settings displayed for the Microsoft SQL Server. The image shows the Active Directory admin settings:This image shows the Set admin option for Azure Active Directory.
  4. 4. Click Set admin. The Add admin page appears.
  5. 5. Enter the email ID that you want to use as admin and click Select.
  6. 6. Click Save.

Create a user

Perform the following steps to create a user:
  1. 1. Connect to Microsoft Azure Synapse SQL using the Azure Active Directory admin created in the previous steps. You can use Microsoft SQL Server Management Studio to connect to the Microsoft Azure Synapse SQL.
  2. 2. Type and run the following command to create a user: create user [user@foobar.com] from external provider;
  3. For more information, see Microsoft Azure documentation.
  4. 3. Assign the required privileges to the user.
Configure the JDBC URL and the user you created in connection properties to enable AAD authentication.