JDBC Driver for Azure Synapse

Build 24.0.9060

AuthScheme

The scheme used for authentication. Accepted entries are Password, AzureAD, AzureServicePrincipal, AzureServicePrincipalCert, AzureMSI, AzurePassword.

Possible Values

AzureAD, AzureMSI, AzureServicePrincipal, AzureServicePrincipalCert, Password, AzurePassword

Data Type

string

Default Value

"Password"

Remarks

  • AzureAD: Set this to perform Azure Active Directory OAuth authentication.
  • AzureMSI: Set this to automatically obtain Managed Service Identity credentials when running on an Azure VM.
  • AzureServicePrincipal: Set this to authenticate as an Azure Service Principal using a Client Secret.
  • AzureServicePrincipalCert: Set this to authenticate as an Azure Service Principal using a Certificate.

Together with Password and User, this field is used to authenticate against the server. Password is the default option. Use the following options to select your authentication scheme:

  • Password: Set this to use your SQL Server Password.
  • AzureAD: Set this to use Azure Active Directory OAuth authentication.
  • AzureServicePrincipal: Set this to authenticate as an Azure Service Principal.
  • AzureServicePrincipalCert: Set this to authenticate as an Azure Service Principal using a certificate.
  • AzureMSI: Set this to use Azure Active Directory Managed Service Identity authentication.
  • AzurePassword: Set this to use Azure Active Directory Password authentication.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060