Using an IAM Profile

You can configure the connector to authenticate the connection using credentials that are associated with an IAM profile in a credentials file.

By default, the connector uses the credentials associated with a profile named default in the credentials file found in the %USERPROFILE%.awscredentials directory. To use a different profile, specify the profile name in your connection settings. To use a different credentials file, set the AWS_SHARED_CREDENTIALS_FILE system environment variable to the full path of your credentials file.

For information about the format of a credentials file, see the "AWS Credentials File Format" section from the "Working with AWS Credentials" page in the AWS SDK for Java Developer Guide: http://docs.aws.amazon.com/sdk-for-java/v1/developer-guide/credentials.html.

To configure authentication using an IAM profile:

  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 Profile.
  3. In the AWS Profile field, type the name of the profile to use.
  4. Optionally, in the Preferred Role field, type the Amazon Resource Name (ARN) of the role you want to assume when authenticating through an external credential service.
  5. To save your settings and close the Authentication Options dialog box, click OK.

Related topics