Skip to main content

Azure SQL Database (Service Principal)

Connect to Azure SQL Database using service principal

To use this connection type within the API, use a ConnectionTypeCode of AZURE-SQL-SP.

Variable Reference​

The following variables are supported:

  • DatabaseConnectionStringSecretName - (Required) The name of the Key Vault secret containing the connection string to the database.

  • ServicePrincipalTenantIdSecretName - (Required) The name of the Key Vault Secret containing the value of the Tenant ID of the Service Principal used to access the database.

  • ServicePrincipalClientIdSecretName - (Required) The name of the Key Vault Secret containing the value of the Client (Application) ID of the Service Principal used to access the database.

  • ServicePrincipalClientSecretSecretName - (Required) The name of the Key Vault Secret containing the value of the Client Secret of the Service Principal used to access the database.

  • IntegrationRuntime - (Required) Integration Runtime to use for Copy Activity.