The scheme used for authentication. If this property is left blank, the default authentication is used.

Possible Values

Password, AzureAD, AzureServicePrincipal, AzureServicePrincipalCert, AzurePassword, AzureMSI, AwsIAMRoles, AwsEC2Roles, GCPServiceAccount

Data Type

string

Default Value

"Password"

Remarks

Along with the Password and User fields, the AuthScheme property is used for server authentication. Use the following options to select your authentication scheme:

• Password (default): Authenticate using the PostgreSQL Server Password.
• AzureAD: Authenticate using the Azure Active Directory OAuth authentication.
• AzureServicePrincipal: Authenticate using the client credentials to authenticate as an Azure Service Principal.
• AzureServicePrincipalCert: Authenticate using a certificate to authenticate as an Azure Service Principal.
• AzurePassword: Authenticate using the Azure Active Directory Password authentication.
• AzureMSI: Authenticate using the Azure Active Directory Managed Service Identity (MSI) authentication.
• AwsIAMRoles: Authenticate using Amazon Web Services IAM Roles to connect to the PostgreSQL Server in an Amazon RDS instance.
• AwsEC2Roles: Authenticate using the IAM Roles linked to the EC2 machine where the CData JDBC Driver for PostgreSQL is running.
• GCPServiceAccount: Authenticate using a Google Service Account to log in to the PostgreSQL Google SQL Cloud instance.