Configuring Authentication
Redshift databases require authentication. You can configure the connector to provide your credentials and authenticate the connection to the database, or to use a profile or credentials service.
You can set the connection properties described below in a connection string or in a DSN (in the odbc.ini
file). Settings in the connection string take precedence over
settings in the DSN.
The connector supports the following authentication methods:
- Standard authentication using your database user name and password
- IAM authentication using a profile
- IAM authentication using IAM credentials
- IAM authentication using Active Directory Federation Services (AD FS)
- IAM authentication using Azure AD service
- IAM authentication using a JSON Web Token (JWT)
- IAM authentication using Okta service
- IAM authentication using PingFederate service
- IAM authentication using a browser plugin for Azure AD
- IAM authentication using a browser plugin for Azure AD OAuth2
- IAM authentication using a browser plugin for a SAML service
For more information on IAM Roles and authentication, see http://docs.aws.amazon.com/IAM/latest/UserGuide/id_roles_use_switch-role-ec2.html.
For detailed authentication instructions, see the following topics: