• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. User Guide
  4. Connecting to a Cluster
  5. Connecting to a Cluster Using IAM Authentication
  6. Overview

Overview

DWS allows you to access databases using IAM authentication. When you use the JDBC application program to connect to a cluster, set the IAM username, credential, and other information as you configure the JDBC URL. After doing this, when you try to access a database, the system will automatically generate a temporary credential and a connection will be set up.

NOTE:

Currently, only clusters whose version is 1.3.1 or later (including 1.3.1) and corresponding JDBC driver provided by DWS can access the databases in IAM authentication mode.

IAM supports two types of user credential: password and Access Key ID/Secret Access Key (AK/SK). JDBC connection requires latter.

The IAM account you use to access a database must be granted with the DWS Database Access permission. Without this permission, access to databases will fail due to authentication failure.

The process of accessing a database is as follows:

  1. Granting an IAM Account the DWS Database Access Permission
  2. Creating an IAM User Credential
  3. Configuring the JDBC Connection to Connect to a Cluster Using IAM Authentication