The Authentication tab allows you to specify your authentication settings. On this tab, select the authentication method you want to use to connect to the database and provide values for the relevant options; then, click Apply.

See "Authentication" for a general description and configuration details of the authentication methods supported by the driver.

Figure 1. Authentication tab

The Authentication Tab of the ODBC Driver for Redshift Setup dialog box

Connection Options: Security Description
User Name The default user ID that is used to connect to your database. Your ODBC application may override this value or you may override it in the logon dialog box or connection string.

Default: None
Authentication Method Determines which authentication method the driver uses when establishing a connection.

If set to 0 - Basic, the driver uses a hashed value, based on the concatenation of the user name and password, for authentication.

To specify the values required for Basic authentication, click Test Connect.

If set to 13 - AzureAD, the driver uses Azure AD authentication when establishing a connection.

If set to 39 - JWT, the driver uses JWT authentication when establishing a connection.

To specify the values required for JWT authentication, click Test Connect.

Default: 0 - Basic
Azure Client ID Specifies the client ID key for your application when authenticating to Amazon Redshift using Azure AD authentication.

Default: None
Azure Client Secret Specifies the client secret for your application when authenticating to Amazon Redshift using Azure AD authentication.

Default: None
Azure Tenant ID Specifies the ID of the Azure AD instance in which you create and manage your application. The driver uses this value when authenticating to Amazon Redshift using Azure AD authentication.

Default: None
AWS DB User Specifies your AWS user name when authenticating to Amazon Redshift using Azure AD authentication.

Default: None
Auto Create Determines whether the driver creates a new AWS user when authenticating to Amazon Redshift using Azure AD authentication.
Note: When creating a new AWS user, you must specify the name for the new AWS user in the AWS DB User field.

Default: Disabled
AWS DB Group Specifies the name of the AWS user group that your AWS user name is a part of. The driver uses this value when authenticating to Amazon Redshift using Azure AD authentication.

This is an optional field.

Default: None
AWS Region Specifies the name of the region that hosts your AWS server. The driver uses this value when connecting to an Amazon Redshift database using Azure AD authentication.
Note: The values must be specified for either AWS Region and AWS Cluster or Host Name and Port Number. If they are specified for all four of them, the values for Host Name and Port Number take precedence over those for AWS Region and AWS Cluster.

Default: None
AWS Cluster Specifies the name of the Amazon Redshift cluster that contains the database you want to connect to. The driver uses this value when connecting to an Amazon Redshift database using Azure AD authentication.
Note: The values must be specified for either AWS Region and AWS Cluster or Host Name and Port Number. If they are specified for all four of them, the values for Host Name and Port Number take precedence over those for AWS Region and AWS Cluster.

Default: None

If you finished configuring your driver, proceed to Step 4 in "Data source configuration through a GUI." Optionally, you can further configure your driver by clicking the following tabs. The following sections provide details on the fields specific to each configuration tab:

  • General tab allows you to configure options that are required for creating a data source.
  • Advanced tab allows you to configure advanced behavior.
  • Security tab allows you to specify security data source settings.
  • Failover tab allows you to specify failover data source settings.
  • Pooling tab allows you to specify connection pooling settings.