Using IAM Credentials

You can configure the connector to authenticate the connection using an access key and a secret key that is specified directly in the connection information.

If you are using temporary credentials, which are only valid for a limited amount of time, then you must also provide a session token. For more information, see "Temporary Security Credentials" in the AWS Identity and Access Management User Guidehttp://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_temp.html.

To configure authentication using IAM credentials:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Authentication Options.
  2. From the Authentication Type drop-down list, select IAM Credentials.
  3. In the User field, type the access key provided by your AWS account.
  4. In the Password field, type the secret key provided by your AWS account.
  5. To encrypt your credentials, click Password Options and then select one of the following:
    • If the credentials are used only by the current Windows user, select Current User Only.
    • Or, if the credentials are used by all users on the current Windows machine, select All Users Of This Machine.
  6. If you are using temporary credentials, in the Session Token field, type the session token generated by the AWS Security Token Service.
  7. Optionally, to retrieve SAML credentials using Lake Formation service, select the LakeFormation Enabled checkbox.
  8. To save your settings and close the Authentication Options dialog box, click OK.