Authentication Type: User Name and PasswordJTdCJTIydGl0bGUlMjIlM0ElMjJBdXRoZW50aWNhdGlvbiUyMFR5cGUlM0ElMjBVc2VyJTIwTmFtZSUyMGFuZCUyMFBhc3N3b3JkJTIyJTdE

Select Warehouse from the Category List.
There may be more than one warehouse connection.
For Providers, select Redshift.
For Authentication Type choose one of the following User Name and Password.
Enter the URL, Redshift user name, and password for Kyvos to connect to Redshift.
Click the SSL checkbox to configure the driver to use a non-validating SSL factor. Use this setting if the server you are connecting to uses SSL but does not require identity verification.
Click Properties to configure advanced settings or set JDBC-specific properties. All non-Kyvos properties are passed to the JDBC API.
In the Miscellaneous Properties section, provide the iam_role and the LoginTimeout value. The recommended value is 10.
Click Save.

Authentication Type: IAM Instance Profile CredentialsJTdCJTIydGl0bGUlMjIlM0ElMjJBdXRoZW50aWNhdGlvbiUyMFR5cGUlM0ElMjBJQU0lMjBJbnN0YW5jZSUyMFByb2ZpbGUlMjBDcmVkZW50aWFscyUyMiU3RA==

Select Warehouse from the Category List.
There may be more than one warehouse connection.
For Providers, select Redshift.
For Authentication Type choose IAM Instance Profile Credentials to configure the IAM role attached to the BI server.
Enter the URL, Redshift User, and Redshift groups to map to the IAM role.
The JDBC URL can be fetched from AWS Redshift Console and has the following format: jdbc:redshift:iam://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev
Click the Properties link to add the following properties and specify the value as per the configuration.
1. DbGroups: Enter the value of the RedShift Database group.
2. iam_role: Enter the IAM role configured on your RedShift cluster.
In the Miscellaneous Properties section, provide the Redshift iam_role and the LoginTimeout value. The recommended value is 10.
Click Test to validate the connection. Once it is valid, click Save.

Browser not supported