Amazon Redshift simplifies the use of JDBC/ODBC with authentication profile
Amazon Redshift now supports an authentication profile that enables administrators to centrally store client-side properties required to connect Redshift data warehouse using JDBC/ODBC/Python drivers. You can create an authentication profile by specifying a JSON file with the name and value for the required client and extended properties. End-users such as analysts, developers, and data engineers can use these profiles with client tools such as SQL Editors, BI Tools, and ETL tools.
Amazon Redshift now supports an authentication profile that enables administrators to centrally store client-side properties required to connect Redshift data warehouse using JDBC/ODBC/Python drivers. You can create an authentication profile by specifying a JSON file with the name and value for the required client and extended properties. End-users such as analysts, developers, and data engineers can use these profiles with client tools such as SQL Editors, BI Tools, and ETL tools.
You can create an authentication profile using Redshift API. This feature is now available in all commercial regions. You can use this feature with AWS SDK version 1.12.23 and JDBC driver version 2.0.0.7 and later.
For more information, including instructions on getting started with authentication profile, please read the Amazon Redshift API documentation.