Auth Type

Key Name Default Value Required

N/A

Standard

Yes, when you configure a DSN using the Simba Amazon Redshift ODBC Connector DSN Setup dialog box.

Description

This option specifies the authentication mode that the connector uses when you configure a DSN using the Simba Amazon Redshift ODBC Connector DSN Setup dialog box:

  • Standard: Standard authentication using your Redshift user name and password.
  • AWS Profile: IAM authentication using a profile.
  • AWS IAM Credentials: IAM authentication using IAM credentials.
  • Identity Provider: AD FS: IAM authentication using Active Directory Federation Services (AD FS).
  • Identity Provider: Azure AD: IAM authentication using Azure AD portal.
  • Identity Provider: Browser Azure AD: IAM authentication using a browser plugin for Azure AD portal.
  • Identity Provider: Browser Azure AD OAuth2: IAM authentication using a browser plugin for Azure AD OAuth2 portal.
  • Identity Provider: JWT: IAM authentication using a JSON Web Token (JWT).
  • Identity Provider: Okta: IAM authentication using Okta service.
  • Identity Provider: PingFederate: IAM authentication using PingFederate service.

Note:

This option is available only when you configure a DSN using the Amazon Redshift ODBC Driver DSN Setup dialog box.

When you configure a connection using a connection string, the connector automatically determines whether to use Standard, AWS Profile, or AWS IAM Credentials authentication based on your specified credentials. To use an identity provider, you must set the plugin_name property. For more information, see plugin_name.

Related topics