Connecting to Amazon Redshift through IAM Authentication Using Okta

Published: 24 Oct 2023
Last Modified Date: 24 Oct 2023

Question

How to connect Tableau Desktop to Redshift through IAM authentication using Okta

Environment

Tableau Desktop
Amazon Redshift

Answer

Start Tableau Desktop and under Connect, select Amazon Redshift. For a complete list of data connections, select More under To a Server.
Enter the name of the server that hosts the database and the name of the database you want to connect to.
Enter the user name and password.
Select the Require SSL check box.
Select the Advanced tab and enter custom driver parameters to modify the connection. For example: IAM=1; plugin_name=okta; IdP_Host=example.okta.com; App_ID=mQkRaOqFRNy5hAc262lW;
Select Sign In.

Additional Information

For more information about the IdP details and other driver parameters required, see Step 5: Configure a JDBC or ODBC connection to use IAM credentials and the Amazon Redshift ODBC Connector Install Guide.

Disclaimer: The above links take you outside of Tableau.com. Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.