The scheme used for authentication. Accepted entries are Password, AzureAD, AzurePassword, AzureMSI, AwsIAMRoles, AwsEC2Roles, GCPServiceAccount.

Possible Values

Data Type

string

Default Value

""

Remarks

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 PostgreSQL Server Password.
• AzureAD: Set this to use Azure Active Directory OAuth authentication.
• AzurePassword: Set this to use Azure Active Directory Password authentication.
• AzureMSI: Set this to use Azure Active Directory MSI (Managed Service Identity) authentication.
• AwsIAMRoles: Set this to use Amazon Web Services IAM Roles to connect PostgreSQL Server in Amazon RDS instance.
• AwsEC2Roles: Set this to automatically use IAM Roles assigned to the EC2 machine the CData SSIS Components for PostgreSQL is currently running on.
• GCPServiceAccount: Set this to use Google Service Account to authenticate to your PostgreSQL Google SQL Cloud instance.